public CreditBillHeaderDetails setDetails(System.Data.DataTable dt) { CreditBillHeaderDetails Details = new CreditBillHeaderDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.CreditBillHeaderID = Int64.Parse(dr["CreditBillHeaderID"].ToString()); Details.CreditBillID = Int64.Parse(dr["CreditBillID"].ToString()); Details.ContactID = Int64.Parse(dr["ContactID"].ToString()); Details.GuarantorID = Int64.Parse(dr["GuarantorID"].ToString()); Details.CreditLimit = decimal.Parse(dr["CreditLimit"].ToString()); Details.RunningCreditAmt = decimal.Parse(dr["RunningCreditAmt"].ToString()); Details.CurrMonthCreditAmt = decimal.Parse(dr["CurrMonthCreditAmt"].ToString()); Details.CurrMonthAmountPaid = decimal.Parse(dr["CurrMonthAmountPaid"].ToString()); Details.BillingDate = DateTime.Parse(dr["BillingDate"].ToString()); Details.BillingFile = dr["BillingFile"].ToString(); Details.TotalBillCharges = decimal.Parse(dr["TotalBillCharges"].ToString()); Details.CurrentDueAmount = decimal.Parse(dr["CurrentDueAmount"].ToString()); Details.MinimumAmountDue = decimal.Parse(dr["MinimumAmountDue"].ToString()); Details.Prev1MoCurrentDueAmount = decimal.Parse(dr["Prev1MoCurrentDueAmount"].ToString()); Details.Prev1MoMinimumAmountDue = decimal.Parse(dr["Prev1MoMinimumAmountDue"].ToString()); Details.Prev1MoCurrMonthAmountPaid = decimal.Parse(dr["Prev1MoCurrMonthAmountPaid"].ToString()); Details.Prev2MoCurrentDueAmount = decimal.Parse(dr["Prev2MoCurrentDueAmount"].ToString()); Details.CurrentPurchaseAmt = decimal.Parse(dr["CurrentPurchaseAmt"].ToString()); Details.BeginningBalance = decimal.Parse(dr["BeginningBalance"].ToString()); Details.EndingBalance = decimal.Parse(dr["EndingBalance"].ToString()); Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); Details.CreatedByID = Int64.Parse(dr["CreatedByID"].ToString()); Details.CreatedByName = dr["CreatedByName"].ToString(); Details.IsBillPrinted = bool.Parse(dr["IsBillPrinted"].ToString()); } return(Details); }
public CreditBillHeaderDetails Details(Int64 ContactID, DateTime BillingDate) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE AND ContactID = @ContactID AND BillingDate = @BillingDate LIMIT 1 "; cmd.Parameters.AddWithValue("@ContactID", ContactID); cmd.Parameters.AddWithValue("@BillingDate", BillingDate); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); CreditBillHeaderDetails Details = setDetails(dt); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 OverWriteBillingNoG(CreditBillHeaderDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "UPDATE tblCreditBillHeader SET " + " Prev2MoCurrentDueAmount = @Prev2MoCurrentDueAmount, " + " Prev1MoCurrentDueAmount = @Prev1MoCurrentDueAmount, " + " CurrMonthAmountPaid = @CurrMonthAmountPaid, " + " TotalBillCharges = @TotalBillCharges, " + " CurrentPurchaseAmt = @CurrentPurchaseAmt, " + " MinimumAmountDue = @MinimumAmountDue, " + " CurrentDueAmount = @CurrentDueAmount " + "WHERE CreditBillHeaderID=@CreditBillHeaderID AND BillingDate=@BillingDate;"; cmd.Parameters.AddWithValue("Prev2MoCurrentDueAmount", Details.Prev2MoCurrentDueAmount); cmd.Parameters.AddWithValue("Prev1MoCurrentDueAmount", Details.Prev1MoCurrentDueAmount); cmd.Parameters.AddWithValue("CurrMonthAmountPaid", Details.CurrMonthAmountPaid); cmd.Parameters.AddWithValue("TotalBillCharges", Details.TotalBillCharges); cmd.Parameters.AddWithValue("CurrentPurchaseAmt", Details.CurrentPurchaseAmt); cmd.Parameters.AddWithValue("MinimumAmountDue", Details.MinimumAmountDue); cmd.Parameters.AddWithValue("CurrentDueAmount", Details.CurrentDueAmount); cmd.Parameters.AddWithValue("CreditBillHeaderID", Details.CreditBillHeaderID); cmd.Parameters.AddWithValue("BillingDate", Details.BillingDate); cmd.CommandText = SQL; return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(CreditBillHeaderDetails Details) { try { Save(Details); return Int64.Parse(base.getLAST_INSERT_ID(this)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(CreditBillHeaderDetails Details) { try { Save(Details); return(Int64.Parse(base.getLAST_INSERT_ID(this))); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(CreditBillHeaderDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "INSERT INTO tblCreditBillHeaders(CreditBillID, ContactID, GuarantorID, CreditLimit, RunningCreditAmt, CurrMonthCreditAmt " + ",CurrMonthAmountPaid, BillingDate, BillingFile, TotalBillCharges, CurrentDueAmount, MinimumAmountDue " + ",Prev1MoCurrentDueAmount, Prev1MoMinimumAmountDue, Prev1MoCurrMonthAmountPaid, Prev2MoCurrentDueAmount " + ",CurrentPurchaseAmt, BeginningBalance, EndingBalance, CreatedOn, CreatedByID, CreatedByName, IsBillPrinted )VALUES("; SQL += "@CreditBillID, @ContactID, @GuarantorID, @CreditLimit, @RunningCreditAmt, @CurrMonthCreditAmt " + ",@CurrMonthAmountPaid, @BillingDate, @BillingFile, @TotalBillCharges, @CurrentDueAmount, @MinimumAmountDue " + ",@Prev1MoCurrentDueAmount, @Prev1MoMinimumAmountDue, @Prev1MoCurrMonthAmountPaid, @Prev2MoCurrentDueAmount " + ",@CurrentPurchaseAmt, @BeginningBalance, @EndingBalance, @CreatedOn, @CreatedByID, @CreatedByName, @IsBillPrinted )"; cmd.Parameters.AddWithValue("CreditBillID", Details.CreditBillID); cmd.Parameters.AddWithValue("ContactID", Details.ContactID); cmd.Parameters.AddWithValue("GuarantorID", Details.GuarantorID); cmd.Parameters.AddWithValue("CreditLimit", Details.CreditLimit); cmd.Parameters.AddWithValue("RunningCreditAmt", Details.RunningCreditAmt); cmd.Parameters.AddWithValue("CurrMonthCreditAmt", Details.CurrMonthCreditAmt); cmd.Parameters.AddWithValue("CurrMonthAmountPaid", Details.CurrMonthAmountPaid); cmd.Parameters.AddWithValue("BillingDate", Details.BillingDate); cmd.Parameters.AddWithValue("BillingFile", Details.BillingFile); cmd.Parameters.AddWithValue("TotalBillCharges", Details.TotalBillCharges); cmd.Parameters.AddWithValue("CreditMinimumPercentageDue15th", Details.CurrentDueAmount); cmd.Parameters.AddWithValue("MinimumAmountDue", Details.MinimumAmountDue); cmd.Parameters.AddWithValue("Prev1MoCurrentDueAmount", Details.Prev1MoCurrentDueAmount); cmd.Parameters.AddWithValue("Prev1MoMinimumAmountDue", Details.Prev1MoMinimumAmountDue); cmd.Parameters.AddWithValue("Prev1MoCurrMonthAmountPaid", Details.Prev1MoCurrMonthAmountPaid); cmd.Parameters.AddWithValue("Prev2MoCurrentDueAmount", Details.Prev2MoCurrentDueAmount); cmd.Parameters.AddWithValue("CurrentPurchaseAmt", Details.CurrentPurchaseAmt); cmd.Parameters.AddWithValue("BeginningBalance", Details.BeginningBalance); cmd.Parameters.AddWithValue("EndingBalance", Details.EndingBalance); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("CreatedByID", Details.CreatedByID); cmd.Parameters.AddWithValue("CreatedByName", Details.CreatedByName); cmd.Parameters.AddWithValue("IsBillPrinted", Details.IsBillPrinted); cmd.CommandText = SQL; return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(CreditBillHeaderDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "INSERT INTO tblCreditBillHeaders(CreditBillID, ContactID, GuarantorID, CreditLimit, RunningCreditAmt, CurrMonthCreditAmt " + ",CurrMonthAmountPaid, BillingDate, BillingFile, TotalBillCharges, CurrentDueAmount, MinimumAmountDue " + ",Prev1MoCurrentDueAmount, Prev1MoMinimumAmountDue, Prev1MoCurrMonthAmountPaid, Prev2MoCurrentDueAmount " + ",CurrentPurchaseAmt, BeginningBalance, EndingBalance, CreatedOn, CreatedByID, CreatedByName, IsBillPrinted )VALUES("; SQL += "@CreditBillID, @ContactID, @GuarantorID, @CreditLimit, @RunningCreditAmt, @CurrMonthCreditAmt " + ",@CurrMonthAmountPaid, @BillingDate, @BillingFile, @TotalBillCharges, @CurrentDueAmount, @MinimumAmountDue " + ",@Prev1MoCurrentDueAmount, @Prev1MoMinimumAmountDue, @Prev1MoCurrMonthAmountPaid, @Prev2MoCurrentDueAmount " + ",@CurrentPurchaseAmt, @BeginningBalance, @EndingBalance, @CreatedOn, @CreatedByID, @CreatedByName, @IsBillPrinted )"; cmd.Parameters.AddWithValue("CreditBillID", Details.CreditBillID); cmd.Parameters.AddWithValue("ContactID", Details.ContactID); cmd.Parameters.AddWithValue("GuarantorID", Details.GuarantorID); cmd.Parameters.AddWithValue("CreditLimit", Details.CreditLimit); cmd.Parameters.AddWithValue("RunningCreditAmt", Details.RunningCreditAmt); cmd.Parameters.AddWithValue("CurrMonthCreditAmt", Details.CurrMonthCreditAmt); cmd.Parameters.AddWithValue("CurrMonthAmountPaid", Details.CurrMonthAmountPaid); cmd.Parameters.AddWithValue("BillingDate", Details.BillingDate); cmd.Parameters.AddWithValue("BillingFile", Details.BillingFile); cmd.Parameters.AddWithValue("TotalBillCharges", Details.TotalBillCharges); cmd.Parameters.AddWithValue("CreditMinimumPercentageDue15th", Details.CurrentDueAmount); cmd.Parameters.AddWithValue("MinimumAmountDue", Details.MinimumAmountDue); cmd.Parameters.AddWithValue("Prev1MoCurrentDueAmount", Details.Prev1MoCurrentDueAmount); cmd.Parameters.AddWithValue("Prev1MoMinimumAmountDue", Details.Prev1MoMinimumAmountDue); cmd.Parameters.AddWithValue("Prev1MoCurrMonthAmountPaid", Details.Prev1MoCurrMonthAmountPaid); cmd.Parameters.AddWithValue("Prev2MoCurrentDueAmount", Details.Prev2MoCurrentDueAmount); cmd.Parameters.AddWithValue("CurrentPurchaseAmt", Details.CurrentPurchaseAmt); cmd.Parameters.AddWithValue("BeginningBalance", Details.BeginningBalance); cmd.Parameters.AddWithValue("EndingBalance", Details.EndingBalance); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("CreatedByID", Details.CreatedByID); cmd.Parameters.AddWithValue("CreatedByName", Details.CreatedByName); cmd.Parameters.AddWithValue("IsBillPrinted", Details.IsBillPrinted); cmd.CommandText = SQL; return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillHeaderDetails setDetails(System.Data.DataTable dt) { CreditBillHeaderDetails Details = new CreditBillHeaderDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.CreditBillHeaderID = Int64.Parse(dr["CreditBillHeaderID"].ToString()); Details.CreditBillID = Int64.Parse(dr["CreditBillID"].ToString()); Details.ContactID = Int64.Parse(dr["ContactID"].ToString()); Details.GuarantorID = Int64.Parse(dr["GuarantorID"].ToString()); Details.CreditLimit = decimal.Parse(dr["CreditLimit"].ToString()); Details.RunningCreditAmt = decimal.Parse(dr["RunningCreditAmt"].ToString()); Details.CurrMonthCreditAmt = decimal.Parse(dr["CurrMonthCreditAmt"].ToString()); Details.CurrMonthAmountPaid = decimal.Parse(dr["CurrMonthAmountPaid"].ToString()); Details.BillingDate = DateTime.Parse(dr["BillingDate"].ToString()); Details.BillingFile = dr["BillingFile"].ToString(); Details.TotalBillCharges = decimal.Parse(dr["TotalBillCharges"].ToString()); Details.CurrentDueAmount = decimal.Parse(dr["CurrentDueAmount"].ToString()); Details.MinimumAmountDue = decimal.Parse(dr["MinimumAmountDue"].ToString()); Details.Prev1MoCurrentDueAmount = decimal.Parse(dr["Prev1MoCurrentDueAmount"].ToString()); Details.Prev1MoMinimumAmountDue = decimal.Parse(dr["Prev1MoMinimumAmountDue"].ToString()); Details.Prev1MoCurrMonthAmountPaid = decimal.Parse(dr["Prev1MoCurrMonthAmountPaid"].ToString()); Details.Prev2MoCurrentDueAmount = decimal.Parse(dr["Prev2MoCurrentDueAmount"].ToString()); Details.CurrentPurchaseAmt = decimal.Parse(dr["CurrentPurchaseAmt"].ToString()); Details.BeginningBalance = decimal.Parse(dr["BeginningBalance"].ToString()); Details.EndingBalance = decimal.Parse(dr["EndingBalance"].ToString()); Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); Details.CreatedByID = Int64.Parse(dr["CreatedByID"].ToString()); Details.CreatedByName = dr["CreatedByName"].ToString(); Details.IsBillPrinted = bool.Parse(dr["IsBillPrinted"].ToString()); } return Details; }
public Int32 OverWriteBilling(CreditBillHeaderDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "UPDATE tblCreditBillHeader SET " + " BeginningBalance = @BeginningBalance, " + " Prev1MoCurrentDueAmount = @Prev1MoCurrentDueAmount, " + " CurrMonthAmountPaid = @CurrMonthAmountPaid, " + " RunningCreditAmt = @RunningCreditAmt, " + " TotalBillCharges = @TotalBillCharges, " + " CurrentPurchaseAmt = @CurrentPurchaseAmt, " + " CurrMonthCreditAmt = @CurrMonthCreditAmt, " + " CurrentDueAmount = @CurrentDueAmount, " + " EndingBalance = @EndingBalance " + "WHERE CreditBillHeaderID=@CreditBillHeaderID AND BillingDate=@BillingDate;"; cmd.Parameters.AddWithValue("BeginningBalance", Details.BeginningBalance); cmd.Parameters.AddWithValue("Prev1MoCurrentDueAmount", Details.Prev1MoCurrentDueAmount); cmd.Parameters.AddWithValue("CurrMonthAmountPaid", Details.CurrMonthAmountPaid); cmd.Parameters.AddWithValue("RunningCreditAmt", Details.RunningCreditAmt); cmd.Parameters.AddWithValue("TotalBillCharges", Details.TotalBillCharges); cmd.Parameters.AddWithValue("CurrentPurchaseAmt", Details.CurrentPurchaseAmt); cmd.Parameters.AddWithValue("CurrMonthCreditAmt", Details.CurrMonthCreditAmt); cmd.Parameters.AddWithValue("CurrentDueAmount", Details.CurrentDueAmount); cmd.Parameters.AddWithValue("EndingBalance", Details.EndingBalance); cmd.Parameters.AddWithValue("CreditBillHeaderID", Details.CreditBillHeaderID); cmd.Parameters.AddWithValue("BillingDate", Details.BillingDate); cmd.CommandText = SQL; return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }