/// <summary>
/// Insert_Gift_Card_Rec
/// This is called from the Process_Gift_Card_Tbl procedure.
/// </summary>
public void Insert_Gift_Card_Rec(GIFT_CARD_INV_PR10_TEMP data)
{
var Sql_Msg = "Insert_Gift_Card_Rec PROBLEM";
var RJP_WORK = "Insert_Gift_Card_Rec ";
//#debugb Console.WriteLine(" "
//#debugb Console.WriteLine(RJP_WORK
//#debugb Console.WriteLine(" "
GIFT_CARD_INV_PR10_TEMP gft = new GIFT_CARD_INV_PR10_TEMP();
gft.VL_PROMOTION_CODE = data.VL_PROMOTION_CODE;
gft.STORE_NO = data.STORE_NO;
gft.TRANSACTION_DATE = data.TRANSACTION_DATE;
gft.TRANS_POST_DATE = data.TRANS_POST_DATE;
gft.CARDS_USED_QTY = data.CARDS_USED_QTY;
db.GIFT_CARD_INV_PR10_TEMPs.InsertOnSubmit(gft);
db.SubmitChanges();
var RJP_WORK = "Insert_Gift_Card_Rec OK ";
//#debugb Console.WriteLine(" "
//#debugb Console.WriteLine(RJP_WORK
//#debugb Console.WriteLine(" "
return;
}
/// <summary>
/// Insert_GC_Inv_Temp
/// This is called from the Process_OLTP_Record procedure.
/// </summary>
public void Insert_GC_Inv_Temp(GIFT_CARD_INV_PR10_TEMP data)
{
var Sql_Msg = "Insert_GC_Inv_Temp PROBLEM";
var RJP_WORK = "Insert_GC_Inv_Temp ";
//#debuga Console.WriteLine(" "
//#debuga Console.WriteLine(RJP_WORK
//#debuga Console.WriteLine(" "
var inv_trans_date = transaction_datetime.Substring(1, 2) + transaction_datetime.Substring(4, 2) + transaction_datetime.Substring(9, 2);
//#debuga Console.WriteLine("i1_promotion_code is " i1_promotion_code
//#debugb Console.WriteLine("store_no is " store_no
//#debuga Console.WriteLine("transaction_datetime is " transaction_datetime
//#debuga Console.WriteLine("ws_timestmp_cre is " ws_timestmp_cre
GIFT_CARD_INV_PR10_TEMP gft = new GIFT_CARD_INV_PR10_TEMP();
gft.VL_PROMOTION_CODE = data.VL_PROMOTION_CODE;
gft.STORE_NO = data.STORE_NO;
gft.TRANSACTION_DATE = data.TRANSACTION_DATE;
gft.TRANS_POST_DATE = data.TRANS_POST_DATE;
gft.CARDS_USED_QTY = 1;
db.GIFT_CARD_INV_PR10_TEMPs.InsertOnSubmit(gft);
db.SubmitChanges();
var RJP_WORK = "Insert_GC_Inv_Temp OK ";
//#debuga Console.WriteLine(" "
//#debuga Console.WriteLine(RJP_WORK
//#debuga Console.WriteLine(" "
return;
}
/// <summary>
/// This procedure will update GIFT_CARD_INV
/// </summary>
public void update_gcinv()
{
GIFT_CARD_INV_PR10_TEMP giftcard = db.GIFT_CARD_INV_PR10_TEMPs.FirstOrDefault(i => i.SENT_DATE == null);
giftcard.SENT_DATE = DateTime.Now;
db.SubmitChanges();
return;
}
/// <summary>
/// Process_Gift_Card_Tbl
/// This is called from the Begin_Report procedure.
/// </summary>
public void Process_Gift_Card_Tbl()
{
Insert_Gift_Card_Rec();
GIFT_CARD_INV_PR10_TEMP PR10GCI = db.GIFT_CARD_INV_PR10_TEMPs, FirstOrDefault();
//GROUP BY
//VL_PROMOTION_CODE,
//STORE_NO,
//TRANSACTION_DATE,
//TRANS_POST_DATE
return;
}