public Int64 Insert(CreditBillDetails Details) { try { Save(Details); return(Int64.Parse(base.getLAST_INSERT_ID(this))); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(CreditBillDetails Details) { try { Save(Details); return Int64.Parse(base.getLAST_INSERT_ID(this)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillDetails Details(CreditType CreditType = CreditType.Both, DateTime?BillingDate = null, Int16 CreditCardTypeID = 0) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE 1=1 "; if (CreditType == CreditType.Group) { SQL += "AND WithGuarantor = 1 "; } else if (CreditType == CreditType.Individual) { SQL += "AND WithGuarantor = 0 "; } if (BillingDate.GetValueOrDefault(Constants.C_DATE_MIN_VALUE) == Constants.C_DATE_MIN_VALUE) { SQL += "AND BillingDate = (SELECT MAX(BillingDate) FROM tblCreditBills) "; } else { SQL += "AND BillingDate = @BillingDate "; cmd.Parameters.AddWithValue("BillingDate", BillingDate.GetValueOrDefault(Constants.C_DATE_MIN_VALUE)); } if (CreditCardTypeID != 0) { SQL += "AND CreditCardTypeID = @CreditCardTypeID "; cmd.Parameters.AddWithValue("CreditCardTypeID", CreditCardTypeID); } SQL += "ORDER BY CreditBillID "; SQL += "ASC "; SQL += "LIMIT 1 "; 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); CreditBillDetails Details = setDetails(dt); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(CreditBillDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "INSERT INTO tblCreditBills(CreditPurcStartDateToProcess ,CreditPurcEndDateToProcess ,BillingDate ,CreditCutOffDate, CreditPaymentDueDate " + ",CreditFinanceCharge ,CreditMinimumPercentageDue ,CreditMinimumAmountDue ,CreditLatePenaltyCharge " + ",CreditFinanceCharge15th ,CreditMinimumPercentageDue15th ,CreditMinimumAmountDue15th ,CreditLatePenaltyCharge15th " + ",CreditCardTypeID ,CardTypeCode ,CreditCardType, WithGuarantor ,CreditUseLastDayCutOffDate " + ",CreatedOn ,CreatedByID ,CreatedByName)VALUES("; SQL += "@CreditPurcStartDateToProcess ,@CreditPurcEndDateToProcess ,@BillingDate ,@CreditCutOffDate, @CreditPaymentDueDate " + ",@CreditFinanceCharge ,@CreditMinimumPercentageDue ,@CreditMinimumAmountDue ,@CreditLatePenaltyCharge " + ",@CreditFinanceCharge15th ,@CreditMinimumPercentageDue15th ,@CreditMinimumAmountDue15th ,@CreditLatePenaltyCharge15th " + ",@CreditCardTypeID ,@CardTypeCode ,@CreditCardType, @WithGuarantor ,@CreditUseLastDayCutOffDate " + ",@CreatedOn ,@CreatedByID ,@CreatedByName)"; cmd.Parameters.AddWithValue("CreditPurcStartDateToProcess", Details.CreditPurcStartDateToProcess); cmd.Parameters.AddWithValue("CreditPurcEndDateToProcess", Details.CreditPurcEndDateToProcess); cmd.Parameters.AddWithValue("BranchName", Details.BillingDate); cmd.Parameters.AddWithValue("CreditCutOffDate", Details.CreditCutOffDate); cmd.Parameters.AddWithValue("CreditPaymentDueDate", Details.CreditPaymentDueDate); cmd.Parameters.AddWithValue("CreditFinanceCharge", Details.CreditFinanceCharge); cmd.Parameters.AddWithValue("CreditMinimumPercentageDue", Details.CreditMinimumPercentageDue); cmd.Parameters.AddWithValue("CreditMinimumAmountDue", Details.CreditMinimumAmountDue); cmd.Parameters.AddWithValue("CreditLatePenaltyCharge", Details.CreditLatePenaltyCharge); cmd.Parameters.AddWithValue("CreditFinanceCharge15th", Details.CreditFinanceCharge15th); cmd.Parameters.AddWithValue("CreditMinimumPercentageDue15th", Details.CreditMinimumPercentageDue15th); cmd.Parameters.AddWithValue("CreditMinimumAmountDue15th", Details.CreditMinimumAmountDue15th); cmd.Parameters.AddWithValue("CreditLatePenaltyCharge15th", Details.CreditLatePenaltyCharge15th); cmd.Parameters.AddWithValue("CreditCardTypeID", Details.CreditCardTypeID); cmd.Parameters.AddWithValue("CardTypeCode", Details.CardTypeCode); cmd.Parameters.AddWithValue("CreditCardType", Details.CreditCardType); cmd.Parameters.AddWithValue("WithGuarantor", Details.WithGuarantor); cmd.Parameters.AddWithValue("CreditUseLastDayCutOffDate", Details.CreditUseLastDayCutOffDate); 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.CommandText = SQL; return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillDetails setDetails(System.Data.DataTable dt) { CreditBillDetails Details = new CreditBillDetails(); foreach (System.Data.DataRow dr in dt.Rows) { //Details.CreditBillID = Int32.Parse(dr["CreditBillID"].ToString()); //Details.CreditBillsCode = dr["CreditBillsCode"].ToString(); //Details.CreditBillsName = dr["CreditBillsName"].ToString(); //Details.DBIP = dr["DBIP"].ToString(); //Details.DBPort = dr["DBPort"].ToString(); //Details.Address = dr["Address"].ToString(); //Details.Remarks = dr["Remarks"].ToString(); Details.CreditBillID = Int64.Parse(dr["CreditBillID"].ToString()); Details.CreditPurcStartDateToProcess = DateTime.Parse(dr["CreditPurcStartDateToProcess"].ToString()); Details.CreditPurcEndDateToProcess = DateTime.Parse(dr["CreditPurcEndDateToProcess"].ToString()); Details.BillingDate = DateTime.Parse(dr["BillingDate"].ToString()); Details.CreditCutOffDate = DateTime.Parse(dr["CreditCutOffDate"].ToString()); Details.CreditPaymentDueDate = DateTime.Parse(dr["CreditPaymentDueDate"].ToString()); Details.CreditCardTypeID = Int16.Parse(dr["CreditCardTypeID"].ToString()); Details.CardTypeCode = dr["CardTypeCode"].ToString(); Details.CreditCardType = (CreditCardTypes)Enum.Parse(typeof(CreditCardTypes), dr["CreditCardType"].ToString()); Details.WithGuarantor = bool.Parse(dr["WithGuarantor"].ToString()); Details.CreditUseLastDayCutOffDate = bool.Parse(dr["CreditUseLastDayCutOffDate"].ToString()); Details.CreditFinanceCharge = Decimal.Parse(dr["CreditFinanceCharge"].ToString()); Details.CreditMinimumPercentageDue = Decimal.Parse(dr["CreditMinimumPercentageDue"].ToString()); Details.CreditMinimumAmountDue = Decimal.Parse(dr["CreditMinimumAmountDue"].ToString()); Details.CreditLatePenaltyCharge = Decimal.Parse(dr["CreditLatePenaltyCharge"].ToString()); Details.CreditFinanceCharge15th = Decimal.Parse(dr["CreditFinanceCharge15th"].ToString()); Details.CreditMinimumPercentageDue15th = Decimal.Parse(dr["CreditMinimumPercentageDue15th"].ToString()); Details.CreditMinimumAmountDue15th = Decimal.Parse(dr["CreditMinimumAmountDue15th"].ToString()); Details.CreditLatePenaltyCharge15th = Decimal.Parse(dr["CreditLatePenaltyCharge15th"].ToString()); Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); Details.CreatedByID = Int64.Parse(dr["CreatedByID"].ToString()); Details.CreatedByName = dr["CreatedByName"].ToString(); } return(Details); }
public CreditBillDetails Details(Int64 CreditBillID) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = SQLSelect() + "WHERE CreditBillID = @CreditBillID;"; cmd.Parameters.AddWithValue("@CreditBillID", CreditBillID); 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); CreditBillDetails Details = setDetails(dt); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(CreditBillDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "INSERT INTO tblCreditBills(CreditPurcStartDateToProcess ,CreditPurcEndDateToProcess ,BillingDate ,CreditCutOffDate, CreditPaymentDueDate " + ",CreditFinanceCharge ,CreditMinimumPercentageDue ,CreditMinimumAmountDue ,CreditLatePenaltyCharge " + ",CreditFinanceCharge15th ,CreditMinimumPercentageDue15th ,CreditMinimumAmountDue15th ,CreditLatePenaltyCharge15th " + ",CreditCardTypeID ,CardTypeCode ,CreditCardType, WithGuarantor ,CreditUseLastDayCutOffDate " + ",CreatedOn ,CreatedByID ,CreatedByName)VALUES("; SQL += "@CreditPurcStartDateToProcess ,@CreditPurcEndDateToProcess ,@BillingDate ,@CreditCutOffDate, @CreditPaymentDueDate " + ",@CreditFinanceCharge ,@CreditMinimumPercentageDue ,@CreditMinimumAmountDue ,@CreditLatePenaltyCharge " + ",@CreditFinanceCharge15th ,@CreditMinimumPercentageDue15th ,@CreditMinimumAmountDue15th ,@CreditLatePenaltyCharge15th " + ",@CreditCardTypeID ,@CardTypeCode ,@CreditCardType, @WithGuarantor ,@CreditUseLastDayCutOffDate " + ",@CreatedOn ,@CreatedByID ,@CreatedByName)"; cmd.Parameters.AddWithValue("CreditPurcStartDateToProcess", Details.CreditPurcStartDateToProcess); cmd.Parameters.AddWithValue("CreditPurcEndDateToProcess", Details.CreditPurcEndDateToProcess); cmd.Parameters.AddWithValue("BranchName", Details.BillingDate); cmd.Parameters.AddWithValue("CreditCutOffDate", Details.CreditCutOffDate); cmd.Parameters.AddWithValue("CreditPaymentDueDate", Details.CreditPaymentDueDate); cmd.Parameters.AddWithValue("CreditFinanceCharge", Details.CreditFinanceCharge); cmd.Parameters.AddWithValue("CreditMinimumPercentageDue", Details.CreditMinimumPercentageDue); cmd.Parameters.AddWithValue("CreditMinimumAmountDue", Details.CreditMinimumAmountDue); cmd.Parameters.AddWithValue("CreditLatePenaltyCharge", Details.CreditLatePenaltyCharge); cmd.Parameters.AddWithValue("CreditFinanceCharge15th", Details.CreditFinanceCharge15th); cmd.Parameters.AddWithValue("CreditMinimumPercentageDue15th", Details.CreditMinimumPercentageDue15th); cmd.Parameters.AddWithValue("CreditMinimumAmountDue15th", Details.CreditMinimumAmountDue15th); cmd.Parameters.AddWithValue("CreditLatePenaltyCharge15th", Details.CreditLatePenaltyCharge15th); cmd.Parameters.AddWithValue("CreditCardTypeID", Details.CreditCardTypeID); cmd.Parameters.AddWithValue("CardTypeCode", Details.CardTypeCode); cmd.Parameters.AddWithValue("CreditCardType", Details.CreditCardType); cmd.Parameters.AddWithValue("WithGuarantor", Details.WithGuarantor); cmd.Parameters.AddWithValue("CreditUseLastDayCutOffDate", Details.CreditUseLastDayCutOffDate); 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.CommandText = SQL; return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public CreditBillDetails setDetails(System.Data.DataTable dt) { CreditBillDetails Details = new CreditBillDetails(); foreach (System.Data.DataRow dr in dt.Rows) { //Details.CreditBillID = Int32.Parse(dr["CreditBillID"].ToString()); //Details.CreditBillsCode = dr["CreditBillsCode"].ToString(); //Details.CreditBillsName = dr["CreditBillsName"].ToString(); //Details.DBIP = dr["DBIP"].ToString(); //Details.DBPort = dr["DBPort"].ToString(); //Details.Address = dr["Address"].ToString(); //Details.Remarks = dr["Remarks"].ToString(); Details.CreditBillID = Int64.Parse(dr["CreditBillID"].ToString()); Details.CreditPurcStartDateToProcess = DateTime.Parse(dr["CreditPurcStartDateToProcess"].ToString()); Details.CreditPurcEndDateToProcess = DateTime.Parse(dr["CreditPurcEndDateToProcess"].ToString()); Details.BillingDate = DateTime.Parse(dr["BillingDate"].ToString()); Details.CreditCutOffDate = DateTime.Parse(dr["CreditCutOffDate"].ToString()); Details.CreditPaymentDueDate = DateTime.Parse(dr["CreditPaymentDueDate"].ToString()); Details.CreditCardTypeID = Int16.Parse(dr["CreditCardTypeID"].ToString()); Details.CardTypeCode = dr["CardTypeCode"].ToString(); Details.CreditCardType = (CreditCardTypes) Enum.Parse(typeof(CreditCardTypes), dr["CreditCardType"].ToString()); Details.WithGuarantor = bool.Parse(dr["WithGuarantor"].ToString()); Details.CreditUseLastDayCutOffDate = bool.Parse(dr["CreditUseLastDayCutOffDate"].ToString()); Details.CreditFinanceCharge = Decimal.Parse(dr["CreditFinanceCharge"].ToString()); Details.CreditMinimumPercentageDue = Decimal.Parse(dr["CreditMinimumPercentageDue"].ToString()); Details.CreditMinimumAmountDue = Decimal.Parse(dr["CreditMinimumAmountDue"].ToString()); Details.CreditLatePenaltyCharge = Decimal.Parse(dr["CreditLatePenaltyCharge"].ToString()); Details.CreditFinanceCharge15th = Decimal.Parse(dr["CreditFinanceCharge15th"].ToString()); Details.CreditMinimumPercentageDue15th = Decimal.Parse(dr["CreditMinimumPercentageDue15th"].ToString()); Details.CreditMinimumAmountDue15th = Decimal.Parse(dr["CreditMinimumAmountDue15th"].ToString()); Details.CreditLatePenaltyCharge15th = Decimal.Parse(dr["CreditLatePenaltyCharge15th"].ToString()); Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); Details.CreatedByID = Int64.Parse(dr["CreatedByID"].ToString()); Details.CreatedByName = dr["CreatedByName"].ToString(); } return Details; }