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;
}