public bool Insert(ContactCreditCardInfoDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procContactCreditModify(@CustomerID, @GuarantorID, @CreditCardTypeID, @CreditCardNo, @CreditAwardDate, @CreditCardStatus, @ExpiryDate, @CreditActive, @CreditLimit);"; cmd.Parameters.AddWithValue("@CustomerID", Details.CustomerID); cmd.Parameters.AddWithValue("@GuarantorID", Details.GuarantorID); cmd.Parameters.AddWithValue("@CreditCardTypeID", Convert.ToInt16(Details.CardTypeDetails.CardTypeID)); cmd.Parameters.AddWithValue("@CreditCardNo", Details.CreditCardNo); cmd.Parameters.AddWithValue("@CreditAwardDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@CreditCardStatus", Details.CreditCardStatus.ToString("d")); cmd.Parameters.AddWithValue("@ExpiryDate", Details.ExpiryDate.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@CreditActive", Convert.ToInt16(Details.CreditActive)); cmd.Parameters.AddWithValue("@CreditLimit", Details.CreditLimit); cmd.CommandText = SQL; bool bolRetValue = false; if (base.ExecuteNonQuery(cmd) > 0) { bolRetValue = true; } return(bolRetValue); } catch (Exception ex) { throw base.ThrowException(ex); } }
public bool Insert(ContactCreditCardInfoDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procContactCreditModify(@CustomerID, @GuarantorID, @CreditCardTypeID, @CreditCardNo, @CreditAwardDate, @CreditCardStatus, @ExpiryDate, @CreditActive, @CreditLimit);"; cmd.Parameters.AddWithValue("@CustomerID", Details.CustomerID); cmd.Parameters.AddWithValue("@GuarantorID", Details.GuarantorID); cmd.Parameters.AddWithValue("@CreditCardTypeID", Convert.ToInt16(Details.CardTypeDetails.CardTypeID)); cmd.Parameters.AddWithValue("@CreditCardNo", Details.CreditCardNo); cmd.Parameters.AddWithValue("@CreditAwardDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@CreditCardStatus", Details.CreditCardStatus.ToString("d")); cmd.Parameters.AddWithValue("@ExpiryDate", Details.ExpiryDate.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@CreditActive", Convert.ToInt16(Details.CreditActive)); cmd.Parameters.AddWithValue("@CreditLimit", Details.CreditLimit); cmd.CommandText = SQL; bool bolRetValue = false; if (base.ExecuteNonQuery(cmd) > 0) bolRetValue = true; return bolRetValue; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ContactCreditCardInfoDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procSaveContactCreditCardInfo(@CustomerID, @GuarantorID, @CreditCardTypeID, @CreditCardNo, @CreditAwardDate, " + "@TotalPurchases, @CreditPaid, @CreditCardStatus, @ExpiryDate, @EmbossedCardNo, " + "@LastBillingDate, @Last2BillingDate, @CreatedOn, @LastModified);"; cmd.Parameters.AddWithValue("CustomerID", Details.CustomerID); cmd.Parameters.AddWithValue("GuarantorID", Details.GuarantorID); cmd.Parameters.AddWithValue("CreditCardTypeID", Details.CardTypeDetails.CardTypeID); cmd.Parameters.AddWithValue("CreditCardNo", Details.CreditCardNo); cmd.Parameters.AddWithValue("CreditAwardDate", Details.CreditAwardDate); cmd.Parameters.AddWithValue("TotalPurchases", Details.TotalPurchases); cmd.Parameters.AddWithValue("CreditPaid", Details.CreditPaid); cmd.Parameters.AddWithValue("CreditCardStatus", Details.CreditCardStatus.ToString("d")); cmd.Parameters.AddWithValue("ExpiryDate", Details.ExpiryDate); cmd.Parameters.AddWithValue("EmbossedCardNo", Details.CreditCardNo); cmd.Parameters.AddWithValue("LastBillingDate", Details.LastBillingDate); cmd.Parameters.AddWithValue("Last2BillingDate", Details.Last2BillingDate); 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 bool Update(ContactCreditCardInfoDetails Details) { try { return(Insert(Details)); } catch (Exception ex) { throw base.ThrowException(ex); } }
private ContactCreditCardInfoDetails setDetails(System.Data.DataTable dt) { ContactCreditCardInfoDetails Details = new ContactCreditCardInfoDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.CustomerID = Int64.Parse(dr["CustomerID"].ToString()); Details.GuarantorID = Int64.Parse(dr["GuarantorID"].ToString()); Details.CardTypeDetails = new CardType(base.Connection, base.Transaction).Details(Int16.Parse(dr["CreditCardTypeID"].ToString())); Details.CreditCardNo = "" + dr["CreditCardNo"].ToString(); Details.CreditAwardDate = DateTime.Parse(dr["CreditAwardDate"].ToString()); Details.TotalPurchases = decimal.Parse(dr["TotalPurchases"].ToString()); Details.CreditPaid = decimal.Parse(dr["CreditPaid"].ToString()); Details.CreditCardStatus = (CreditCardStatus)Enum.Parse(typeof(CreditCardStatus), dr["CreditCardStatus"].ToString()); Details.EmbossedCardNo = "" + dr["EmbossedCardNo"].ToString(); Details.ExpiryDate = DateTime.Parse(dr["ExpiryDate"].ToString()); Details.LastBillingDate = DateTime.Parse(dr["LastBillingDate"].ToString()); Details.Last2BillingDate = DateTime.Parse(dr["Last2BillingDate"].ToString()); Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); Details.LastModified = DateTime.Parse(dr["LastModified"].ToString()); } return(Details); }
public bool Update(ContactCreditCardInfoDetails Details) { try { return Insert(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
private ContactCreditCardInfoDetails setDetails(System.Data.DataTable dt) { ContactCreditCardInfoDetails Details = new ContactCreditCardInfoDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.CustomerID = Int64.Parse(dr["CustomerID"].ToString()); Details.GuarantorID = Int64.Parse(dr["GuarantorID"].ToString()); Details.CardTypeDetails = new CardType(base.Connection, base.Transaction).Details(Int16.Parse(dr["CreditCardTypeID"].ToString())); Details.CreditCardNo = "" + dr["CreditCardNo"].ToString(); Details.CreditAwardDate = DateTime.Parse(dr["CreditAwardDate"].ToString()); Details.TotalPurchases = decimal.Parse(dr["TotalPurchases"].ToString()); Details.CreditPaid = decimal.Parse(dr["CreditPaid"].ToString()); Details.CreditCardStatus = (CreditCardStatus)Enum.Parse(typeof(CreditCardStatus), dr["CreditCardStatus"].ToString()); Details.EmbossedCardNo = "" + dr["EmbossedCardNo"].ToString(); Details.ExpiryDate = DateTime.Parse(dr["ExpiryDate"].ToString()); Details.LastBillingDate = DateTime.Parse(dr["LastBillingDate"].ToString()); Details.Last2BillingDate = DateTime.Parse(dr["Last2BillingDate"].ToString()); Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString()); Details.LastModified = DateTime.Parse(dr["LastModified"].ToString()); } return Details; }
public Int32 Save(ContactCreditCardInfoDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procSaveContactCreditCardInfo(@CustomerID, @GuarantorID, @CreditCardTypeID, @CreditCardNo, @CreditAwardDate, " + "@TotalPurchases, @CreditPaid, @CreditCardStatus, @ExpiryDate, @EmbossedCardNo, " + "@LastBillingDate, @Last2BillingDate, @CreatedOn, @LastModified);"; cmd.Parameters.AddWithValue("CustomerID", Details.CustomerID); cmd.Parameters.AddWithValue("GuarantorID", Details.GuarantorID); cmd.Parameters.AddWithValue("CreditCardTypeID", Details.CardTypeDetails.CardTypeID); cmd.Parameters.AddWithValue("CreditCardNo", Details.CreditCardNo); cmd.Parameters.AddWithValue("CreditAwardDate", Details.CreditAwardDate); cmd.Parameters.AddWithValue("TotalPurchases", Details.TotalPurchases); cmd.Parameters.AddWithValue("CreditPaid", Details.CreditPaid); cmd.Parameters.AddWithValue("CreditCardStatus", Details.CreditCardStatus.ToString("d")); cmd.Parameters.AddWithValue("ExpiryDate", Details.ExpiryDate); cmd.Parameters.AddWithValue("EmbossedCardNo", Details.CreditCardNo); cmd.Parameters.AddWithValue("LastBillingDate", Details.LastBillingDate); cmd.Parameters.AddWithValue("Last2BillingDate", Details.Last2BillingDate); 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); } }