private SalesTransactionDetails setSalesTransactionDetails(GLAOrderTenderDetails glaDetails, SalesTransactionDetails mclsSalesTransactionDetails)
{
// for update
//mclsSalesTransactionDetails.CustomerID = glaDetails.fk_emp_def;
//mclsSalesTransactionDetails.AgentID = Constants.C_RETAILPLUS_AGENTID;
//mclsSalesTransactionDetails.AgentName = Constants.C_RETAILPLUS_AGENT;
//mclsSalesTransactionDetails.AgentPositionName = Constants.C_RETAILPLUS_AGENT_POSITIONNAME;
//mclsSalesTransactionDetails.AgentDepartmentName = Constants.C_RETAILPLUS_AGENT_DEPARTMENT_NAME;
//mclsSalesTransactionDetails.WaiterID = Constants.C_RETAILPLUS_WAITERID;
//mclsSalesTransactionDetails.WaiterName = Constants.C_RETAILPLUS_WAITER;
//mclsSalesTransactionDetails.CreatedByID = glaDetails.fk_emp_def;
//mclsSalesTransactionDetails.CreatedByName = Constants.C_RETAILPLUS_WAITER;
//mclsSalesTransactionDetails.CashierID = glaDetails.fk_emp_def;
//mclsSalesTransactionDetails.CashierName = glaDetails.Filename;
//mclsSalesTransactionDetails.CustomerID = Constants.C_RETAILPLUS_CUSTOMERID;
//mclsSalesTransactionDetails.CustomerName = Constants.C_RETAILPLUS_CUSTOMER;
//mclsSalesTransactionDetails.TransactionDate = glaDetails.Chk_Open_Date_Time;
//mclsSalesTransactionDetails.DateSuspended = Constants.C_DATE_MIN_VALUE;
//mclsSalesTransactionDetails.TerminalNo = Constants.C_DEFAULT_TERMINAL_01;
//mclsSalesTransactionDetails.BranchID = Constants.BRANCH_ID_MAIN;
//mclsSalesTransactionDetails.BranchCode = Constants.BRANCH_MAIN;
//mclsSalesTransactionDetails.TransactionStatus = TransactionStatus.Closed;
//mclsSalesTransactionDetails.TransactionType = TransactionTypes.POSNormal;
//mclsSalesTransactionDetails.TransactionNo = glaDetails.chk_headers_seq_number.ToString();
////for update
//mclsSalesTransactionDetails.Charge = glaDetails.Auto_Svc_Ttl + glaDetails.Other_Svc_Ttl + glaDetails.Tip_ttl;
//mclsSalesTransactionDetails.Discount = -glaDetails.Dsc_Ttl;
//mclsSalesTransactionDetails.AmountDue = glaDetails.Sub_Ttl + glaDetails.Tax_Ttl + mclsSalesTransactionDetails.Charge - mclsSalesTransactionDetails.Discount;
//mclsSalesTransactionDetails.SubTotal = glaDetails.Sub_Ttl + glaDetails.Tax_Ttl + mclsSalesTransactionDetails.Charge;
//mclsSalesTransactionDetails.DiscountableAmount = mclsSalesTransactionDetails.Discount <= 0 ? 0 : glaDetails.Dsc_Ttl;
//mclsSalesTransactionDetails.ItemsDiscount = 0;
//mclsSalesTransactionDetails.VAT = glaDetails.Tax_Ttl;
//mclsSalesTransactionDetails.VatableAmount = glaDetails.Sub_Ttl + glaDetails.Tax_Ttl;
//mclsSalesTransactionDetails.NonVATableAmount = 0;
//mclsSalesTransactionDetails.EVAT = 0;
//mclsSalesTransactionDetails.EVatableAmount = 0;
//mclsSalesTransactionDetails.NonEVATableAmount = glaDetails.Sub_Ttl + glaDetails.Tax_Ttl;
//mclsSalesTransactionDetails.LocalTax = 0;
//mclsSalesTransactionDetails.TotalItemSold = glaDetails.Cov_Cnt;
//mclsSalesTransactionDetails.TotalQuantitySold = glaDetails.Num_Dtl;
//mclsSalesTransactionDetails.AmountPaid = glaDetails.Pymnt_Ttl;
//mclsSalesTransactionDetails.CashPayment = mclsSalesTransactionDetails.SubTotal;
//mclsSalesTransactionDetails.ChangeAmount = glaDetails.Pymnt_Ttl;
//mclsSalesTransactionDetails.ChequePayment = 0;
//mclsSalesTransactionDetails.CreditCardPayment = 0;
//mclsSalesTransactionDetails.CreditPayment = 0;
//mclsSalesTransactionDetails.CreditChargeAmount = 0;
//mclsSalesTransactionDetails.DebitPayment = 0;
//mclsSalesTransactionDetails.RewardPointsPayment = 0;
//mclsSalesTransactionDetails.DateClosed = glaDetails.Chk_Closed_Date_Time;
//mclsSalesTransactionDetails.DateResumed = glaDetails.DateCreated;
//mclsSalesTransactionDetails.DataSource = glaDetails.BatchID;
return mclsSalesTransactionDetails;
}
public Int64 Insert(GLAOrderTenderDetails Details)
{
try
{
string SQL = "INSERT INTO tblgla_order_tender (" +
"identifier," +
"order_hdr_id," +
"tender_seq," +
"tender_id," +
"tender_amt," +
"prorata_sales_amt_gross," +
"prorata_discount_amt," +
"prorata_tax_amt," +
"prorata_grat_amt," +
"prorata_svc_chg_amt," +
"tip_amt," +
"breakage_amt," +
"received_curr_amt," +
"curr_decimal_places," +
"exchange_rate," +
"change_amt," +
"change_tender_id," +
"tax_removed_code," +
"tender_type_id," +
"subtender_id," +
"auth_acct_no," +
"post_acct_no," +
"customer_name," +
"adtnl_info," +
"subtender_qty," +
"charges_to_date_amt," +
"remaining_balance_amt," +
"PMS_post_flag," +
"sales_tippable_flag," +
"post_system1_flag," +
"post_system2_flag," +
"post_system3_flag," +
"post_system4_flag," +
"post_system5_flag," +
"post_system6_flag," +
"post_system7_flag," +
"DateCreated," +
"CreatedBy," +
"Filename," +
"BatchID" +
") VALUES (" +
"@identifier," +
"@order_hdr_id," +
"@tender_seq," +
"@tender_id," +
"@tender_amt," +
"@prorata_sales_amt_gross," +
"@prorata_discount_amt," +
"@prorata_tax_amt," +
"@prorata_grat_amt," +
"@prorata_svc_chg_amt," +
"@tip_amt," +
"@breakage_amt," +
"@received_curr_amt," +
"@curr_decimal_places," +
"@exchange_rate," +
"@change_amt," +
"@change_tender_id," +
"@tax_removed_code," +
"@tender_type_id," +
"@subtender_id," +
"@auth_acct_no," +
"@post_acct_no," +
"@customer_name," +
"@adtnl_info," +
"@subtender_qty," +
"@charges_to_date_amt," +
"@remaining_balance_amt," +
"@PMS_post_flag," +
"@sales_tippable_flag," +
"@post_system1_flag," +
"@post_system2_flag," +
"@post_system3_flag," +
"@post_system4_flag," +
"@post_system5_flag," +
"@post_system6_flag," +
"@post_system7_flag," +
"@DateCreated," +
"@CreatedBy," +
"@Filename," +
"@BatchID);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@identifier", Details.identifier);
cmd.Parameters.AddWithValue("@order_hdr_id", Details.order_hdr_id);
cmd.Parameters.AddWithValue("@tender_seq", Details.tender_seq);
cmd.Parameters.AddWithValue("@tender_id", Details.tender_id);
cmd.Parameters.AddWithValue("@tender_amt", Details.tender_amt);
cmd.Parameters.AddWithValue("@prorata_sales_amt_gross", Details.prorata_sales_amt_gross);
cmd.Parameters.AddWithValue("@prorata_discount_amt", Details.prorata_discount_amt);
cmd.Parameters.AddWithValue("@prorata_tax_amt", Details.prorata_tax_amt);
cmd.Parameters.AddWithValue("@prorata_grat_amt", Details.prorata_grat_amt);
cmd.Parameters.AddWithValue("@prorata_svc_chg_amt", Details.prorata_svc_chg_amt);
cmd.Parameters.AddWithValue("@tip_amt", Details.tip_amt);
cmd.Parameters.AddWithValue("@breakage_amt", Details.breakage_amt);
cmd.Parameters.AddWithValue("@received_curr_amt", Details.received_curr_amt);
cmd.Parameters.AddWithValue("@curr_decimal_places", Details.curr_decimal_places);
cmd.Parameters.AddWithValue("@exchange_rate", Details.exchange_rate);
cmd.Parameters.AddWithValue("@change_amt", Details.change_amt);
cmd.Parameters.AddWithValue("@change_tender_id", Details.change_tender_id);
cmd.Parameters.AddWithValue("@tax_removed_code", Details.tax_removed_code);
cmd.Parameters.AddWithValue("@tender_type_id", Details.tender_type_id);
cmd.Parameters.AddWithValue("@subtender_id", Details.subtender_id);
cmd.Parameters.AddWithValue("@auth_acct_no", Details.auth_acct_no);
cmd.Parameters.AddWithValue("@post_acct_no", Details.post_acct_no);
cmd.Parameters.AddWithValue("@customer_name", Details.customer_name);
cmd.Parameters.AddWithValue("@adtnl_info", Details.adtnl_info);
cmd.Parameters.AddWithValue("@subtender_qty", Details.subtender_qty);
cmd.Parameters.AddWithValue("@charges_to_date_amt", Details.charges_to_date_amt);
cmd.Parameters.AddWithValue("@remaining_balance_amt", Details.remaining_balance_amt);
cmd.Parameters.AddWithValue("@PMS_post_flag", Details.PMS_post_flag);
cmd.Parameters.AddWithValue("@sales_tippable_flag", Details.sales_tippable_flag);
cmd.Parameters.AddWithValue("@post_system1_flag", Details.post_system1_flag);
cmd.Parameters.AddWithValue("@post_system2_flag", Details.post_system2_flag);
cmd.Parameters.AddWithValue("@post_system3_flag", Details.post_system3_flag);
cmd.Parameters.AddWithValue("@post_system4_flag", Details.post_system4_flag);
cmd.Parameters.AddWithValue("@post_system5_flag", Details.post_system5_flag);
cmd.Parameters.AddWithValue("@post_system6_flag", Details.post_system6_flag);
cmd.Parameters.AddWithValue("@post_system7_flag", Details.post_system7_flag);
cmd.Parameters.AddWithValue("@DateCreated", Details.DateCreated);
cmd.Parameters.AddWithValue("@CreatedBy", Details.CreatedBy);
cmd.Parameters.AddWithValue("@Filename", Details.Filename);
cmd.Parameters.AddWithValue("@BatchID", Details.BatchID);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private GLAOrderTenderDetails setOrderTenderDetails(string line, DateTime DateCreated, string CreatedBy, string filename, string BatchID)
{
DateTime dteRetvalue = Constants.C_DATE_MIN_VALUE;
long lngRetValue = 0;
int intRetValue = 0;
decimal decRetValue = 0;
GLAOrderTenderDetails clsDetails = new GLAOrderTenderDetails();
int iCol = 0;
int iColText = 0;
foreach (string colText in line.Split('"'))
{
switch (iColText)
{
case 0: break;
case 1: clsDetails.identifier = colText; break;
case 2:
iCol = 0;
foreach (string col in colText.Split(','))
{
dteRetvalue = Constants.C_DATE_MIN_VALUE;
intRetValue = 0;
string col2 = col.Replace("$", "").Trim();
switch (iCol)
{
case 0: break;
case 1: clsDetails.order_hdr_id = long.TryParse(col2, out lngRetValue) ? lngRetValue : 0; break;
case 2: clsDetails.tender_seq = long.TryParse(col2, out lngRetValue) ? lngRetValue : 0; break;
case 3: clsDetails.tender_id = long.TryParse(col2, out lngRetValue) ? lngRetValue : 0; break;
case 4: clsDetails.tender_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 5: clsDetails.prorata_sales_amt_gross = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 6: clsDetails.prorata_discount_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 7: clsDetails.prorata_tax_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 8: clsDetails.prorata_grat_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 9: clsDetails.prorata_svc_chg_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 10: clsDetails.tip_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 11: clsDetails.breakage_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 12: clsDetails.received_curr_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 13: clsDetails.curr_decimal_places = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
case 14: clsDetails.exchange_rate = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
case 15: clsDetails.change_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 16: clsDetails.change_tender_id = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
case 17: clsDetails.tax_removed_code = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
case 18: clsDetails.tender_type_id = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
case 19: clsDetails.subtender_id = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
}
iCol++;
}
break;
case 3: clsDetails.auth_acct_no = colText; break;
case 4: break;
case 5: clsDetails.post_acct_no = colText; break;
case 6: break;
case 7: clsDetails.customer_name = colText; break;
case 8:
iCol = 0;
foreach (string col in colText.Split(','))
{
dteRetvalue = Constants.C_DATE_MIN_VALUE;
intRetValue = 0;
string col2 = col.Replace("$", "").Trim();
switch (iCol)
{
case 0: break;
case 1: break;
case 2: clsDetails.adtnl_info = col2; break;
case 3: clsDetails.subtender_qty = int.TryParse(col2, out intRetValue) ? intRetValue : 0; break;
case 4: clsDetails.charges_to_date_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 5: clsDetails.remaining_balance_amt = decimal.TryParse(col2, out decRetValue) ? decRetValue : 0; break;
case 6: clsDetails.PMS_post_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 7: clsDetails.sales_tippable_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 8: clsDetails.post_system1_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 9: clsDetails.post_system2_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 10: clsDetails.post_system3_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 11: clsDetails.post_system4_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 12: clsDetails.post_system5_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 13: clsDetails.post_system6_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 14: clsDetails.post_system7_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
case 15: clsDetails.post_system8_flag = Convert.ToBoolean(int.TryParse(col2, out intRetValue) ? intRetValue : 0); break;
}
iCol++;
}
break;
}
iColText++;
}
clsDetails.DateCreated = DateCreated;
clsDetails.CreatedBy = CreatedBy;
clsDetails.Filename = filename;
clsDetails.BatchID = BatchID;
return clsDetails;
}
public Int64 Insert(GLAOrderTenderDetails Details)
{
try
{
string SQL = "INSERT INTO tblgla_order_tender (" +
"identifier," +
"order_hdr_id," +
"tender_seq," +
"tender_id," +
"tender_amt," +
"prorata_sales_amt_gross," +
"prorata_discount_amt," +
"prorata_tax_amt," +
"prorata_grat_amt," +
"prorata_svc_chg_amt," +
"tip_amt," +
"breakage_amt," +
"received_curr_amt," +
"curr_decimal_places," +
"exchange_rate," +
"change_amt," +
"change_tender_id," +
"tax_removed_code," +
"tender_type_id," +
"subtender_id," +
"auth_acct_no," +
"post_acct_no," +
"customer_name," +
"adtnl_info," +
"subtender_qty," +
"charges_to_date_amt," +
"remaining_balance_amt," +
"PMS_post_flag," +
"sales_tippable_flag," +
"post_system1_flag," +
"post_system2_flag," +
"post_system3_flag," +
"post_system4_flag," +
"post_system5_flag," +
"post_system6_flag," +
"post_system7_flag," +
"DateCreated," +
"CreatedBy," +
"Filename," +
"BatchID" +
") VALUES (" +
"@identifier," +
"@order_hdr_id," +
"@tender_seq," +
"@tender_id," +
"@tender_amt," +
"@prorata_sales_amt_gross," +
"@prorata_discount_amt," +
"@prorata_tax_amt," +
"@prorata_grat_amt," +
"@prorata_svc_chg_amt," +
"@tip_amt," +
"@breakage_amt," +
"@received_curr_amt," +
"@curr_decimal_places," +
"@exchange_rate," +
"@change_amt," +
"@change_tender_id," +
"@tax_removed_code," +
"@tender_type_id," +
"@subtender_id," +
"@auth_acct_no," +
"@post_acct_no," +
"@customer_name," +
"@adtnl_info," +
"@subtender_qty," +
"@charges_to_date_amt," +
"@remaining_balance_amt," +
"@PMS_post_flag," +
"@sales_tippable_flag," +
"@post_system1_flag," +
"@post_system2_flag," +
"@post_system3_flag," +
"@post_system4_flag," +
"@post_system5_flag," +
"@post_system6_flag," +
"@post_system7_flag," +
"@DateCreated," +
"@CreatedBy," +
"@Filename," +
"@BatchID);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@identifier", Details.identifier);
cmd.Parameters.AddWithValue("@order_hdr_id", Details.order_hdr_id);
cmd.Parameters.AddWithValue("@tender_seq", Details.tender_seq);
cmd.Parameters.AddWithValue("@tender_id", Details.tender_id);
cmd.Parameters.AddWithValue("@tender_amt", Details.tender_amt);
cmd.Parameters.AddWithValue("@prorata_sales_amt_gross", Details.prorata_sales_amt_gross);
cmd.Parameters.AddWithValue("@prorata_discount_amt", Details.prorata_discount_amt);
cmd.Parameters.AddWithValue("@prorata_tax_amt", Details.prorata_tax_amt);
cmd.Parameters.AddWithValue("@prorata_grat_amt", Details.prorata_grat_amt);
cmd.Parameters.AddWithValue("@prorata_svc_chg_amt", Details.prorata_svc_chg_amt);
cmd.Parameters.AddWithValue("@tip_amt", Details.tip_amt);
cmd.Parameters.AddWithValue("@breakage_amt", Details.breakage_amt);
cmd.Parameters.AddWithValue("@received_curr_amt", Details.received_curr_amt);
cmd.Parameters.AddWithValue("@curr_decimal_places", Details.curr_decimal_places);
cmd.Parameters.AddWithValue("@exchange_rate", Details.exchange_rate);
cmd.Parameters.AddWithValue("@change_amt", Details.change_amt);
cmd.Parameters.AddWithValue("@change_tender_id", Details.change_tender_id);
cmd.Parameters.AddWithValue("@tax_removed_code", Details.tax_removed_code);
cmd.Parameters.AddWithValue("@tender_type_id", Details.tender_type_id);
cmd.Parameters.AddWithValue("@subtender_id", Details.subtender_id);
cmd.Parameters.AddWithValue("@auth_acct_no", Details.auth_acct_no);
cmd.Parameters.AddWithValue("@post_acct_no", Details.post_acct_no);
cmd.Parameters.AddWithValue("@customer_name", Details.customer_name);
cmd.Parameters.AddWithValue("@adtnl_info", Details.adtnl_info);
cmd.Parameters.AddWithValue("@subtender_qty", Details.subtender_qty);
cmd.Parameters.AddWithValue("@charges_to_date_amt", Details.charges_to_date_amt);
cmd.Parameters.AddWithValue("@remaining_balance_amt", Details.remaining_balance_amt);
cmd.Parameters.AddWithValue("@PMS_post_flag", Details.PMS_post_flag);
cmd.Parameters.AddWithValue("@sales_tippable_flag", Details.sales_tippable_flag);
cmd.Parameters.AddWithValue("@post_system1_flag", Details.post_system1_flag);
cmd.Parameters.AddWithValue("@post_system2_flag", Details.post_system2_flag);
cmd.Parameters.AddWithValue("@post_system3_flag", Details.post_system3_flag);
cmd.Parameters.AddWithValue("@post_system4_flag", Details.post_system4_flag);
cmd.Parameters.AddWithValue("@post_system5_flag", Details.post_system5_flag);
cmd.Parameters.AddWithValue("@post_system6_flag", Details.post_system6_flag);
cmd.Parameters.AddWithValue("@post_system7_flag", Details.post_system7_flag);
cmd.Parameters.AddWithValue("@DateCreated", Details.DateCreated);
cmd.Parameters.AddWithValue("@CreatedBy", Details.CreatedBy);
cmd.Parameters.AddWithValue("@Filename", Details.Filename);
cmd.Parameters.AddWithValue("@BatchID", Details.BatchID);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}