private CardTypeDetails setDetails(System.Data.DataTable dt)
{
CardTypeDetails Details = new CardTypeDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.CardTypeID = Int16.Parse(dr["CardTypeID"].ToString());
Details.CardTypeCode = dr["CardTypeCode"].ToString();
Details.CardTypeName = dr["CardTypeName"].ToString();
Details.CreditFinanceCharge = decimal.Parse(dr["CreditFinanceCharge"].ToString());
Details.CreditLatePenaltyCharge = decimal.Parse(dr["CreditLatePenaltyCharge"].ToString());
Details.CreditMinimumAmountDue = decimal.Parse(dr["CreditMinimumAmountDue"].ToString());
Details.CreditMinimumPercentageDue = decimal.Parse(dr["CreditMinimumPercentageDue"].ToString());
Details.CreditFinanceCharge15th = decimal.Parse(dr["CreditFinanceCharge15th"].ToString());
Details.CreditLatePenaltyCharge15th = decimal.Parse(dr["CreditLatePenaltyCharge15th"].ToString());
Details.CreditMinimumAmountDue15th = decimal.Parse(dr["CreditMinimumAmountDue15th"].ToString());
Details.CreditMinimumPercentageDue15th = decimal.Parse(dr["CreditMinimumPercentageDue15th"].ToString());
Details.CreditPurcStartDateToProcess = DateTime.Parse(dr["CreditPurcStartDateToProcess"].ToString());
Details.CreditPurcEndDateToProcess = DateTime.Parse(dr["CreditPurcEndDateToProcess"].ToString());
Details.CreditCutOffDate = DateTime.Parse(dr["CreditCutOffDate"].ToString());
Details.CreditCardType = (CreditCardTypes)Enum.Parse(typeof(CreditCardTypes), dr["CreditCardType"].ToString());
Details.WithGuarantor = bool.Parse(dr["WithGuarantor"].ToString());
Details.ExemptInTerminalCharge = bool.Parse(dr["ExemptInTerminalCharge"].ToString());
Details.BillingDate = DateTime.Parse(dr["BillingDate"].ToString());
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return(Details);
}
public void Update(CardTypeDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(CardTypeDetails Details)
{
try
{
Save(Details);
return(Int16.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(CardTypeDetails SearchKeys, string SortField = "CardTypeCode", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE 1=1 ";
if (SearchKeys.CreditCardType != CreditCardTypes.Both)
{
SQL += "AND CreditCardType = @CreditCardType ";
cmd.Parameters.AddWithValue("CreditCardType", SearchKeys.CreditCardType.ToString("d"));
}
if (!string.IsNullOrEmpty(SearchKeys.CardTypeCode))
{
SQL += "AND CardTypeCode = @CardTypeCode ";
cmd.Parameters.AddWithValue("CardTypeCode", SearchKeys.CardTypeCode);
}
if (!string.IsNullOrEmpty(SearchKeys.CardTypeCode))
{
SQL += "AND CardTypeName = @CardTypeName ";
cmd.Parameters.AddWithValue("CardTypeName", SearchKeys.CardTypeName);
}
if (SearchKeys.CheckGuarantor)
{
SQL += "AND WithGuarantor = @WithGuarantor ";
cmd.Parameters.AddWithValue("WithGuarantor", SearchKeys.WithGuarantor);
}
SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "CardTypeCode") + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
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);
return(dt);
}
public Int32 Save(CardTypeDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveCardType(@CardTypeID, @CardTypeCode, @CardTypeName, @CreditFinanceCharge, @CreditLatePenaltyCharge, @CreditMinimumAmountDue, @CreditMinimumPercentageDue, " +
"@CreditFinanceCharge15th, @CreditLatePenaltyCharge15th, @CreditMinimumAmountDue15th, @CreditMinimumPercentageDue15th, " +
"@CreditCardType, @WithGuarantor, @ExemptInTerminalCharge, @BillingDate, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("CardTypeID", Details.CardTypeID);
cmd.Parameters.AddWithValue("CardTypeCode", Details.CardTypeCode);
cmd.Parameters.AddWithValue("CardTypeName", Details.CardTypeName);
cmd.Parameters.AddWithValue("CreditFinanceCharge", Details.CreditFinanceCharge);
cmd.Parameters.AddWithValue("CreditLatePenaltyCharge", Details.CreditLatePenaltyCharge);
cmd.Parameters.AddWithValue("CreditMinimumAmountDue", Details.CreditMinimumAmountDue);
cmd.Parameters.AddWithValue("CreditMinimumPercentageDue", Details.CreditMinimumPercentageDue);
cmd.Parameters.AddWithValue("CreditFinanceCharge15th", Details.CreditFinanceCharge15th);
cmd.Parameters.AddWithValue("CreditLatePenaltyCharge15th", Details.CreditLatePenaltyCharge15th);
cmd.Parameters.AddWithValue("CreditMinimumAmountDue15th", Details.CreditMinimumAmountDue15th);
cmd.Parameters.AddWithValue("CreditMinimumPercentageDue15th", Details.CreditMinimumPercentageDue15th);
cmd.Parameters.AddWithValue("CreditCardType", Details.CreditCardType);
cmd.Parameters.AddWithValue("WithGuarantor", Details.WithGuarantor);
cmd.Parameters.AddWithValue("ExemptInTerminalCharge", Details.ExemptInTerminalCharge);
cmd.Parameters.AddWithValue("BillingDate", Details.BillingDate == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.BillingDate);
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);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
CardType clsCardType = new CardType();
CardTypeDetails clsDetails = new CardTypeDetails();
clsDetails.CardTypeID = Convert.ToInt16(lblCardTypeID.Text);
clsDetails.CardTypeCode = txtCardTypeCode.Text;
clsDetails.CardTypeName = txtCardTypeName.Text;
clsDetails.CreditFinanceCharge = decimal.Parse(txtCreditFinanceCharge.Text);
clsDetails.CreditLatePenaltyCharge = decimal.Parse(txtCreditLatePenaltyCharge.Text);
clsDetails.CreditMinimumAmountDue = decimal.Parse(txtCreditMinimumAmountDue.Text);
clsDetails.CreditMinimumPercentageDue = decimal.Parse(txtCreditMinimumPercentageDue.Text);
clsDetails.CreditFinanceCharge15th = decimal.Parse(txtCreditFinanceCharge15th.Text);
clsDetails.CreditLatePenaltyCharge15th = decimal.Parse(txtCreditLatePenaltyCharge15th.Text);
clsDetails.CreditMinimumAmountDue15th = decimal.Parse(txtCreditMinimumAmountDue15th.Text);
clsDetails.CreditMinimumPercentageDue15th = decimal.Parse(txtCreditMinimumPercentageDue15th.Text);
clsDetails.WithGuarantor = chkWithGuarantor.Checked;
clsDetails.ExemptInTerminalCharge = chkExemptInTerminalCharge.Checked;
clsDetails.CreatedOn = DateTime.Parse(lblCreatedOn.Text);
clsDetails.LastModified = DateTime.Now;
clsCardType.Update(clsDetails);
clsCardType.CommitAndDispose();
}
private Int32 SaveRecord()
{
CardType clsCardType = new CardType();
CardTypeDetails clsDetails = new CardTypeDetails(CreditCardTypes.External);
clsDetails.CardTypeCode = txtCardTypeCode.Text;
clsDetails.CardTypeName = txtCardTypeName.Text;
clsDetails.CreatedOn = DateTime.Now;
clsDetails.LastModified = DateTime.Now;
Int32 id = clsCardType.Insert(clsDetails);
clsCardType.CommitAndDispose();
return id;
}
private Int32 SaveRecord()
{
CardType clsCardType = new CardType();
CardTypeDetails clsDetails = new CardTypeDetails(CreditCardTypes.Internal);
clsDetails.CardTypeCode = txtCardTypeCode.Text;
clsDetails.CardTypeName = txtCardTypeName.Text;
clsDetails.CreditFinanceCharge = decimal.Parse(txtCreditFinanceCharge.Text);
clsDetails.CreditLatePenaltyCharge = decimal.Parse(txtCreditLatePenaltyCharge.Text);
clsDetails.CreditMinimumAmountDue = decimal.Parse(txtCreditMinimumAmountDue.Text);
clsDetails.CreditMinimumPercentageDue = decimal.Parse(txtCreditMinimumPercentageDue.Text);
clsDetails.CreditFinanceCharge15th = decimal.Parse(txtCreditFinanceCharge15th.Text);
clsDetails.CreditLatePenaltyCharge15th = decimal.Parse(txtCreditLatePenaltyCharge15th.Text);
clsDetails.CreditMinimumAmountDue15th = decimal.Parse(txtCreditMinimumAmountDue15th.Text);
clsDetails.CreditMinimumPercentageDue15th = decimal.Parse(txtCreditMinimumPercentageDue15th.Text);
clsDetails.WithGuarantor = chkWithGuarantor.Checked;
clsDetails.ExemptInTerminalCharge = chkExemptInTerminalCharge.Checked;
clsDetails.CreatedOn = DateTime.Now;
clsDetails.LastModified = DateTime.Now;
Int32 id = clsCardType.Insert(clsDetails);
clsCardType.CommitAndDispose();
return id;
}
private void LoadList()
{
CardType clsCardType = new CardType();
DataClass clsDataClass = new DataClass();
string SortField = "CardTypeID";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"]!=null)
{ sortoption = (SortOption) Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
Data.CardTypeDetails SearchKeys = new CardTypeDetails(CreditCardTypes.Internal);
if (Request.QueryString["Search"]!=null)
{
SearchKeys.CardTypeCode = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
SearchKeys.CardTypeName = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
}
PageData.DataSource = clsCardType.ListAsDataTable(SearchKeys, SortField, sortoption).DefaultView;
clsCardType.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i=0; i < PageData.PageCount;i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{ cboCurrentPage.Items[i].Selected = true;}
else
{ cboCurrentPage.Items[i].Selected = false;}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
public System.Data.DataTable ListAsDataTable(CardTypeDetails SearchKeys, string SortField = "CardTypeCode", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE 1=1 ";
if (SearchKeys.CreditCardType != CreditCardTypes.Both)
{
SQL += "AND CreditCardType = @CreditCardType ";
cmd.Parameters.AddWithValue("CreditCardType", SearchKeys.CreditCardType.ToString("d"));
}
if (!string.IsNullOrEmpty(SearchKeys.CardTypeCode))
{
SQL += "AND CardTypeCode = @CardTypeCode ";
cmd.Parameters.AddWithValue("CardTypeCode", SearchKeys.CardTypeCode);
}
if (!string.IsNullOrEmpty(SearchKeys.CardTypeCode))
{
SQL += "AND CardTypeName = @CardTypeName ";
cmd.Parameters.AddWithValue("CardTypeName", SearchKeys.CardTypeName);
}
if (SearchKeys.CheckGuarantor)
{
SQL += "AND WithGuarantor = @WithGuarantor ";
cmd.Parameters.AddWithValue("WithGuarantor", SearchKeys.WithGuarantor);
}
SQL += "ORDER BY " + (!string.IsNullOrEmpty(SortField) ? SortField : "CardTypeCode") + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
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);
return dt;
}
private CardTypeDetails setDetails(System.Data.DataTable dt)
{
CardTypeDetails Details = new CardTypeDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.CardTypeID = Int16.Parse(dr["CardTypeID"].ToString());
Details.CardTypeCode = dr["CardTypeCode"].ToString();
Details.CardTypeName = dr["CardTypeName"].ToString();
Details.CreditFinanceCharge = decimal.Parse(dr["CreditFinanceCharge"].ToString());
Details.CreditLatePenaltyCharge = decimal.Parse(dr["CreditLatePenaltyCharge"].ToString());
Details.CreditMinimumAmountDue = decimal.Parse(dr["CreditMinimumAmountDue"].ToString());
Details.CreditMinimumPercentageDue = decimal.Parse(dr["CreditMinimumPercentageDue"].ToString());
Details.CreditFinanceCharge15th = decimal.Parse(dr["CreditFinanceCharge15th"].ToString());
Details.CreditLatePenaltyCharge15th = decimal.Parse(dr["CreditLatePenaltyCharge15th"].ToString());
Details.CreditMinimumAmountDue15th = decimal.Parse(dr["CreditMinimumAmountDue15th"].ToString());
Details.CreditMinimumPercentageDue15th = decimal.Parse(dr["CreditMinimumPercentageDue15th"].ToString());
Details.CreditPurcStartDateToProcess = DateTime.Parse(dr["CreditPurcStartDateToProcess"].ToString());
Details.CreditPurcEndDateToProcess = DateTime.Parse(dr["CreditPurcEndDateToProcess"].ToString());
Details.CreditCutOffDate = DateTime.Parse(dr["CreditCutOffDate"].ToString());
Details.CreditCardType = (CreditCardTypes)Enum.Parse(typeof(CreditCardTypes), dr["CreditCardType"].ToString());
Details.WithGuarantor = bool.Parse(dr["WithGuarantor"].ToString());
Details.ExemptInTerminalCharge = bool.Parse(dr["ExemptInTerminalCharge"].ToString());
Details.BillingDate = DateTime.Parse(dr["BillingDate"].ToString());
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
}
return Details;
}
public Int32 Save(CardTypeDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveCardType(@CardTypeID, @CardTypeCode, @CardTypeName, @CreditFinanceCharge, @CreditLatePenaltyCharge, @CreditMinimumAmountDue, @CreditMinimumPercentageDue, " +
"@CreditFinanceCharge15th, @CreditLatePenaltyCharge15th, @CreditMinimumAmountDue15th, @CreditMinimumPercentageDue15th, " +
"@CreditCardType, @WithGuarantor, @ExemptInTerminalCharge, @BillingDate, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("CardTypeID", Details.CardTypeID);
cmd.Parameters.AddWithValue("CardTypeCode", Details.CardTypeCode);
cmd.Parameters.AddWithValue("CardTypeName", Details.CardTypeName);
cmd.Parameters.AddWithValue("CreditFinanceCharge", Details.CreditFinanceCharge);
cmd.Parameters.AddWithValue("CreditLatePenaltyCharge", Details.CreditLatePenaltyCharge);
cmd.Parameters.AddWithValue("CreditMinimumAmountDue", Details.CreditMinimumAmountDue);
cmd.Parameters.AddWithValue("CreditMinimumPercentageDue", Details.CreditMinimumPercentageDue);
cmd.Parameters.AddWithValue("CreditFinanceCharge15th", Details.CreditFinanceCharge15th);
cmd.Parameters.AddWithValue("CreditLatePenaltyCharge15th", Details.CreditLatePenaltyCharge15th);
cmd.Parameters.AddWithValue("CreditMinimumAmountDue15th", Details.CreditMinimumAmountDue15th);
cmd.Parameters.AddWithValue("CreditMinimumPercentageDue15th", Details.CreditMinimumPercentageDue15th);
cmd.Parameters.AddWithValue("CreditCardType", Details.CreditCardType);
cmd.Parameters.AddWithValue("WithGuarantor", Details.WithGuarantor);
cmd.Parameters.AddWithValue("ExemptInTerminalCharge", Details.ExemptInTerminalCharge);
cmd.Parameters.AddWithValue("BillingDate", Details.BillingDate == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.BillingDate);
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);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(CardTypeDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(CardTypeDetails Details)
{
try
{
Save(Details);
return Int16.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
