public int Update(SendGoodInfo info) { SqlParameter[] param = { new SqlParameter("@id", info.id) , new SqlParameter("@FunctionName",info.FunctionName), new SqlParameter("@UserId", info.UserId), new SqlParameter("@vouchers", info.vouchers), new SqlParameter("@Merchant_trans_id", info.Merchant_trans_id), new SqlParameter("@Merchant_code", info.Merchant_code), new SqlParameter("@Country_code", info.Country_code), new SqlParameter("@Good_code", info.Good_code), new SqlParameter("@Xml_description", info.Xml_description), new SqlParameter("@Net_cost", info.Net_cost), new SqlParameter("@Ship_fee", info.Ship_fee), new SqlParameter("@Tax", info.Tax), new SqlParameter("@Url_success", info.Url_success), new SqlParameter("@Url_fail", info.Url_fail), new SqlParameter("@Trans_key", info.Trans_key), new SqlParameter("@selected_bank", info.selected_bank), new SqlParameter("@service_code", info.service_code), new SqlParameter("@OutString", info.OutString), new SqlParameter("@ResultId", info.ResultId), new SqlParameter("@Trans_Id", info.Trans_Id), new SqlParameter("@CreateDate", info.CreateDate) }; return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_SendGood_Update", param)); }
public SendGoodInfo GetInfo(int id) { SendGoodInfo info = null; SqlParameter[] param = { new SqlParameter("@id", id) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_SendGood_GetById", param); if (r != null) { info = new SendGoodInfo(); while (r.Read()) { info = FillData(r); } r.Close(); r.Dispose(); } return(info); }
public static string Send_GoodInfo(string Good_code, string XMLDesc, string Net_cost, string Ship_Fee, string Tax, string URLSuccess, string URLFail, ref SendGoodInfo sendInfo) { string Merchant_trans_id = GetMerchantTransId(); string TransHash = Security.GetMD5Hash(Merchant_trans_id + Merchant_code + Good_code + Net_cost + Ship_Fee + Tax + Merchant_trans_key); // sendInfo.FunctionName = "Send_GoodInfo"; sendInfo.Merchant_code = Merchant_code; sendInfo.Merchant_trans_id = Merchant_trans_id; sendInfo.Net_cost = Net_cost; sendInfo.Ship_fee = Ship_Fee; sendInfo.Tax = Tax; sendInfo.Country_code = Country_Code; sendInfo.Trans_key = TransHash; // try { //string s =instance.Send_GoodInfo(Merchant_trans_id, Merchant_code, Country_Code, Good_code, XMLDesc, Net_cost, Ship_Fee, Tax, URLSuccess, URLFail, TransHash); string s = instance.Send_GoodInfo(Merchant_trans_id, Merchant_code, Country_Code, Good_code, XMLDesc, Net_cost, Ship_Fee, Tax, URLSuccess, URLFail, TransHash); // sendInfo.ResultId = getCodeResult(s); sendInfo.OutString = s; // return(s); } catch (Exception ex) { return(ex.Message); //throw; } }
private SendGoodInfo FillData(IDataReader r) { SendGoodInfo info = new SendGoodInfo(); if (!r.IsDBNull(r.GetOrdinal("id"))) { info.id = r.GetInt32(r.GetOrdinal("id")); } if (!r.IsDBNull(r.GetOrdinal("FunctionName"))) { info.FunctionName = r.GetString(r.GetOrdinal("FunctionName")); } if (!r.IsDBNull(r.GetOrdinal("UserId"))) { info.UserId = r.GetString(r.GetOrdinal("UserId")); } if (!r.IsDBNull(r.GetOrdinal("vouchers"))) { info.vouchers = r.GetString(r.GetOrdinal("vouchers")); } if (!r.IsDBNull(r.GetOrdinal("Merchant_trans_id"))) { info.Merchant_trans_id = r.GetString(r.GetOrdinal("Merchant_trans_id")); } if (!r.IsDBNull(r.GetOrdinal("Merchant_code"))) { info.Merchant_code = r.GetString(r.GetOrdinal("Merchant_code")); } if (!r.IsDBNull(r.GetOrdinal("Country_code"))) { info.Country_code = r.GetString(r.GetOrdinal("Country_code")); } if (!r.IsDBNull(r.GetOrdinal("Good_code"))) { info.Good_code = r.GetString(r.GetOrdinal("Good_code")); } if (!r.IsDBNull(r.GetOrdinal("Xml_description"))) { info.Xml_description = r.GetString(r.GetOrdinal("Xml_description")); } if (!r.IsDBNull(r.GetOrdinal("Net_cost"))) { info.Net_cost = r.GetString(r.GetOrdinal("Net_cost")); } if (!r.IsDBNull(r.GetOrdinal("Ship_fee"))) { info.Ship_fee = r.GetString(r.GetOrdinal("Ship_fee")); } if (!r.IsDBNull(r.GetOrdinal("Tax"))) { info.Tax = r.GetString(r.GetOrdinal("Tax")); } if (!r.IsDBNull(r.GetOrdinal("Url_success"))) { info.Url_success = r.GetString(r.GetOrdinal("Url_success")); } if (!r.IsDBNull(r.GetOrdinal("Url_fail"))) { info.Url_fail = r.GetString(r.GetOrdinal("Url_fail")); } if (!r.IsDBNull(r.GetOrdinal("Trans_key"))) { info.Trans_key = r.GetString(r.GetOrdinal("Trans_key")); } if (!r.IsDBNull(r.GetOrdinal("selected_bank"))) { info.selected_bank = r.GetString(r.GetOrdinal("selected_bank")); } if (!r.IsDBNull(r.GetOrdinal("service_code"))) { info.service_code = r.GetString(r.GetOrdinal("service_code")); } if (!r.IsDBNull(r.GetOrdinal("OutString"))) { info.OutString = r.GetString(r.GetOrdinal("OutString")); } if (!r.IsDBNull(r.GetOrdinal("ResultId"))) { info.ResultId = r.GetString(r.GetOrdinal("ResultId")); } if (!r.IsDBNull(r.GetOrdinal("Trans_Id"))) { info.Trans_Id = r.GetString(r.GetOrdinal("Trans_Id")); } if (!r.IsDBNull(r.GetOrdinal("CreateDate"))) { info.CreateDate = r.GetDateTime(r.GetOrdinal("CreateDate")); } return(info); }
private void SetInfo(HttpContext context) { string vouchers = context.Request["vouchers"]; if (string.IsNullOrEmpty(vouchers)) { context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 5, "Hãy nhập gói cước")); return; } var oUser = (CustomerGateInfo)context.Session[Config.GetSessionUser]; if (oUser == null) { context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 6, "Hết phiên làm việc, hãy thực hiện lại")); return; } if (!Utility.isOnlyNumber(vouchers)) { context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 7, "Gói cước không phù hợp")); return; } List <voucher> list = oUser.vouchers; voucher oVoucher = null; foreach (voucher item in list) { if (vouchers == item.vouchervalue) { oVoucher = item; break; } } if (oVoucher == null) { context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 8, "Gói cước không phù hợp")); return; } string Good_Code = string.Format("{0:yyMMddHHmmssfff}", DateTime.Now) + oVoucher.duration; Good_Code = Security.GetMD5Hash(Good_Code); Good_Code = "THAV-" + Good_Code.Substring(0, 15).ToUpper(); string sSuccess = context.Request.Url.Scheme + "://" + context.Request.Url.Authority + "/Banknet/success.aspx?code=" + Good_Code; string sFail = context.Request.Url.Scheme + "://" + context.Request.Url.Authority + "/Banknet/fail.aspx?code=" + Good_Code; SendGoodInfo sendInfo = new SendGoodInfo() { UserId = oUser.subnum, vouchers = oVoucher.vouchervalue + " - " + oVoucher.vouchername + " - " + oVoucher.duration + " " + oVoucher.durationuomaltcode, Good_code = Good_Code, Xml_description = Config.Desc, Url_success = sSuccess, Url_fail = sFail, CreateDate = DateTime.Now }; try { string s = BanknetHelper.Send_GoodInfo(Good_Code, Config.Desc, vouchers, "0", "0", sSuccess, sFail, ref sendInfo); if (BanknetHelper.getCodeResult(s) != "010") { context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 9, "Kết nối với cổng thanh toán Banknet gặp sự cố")); return; } string sUrl = ""; string sTrans_Id = ""; int iResult = BanknetHelper.GetUrlRedirection(s, out sUrl); if (iResult != 0) { context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 10, "Kết nối với cổng thanh toán Banknet gặp sự cố")); return; } sTrans_Id = BanknetHelper.getTransIdFromUrl(sUrl); sendInfo.Trans_Id = sTrans_Id; //save cached CacheInfo oCacheInfo = new CacheInfo() { Voucher = oVoucher, sTrans_Id = sTrans_Id, Good_Code = Good_Code, User = oUser, Merchant_trans_id = sendInfo.Merchant_trans_id }; CacheProvider.AddWithTimeOut(string.Format(KeyCache.KeyUserBanknet, Good_Code), oCacheInfo, 720); // context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", 0, sUrl)); return; } catch (Exception ex) { sendInfo.ResultId = ex.GetHashCode().ToString(); sendInfo.OutString = ex.Message; context.Response.Write(string.Format("{{\"error\":{0},\"msg\":\"{1}\"}}", sendInfo.ResultId, sendInfo.OutString)); } finally { SendGoodData.instance.Add(sendInfo); } }