public SysCreditConfigDetails get_SysCreditConfigDetails()
{
SysCreditConfigDetails clsSysCreditConfigDetails = new SysCreditConfigDetails();
clsSysCreditConfigDetails.BILLING_DATE = get_BILLING_DATE();
clsSysCreditConfigDetails.CREDIT_CUTOFF_DATE = get_CREDIT_CUTOFF_DATE();
clsSysCreditConfigDetails.CREDIT_FINANCE_CHARGE = get_CREDIT_FINANCE_CHARGE();
clsSysCreditConfigDetails.CREDIT_LATE_PENALTY_CHARGE = get_CREDIT_LATE_PENALTY_CHARGE();
clsSysCreditConfigDetails.CRED_MIN_AMOUNT_DUE = get_CRED_MIN_AMOUNT_DUE();
clsSysCreditConfigDetails.CRED_MIN_PERCENTAGE_DUE = get_CRED_MIN_PERCENTAGE_DUE();
clsSysCreditConfigDetails.CREDIT_USE_LASTDAY_CUTT_OFF_DATE = get_CREDIT_USE_LASTDAY_CUTT_OFF_DATE();
return(clsSysCreditConfigDetails);
}
public Int32 Save(SysCreditConfigDetails Details)
{
try
{
string SQL = "CALL procSaveSysCreditConfig(@ConfigName, @ConfigValue, @Remarks, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("Configname", Details.ConfigName);
cmd.Parameters.AddWithValue("ConfigValue", Details.ConfigValue);
cmd.Parameters.AddWithValue("Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public SysCreditConfigDetails get_SysCreditConfigDetails()
{
SysCreditConfigDetails clsSysCreditConfigDetails = new SysCreditConfigDetails();
clsSysCreditConfigDetails.BILLING_DATE = get_BILLING_DATE();
clsSysCreditConfigDetails.CREDIT_CUTOFF_DATE = get_CREDIT_CUTOFF_DATE();
clsSysCreditConfigDetails.CREDIT_FINANCE_CHARGE = get_CREDIT_FINANCE_CHARGE();
clsSysCreditConfigDetails.CREDIT_LATE_PENALTY_CHARGE = get_CREDIT_LATE_PENALTY_CHARGE();
clsSysCreditConfigDetails.CRED_MIN_AMOUNT_DUE = get_CRED_MIN_AMOUNT_DUE();
clsSysCreditConfigDetails.CRED_MIN_PERCENTAGE_DUE = get_CRED_MIN_PERCENTAGE_DUE();
clsSysCreditConfigDetails.CREDIT_USE_LASTDAY_CUTT_OFF_DATE = get_CREDIT_USE_LASTDAY_CUTT_OFF_DATE();
return clsSysCreditConfigDetails;
}
public Int32 Save(SysCreditConfigDetails Details)
{
try
{
string SQL = "CALL procSaveSysCreditConfig(@ConfigName, @ConfigValue, @Remarks, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("Configname", Details.ConfigName);
cmd.Parameters.AddWithValue("ConfigValue", Details.ConfigValue);
cmd.Parameters.AddWithValue("Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}