using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using CodeCafe.Web;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

/// <summary>
/// Class to handle all database transactions to the ShoppingBasket table.
/// Generated by Code Cafe Class Generator Version 1.0
/// Create date: 5/4/2011 3:43:00 PM
/// </summary>

public class clsShoppingBasket
{
  /****************************************************************************************************/

  MSSqlTools db = new MSSqlTools();
  SqlDataReader rdr = null;
  SqlCommand cmd;
  
  public int sb_id;
  public int ui_id;
  public int sb_status;
  public DateTime sb_date;
  public int sb_paymentType;
  public string sb_code;
  public string sb_amount;
  public int sb_transactionStatus;
  public int sb_resultCode;
  public string sb_authCode;
  public string sb_subsId;
  public string sb_transId;
  public string sb_riskIndicator;
  public string sb_checksum;

  /****************************************************************************************************/

  public clsShoppingBasket()
  {
    Clear();
  }

  /****************************************************************************************************/
  /// <summary>
  /// Clears all the public variables
  /// </summary>
  public void Clear()
  {
    sb_id = 0;
    ui_id = 0;
    sb_status = 0;
    sb_date = DateTime.Now;
    sb_paymentType = 0;
    sb_code = "";
    sb_amount = "";
    sb_transactionStatus = 0;
    sb_resultCode = 0;
    sb_authCode = "";
    sb_subsId = "";
    sb_transId = "";
    sb_riskIndicator = "";
    sb_checksum = "";
  }

  /***************************************************************************************************************************************/
  /// <summary>
  /// Populates a drop down list with values from the Database
  /// </summary>
  /// <param name="List">
  /// The drop down list to populate all items in the list will be cleared
  /// </param>
  /// <param name="SelID">
  /// The Select record ID of a list item
  /// </param>
  /// <param name="ListType">
  /// Specifies the type of list
  /// </param>
  public void List(DropDownList List, int SelID, ListTypes ListType)
  {
    List.Items.Clear();
    switch (ListType)
    {
      case ListTypes.AllowNew:
        List.Items.Add(new ListItem("- Add New -", "0"));
        break;
      case ListTypes.AllowSelect:
        List.Items.Add(new ListItem("- Select -", "0"));
        break;
      case ListTypes.AllowNone:
        List.Items.Add(new ListItem("- None -", "0"));
        break;
    }
    try
    {
      db.DBase.Open();
      cmd = new SqlCommand("ShoppingBasket_List", db.DBase);
      cmd.CommandType = System.Data.CommandType.StoredProcedure;
      SqlParameter Error = cmd.Parameters.AddWithValue("@ErrorCode", 0);
      Error.Direction = System.Data.ParameterDirection.Output;

      rdr = cmd.ExecuteReader();
      while (rdr.Read())
      {
        ListItem item = new ListItem(rdr["ui_id"].ToString(), rdr["sb_id"].ToString());
        item.Selected = (int.Parse(rdr["sb_id"].ToString()) == SelID);
        List.Items.Add(item);
      }
      rdr.Close();
    }
    catch (Exception err)
    {
      Logger.Log(err);
    }
    finally
    {
      db.DBase.Close();
    }
  }

  /****************************************************************************************************/
  /// <summary>
  /// Loads record specified by ID and populates values into the public variables
  /// </summary>
  /// <param name="ID">
  /// Specifies the Primary key value of the record to load
  /// </param>
  /// <returns>
  /// True on successful load
  /// False if an error occurs
  /// </returns>
  public bool Load(int ContentID)
  {
    bool result = false;
    try
    {
      db.DBase.Open();
      cmd = new SqlCommand("ShoppingBasket_LoadByID", db.DBase);
      cmd.CommandType = System.Data.CommandType.StoredProcedure;
      cmd.Parameters.AddWithValue("@ID", ContentID);
      SqlParameter Error = cmd.Parameters.AddWithValue("@ErrorCode", 0);
      Error.Direction = System.Data.ParameterDirection.Output;

      rdr = cmd.ExecuteReader();
      if (rdr.Read())
      {
        sb_id = db.ProcessField(rdr["sb_id"], 0);
        ui_id = db.ProcessField(rdr["ui_id"], 0);
        sb_status = db.ProcessField(rdr["sb_status"], 0);
        sb_date = db.ProcessField(rdr["sb_date"], DateTime.Now);
        sb_paymentType = db.ProcessField(rdr["sb_paymentType"], 0);
        sb_code = db.ProcessField(rdr["sb_code"], "");
        sb_amount = db.ProcessField(rdr["sb_amount"], "");
        sb_transactionStatus = db.ProcessField(rdr["sb_transactionStatus"], 0);
        sb_resultCode = db.ProcessField(rdr["sb_resultCode"], 0);
        sb_authCode = db.ProcessField(rdr["sb_authCode"], "");
        sb_transId = db.ProcessField(rdr["sb_transId"], "");
        sb_subsId = db.ProcessField(rdr["sb_subsId"], "");
        sb_riskIndicator = db.ProcessField(rdr["sb_riskIndicator"], "");
        sb_checksum = db.ProcessField(rdr["sb_checksum"], "");
      }
      rdr.Close();

      result = true;
    }
    catch (Exception err)
    {
      Logger.Log(err);
    }
    finally
    {
      db.DBase.Close();
    }

    return result;
  }

  /****************************************************************************************************/
  /// <summary>
  /// Saves values contained in the public variables to a new record if Primary Key ID is 0 or updates 
  /// an existing record if Primary Key ID > 0
  /// </summary>
  /// <returns>
  /// The ID of record saved or updated.
  /// </returns>
  public int Save()
  {
    int result = 0;
    
    try
    {
      db.DBase.Open();
      cmd = new SqlCommand("ShoppingBasket_Save", db.DBase);
      cmd.CommandType = System.Data.CommandType.StoredProcedure;

      cmd.Parameters.AddWithValue("@sb_id", sb_id);
      cmd.Parameters.AddWithValue("@ui_id", ui_id);
      cmd.Parameters.AddWithValue("@sb_status", sb_status);
      cmd.Parameters.AddWithValue("@sb_date", sb_date);
      cmd.Parameters.AddWithValue("@sb_paymentType", sb_paymentType);
      cmd.Parameters.AddWithValue("@sb_code", sb_code);
      cmd.Parameters.AddWithValue("@sb_amount", sb_amount);
      cmd.Parameters.AddWithValue("@sb_transactionStatus", sb_transactionStatus);
      cmd.Parameters.AddWithValue("@sb_resultCode", sb_resultCode);
      cmd.Parameters.AddWithValue("@sb_authCode", sb_authCode);
      cmd.Parameters.AddWithValue("@sb_transId", sb_transId);
      cmd.Parameters.AddWithValue("@sb_subsId", sb_subsId);
      cmd.Parameters.AddWithValue("@sb_riskIndicator", sb_riskIndicator);
      cmd.Parameters.AddWithValue("@sb_checksum", sb_checksum);

      SqlParameter Saved = cmd.Parameters.AddWithValue("@SavedID", 0);
      Saved.Direction = System.Data.ParameterDirection.Output;
      cmd.ExecuteNonQuery();
      result = (int)cmd.Parameters["@SavedID"].Value;
    }
    catch (Exception err)
    {
      Logger.Log(err);
      result = 0;
    }
    finally
    {
      db.DBase.Close();
    }
    return result;
  }

  /****************************************************************************************************/
  /// <summary>
  /// Deletes the record specified by ID
  /// </summary>
  /// <param name="ID">
  /// Specifies the Primary key value of the record to delete
  /// </param>
  /// <returns>
  /// True on successful delete
  /// False if an error occurs
  /// </returns>
  public bool Delete(int ContentID)
  {
    bool result = false;
    try
    {
      db.DBase.Open();
      cmd = new SqlCommand("ShoppingBasket_Delete", db.DBase);
      cmd.CommandType = System.Data.CommandType.StoredProcedure;
      cmd.Parameters.AddWithValue("@ID", ContentID);
      SqlParameter Error = cmd.Parameters.AddWithValue("@ErrorCode", 0);
      Error.Direction = System.Data.ParameterDirection.Output;
      cmd.ExecuteNonQuery();
      result = true;
    }
    catch (Exception err)
    {
      Logger.Log(err);
    }
    finally
    {
      db.DBase.Close();
    }

    return result;
  }

  /**********************************************************************************************************/
  /// <summary>
  /// Gets or sets the Invoice ID Session var.
  /// </summary>
  /// <value>The user ID.</value>
  public int InvoiceID
  {
    set
    {
      if (System.Web.HttpContext.Current.Session["invoiceid"] == null)
      {
        System.Web.HttpContext.Current.Session.Add("invoiceid", value);
      }
      else
        System.Web.HttpContext.Current.Session["invoiceid"] = value;
    }
    get
    {
      if (System.Web.HttpContext.Current.Session["invoiceid"] == null)
      {
        System.Web.HttpContext.Current.Session.Add("invoiceid", "0");
        return 0;
      }
      else
        return int.Parse(System.Web.HttpContext.Current.Session["invoiceid"].ToString());
    }
  }


  /****************************************************************************************************/

}