public void UpdateMerchant(mMerchant merchant) { using (SqlConnection consql = new SqlConnection(ConfigurationManager.ConnectionStrings["MerchantServiceDB"].ConnectionString)) { consql.Open(); SqlCommand cmd = new SqlCommand("sp_m_update_merchant", consql); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MerchantID", merchant.MPU_Merchant_ID); cmd.Parameters.AddWithValue("@Merchant_Name", merchant.Merchant_Name); cmd.Parameters.AddWithValue("@Merchant_Address", merchant.Merchant_Address); cmd.Parameters.AddWithValue("@Merchant_Email", merchant.Merchant_Email); cmd.Parameters.AddWithValue("@Merchant_Phone", merchant.Merchant_Phone); cmd.Parameters.AddWithValue("@Settlement_Acc", merchant.Settlement_Acc); cmd.Parameters.AddWithValue("@SettAccName", merchant.SettAccountName); cmd.Parameters.AddWithValue("@OMPURate", merchant.OMPURate); cmd.Parameters.AddWithValue("@OJCBRate", merchant.OJCBRate); cmd.Parameters.AddWithValue("@OUPIRate", merchant.OUPIRate); cmd.Parameters.AddWithValue("@MPURate", merchant.MPURate); cmd.Parameters.AddWithValue("@JCBRate", merchant.JCBRate); cmd.Parameters.AddWithValue("@UPIRate", merchant.UPIRate); cmd.Parameters.AddWithValue("@BusinessCategoryID", merchant.BusinessCategoryID); cmd.ExecuteNonQuery(); } }
public Double get_mdr_rate_mpunotonus(mMerchant merchant) { Double MDR = 0; using (Models.MerchantService db = new MerchantService()) { t_Merchant_Info merchant_info = new t_Merchant_Info(); merchant_info = db.t_Merchant_Info.Where(x => x.MPU_Merchant_ID == merchant.MPU_Merchant_ID).SingleOrDefault(); if (merchant_info != null) { MDR = Convert.ToDouble(merchant_info.MPURate); } else { MDR = -123; } } return(MDR); }