public static int UpdateServiceTrans(SERVICE_TRANS_DTO service)
{
provider.connect();
string sqlCommand = "sp_UpdateServiceTrans";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@madv", service.MaDV));
list.Add(new SqlParameter("@tencty", service.TenCongTy));
list.Add(new SqlParameter("@linkws", service.LinkWebService));
// list.Add(new SqlParameter("@username",service.UserName));
// list.Add(new SqlParameter("@password",service.PassWord));
list.Add(new SqlParameter("@website", service.Website));
list.Add(new SqlParameter("@tinhtrang", service.TinhTrang));
SqlParameter result = new SqlParameter("@result", SqlDbType.Int);
result.Direction = ParameterDirection.ReturnValue;
list.Add(result);
try
{
provider.executeNonQueryProcedure(sqlCommand, list);
return((int)result.Value);
}
catch (Exception e)
{
throw e;
}
finally
{
provider.disconnect();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SERVICE_TRANS_DTO service = new SERVICE_TRANS_DTO();
service.TenCongTy = txtName.Text;
service.LinkWebService = txtLink.Text;
service.MaDV = int.Parse(hdfId.Value);
service.TinhTrang = int.Parse(DropDownList1.SelectedValue);
service.Website = txtWebsite.Text;
try
{
int result = ServiceTransBUS.UpdateServiceTrans(service);
if (result == 1)
{
lbResult.ForeColor = Color.Green;
lbResult.Text = "Đã cập nhật thành công";
}
else
{
lbResult.ForeColor = Color.Red;
lbResult.Text = "Đã có lỗi , xin vui lòng thử lại sau";
}
}
catch (Exception ex)
{
lbResult.ForeColor = Color.Red;
lbResult.Text = "Đã có lỗi , xin vui lòng thử lại sau";
}
}
public static TransportCompany[] GetTransportCompany()
{
TransportCompany[] companny = GeneralPurchasingDAO.GetTransportCompany();
foreach (TransportCompany cp in companny)
{
int madv = 0;
int.TryParse(cp.MaCongTyVanChuyen, out madv);
SERVICE_TRANS_DTO sv = GeneralPurchasingDAO.GetInfoServiceTrans(madv);
VanChuyen.FedexWebService1 proxy = new BizWebservice.VanChuyen.FedexWebService1();
proxy.Url = sv.LinkWebService;
//string sid = proxy.Authenticate(sv.UserName, sv.PassWord);
VanChuyen.TransportCompany tr = proxy.GetTranports();
int n = tr.HinhThucVanChuyen.Length;
cp.HinhThucVanChuyen = new TransportType[n];
if (tr != null)
{
cp.TenCongTyVanChuyen = tr.TenCongTyVanChuyen;
for (int i = 0; i < n; i++)
{
cp.HinhThucVanChuyen[i] = new TransportType();
cp.HinhThucVanChuyen[i].MaHinhThucVanChuyen = tr.HinhThucVanChuyen[i].MaHinhThucVanChuyen;
cp.HinhThucVanChuyen[i].TenHinhThucVanChuyen = tr.HinhThucVanChuyen[i].TenHinhThucVanChuyen;
cp.HinhThucVanChuyen[i].Gia = tr.HinhThucVanChuyen[i].Gia;
cp.HinhThucVanChuyen[i].DonViTien = tr.HinhThucVanChuyen[i].DonViTien;
}
}
}
return(companny);
}
public static string Confirm(string sid, string transCompanyId, string transTypeId, string validationCode, string contact)
{
int result = ConsumerDAO.CheckAvaliableSID(sid);
if (result >= 1)
{
int madv = 0;
if (int.TryParse(transCompanyId, out madv))
{
int madh = 0;
int.TryParse(validationCode, out madh);
int soluong = GeneralPurchasingDAO.GetNumberCouponInOrder(madh);
if (soluong == 0)
{
return("Đơn hàng chưa được duyệt");
}
int transtype = 0;
int.TryParse(transTypeId, out transtype);
SERVICE_TRANS_DTO sv = GeneralPurchasingDAO.GetInfoServiceTrans(madv);
/*string bizAddress = "";
* if (ConfigurationManager.AppSettings.GetValues(transCompanyId)[0] != null)
* {
* bizAddress = ConfigurationManager.AppSettings.GetValues(transCompanyId)[0];
* }
* else
* {
* bizAddress = ConfigurationManager.AppSettings.GetValues("biz")[0];
* }*/
VanChuyen.FedexWebService1 proxy = new BizWebservice.VanChuyen.FedexWebService1();
proxy.Url = sv.LinkWebService;
string id = proxy.Authenticate(sv.UserName, sv.PassWord);
// proxy.Url = "http://thuongmainhommot.somee.com/Service/WebServiceVanChuyen.asmx";
// string id = proxy.Authenticate("demo","123");
string url = proxy.TransportGoods(id, validationCode, soluong, DateTime.Today.Date.AddDays(1), contact, transtype, sv.BizAddress);
// if (url.IndexOf("http://") >= 0 || url.IndexOf("https://") >= 0)
if (url.IndexOf(".aspx?") >= 0)
{
// string package = proxy.GetPackageInfo(id, url);
int result1 = GeneralPurchasingDAO.ConfirmOrder(madh, contact, sid);
/* if (result1 != 1)
* {
* proxy.CancelPackage(id, url);
* }*/
}
return(url);
}
else
{
return("false");
}
}
else
{
return("Invalid sid");
}
}
public static int UpdateServiceTrans(SERVICE_TRANS_DTO service)
{
try
{
return(ServiceTransDAO.UpdateServiceTrans(service));
}
catch (Exception e)
{
throw e;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int isLogIn;
int.TryParse(Session["IsLogin"].ToString(), out isLogIn);
if (isLogIn == 1)
{
string typeUser = Session["LoaiUser"].ToString();
if (typeUser == "Admin")
{
if (!IsPostBack)
{
string query = Request.QueryString["madv"];
if (query != null)
{
int madv;
int.TryParse(query, out madv);
hdfId.Value = madv.ToString();
SERVICE_TRANS_DTO service = ServiceTransBUS.GetServiceTransInfor(madv);
txtName.Text = service.TenCongTy;
txtLink.Text = service.LinkWebService;
txtWebsite.Text = service.Website;
txtUserName.Text = service.UserName;
//txtPass.TextMode = TextBoxMode.SingleLine;
txtPass.Text = service.PassWord;
// txtPass.AutoPostBack = false;
// txtPass.TextMode = TextBoxMode.Password;
if (service.TinhTrang == 1)
{
DropDownList1.Items[0].Selected = true;
}
else
{
DropDownList1.Items[1].Selected = true;
}
}
}
}
else
{
Response.Redirect("../Shared/Default.aspx");
}
}
else
{
Response.Redirect("../Shared/Default.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
SERVICE_TRANS_DTO service = new SERVICE_TRANS_DTO();
service.TenCongTy = txtName.Text;
service.LinkWebService = txtLink.Text;
service.UserName = txtUserName.Text;
service.PassWord = txtPass.Text;
service.Website = txtWebsite.Text;
service.BizAddress = txtBizAddress.Text;
try
{
/* List<TransportType> transtypes = new List<TransportType>();
* for (int i = 0; i < grTransType.Rows.Count; i++)
* {
* TransportType trans = new TransportType();
* trans.MaHinhThucVanChuyen = i.ToString();
* trans.TenHinhThucVanChuyen = grTransType.Rows[i].Cells[0].Text;
* float price;
* float.TryParse(((TextBox)grTransType.Rows[i].FindControl("txtPrice")).Text, out price);
* trans.Gia = price;
* trans.DonViTien = ((TextBox)grTransType.Rows[i].FindControl("txtMoney")).Text;
* transtypes.Add(trans);
* }*/
int result = ServiceTransBUS.InsertServiceTrans(service);
if (result == 1)
{
lbResult.ForeColor = Color.Green;
lbResult.Text = "Đã thêm thành công";
}
else
{
lbResult.ForeColor = Color.Red;
lbResult.Text = "Lỗi hệ thống, vui lòng thử lại sau!";
}
}
catch (Exception ex)
{
lbResult.ForeColor = Color.Red;
lbResult.Text = "Lỗi hệ thống, vui lòng thử lại sau!";
}
}
private static void TransFerToListServiceTrans(List <SERVICE_TRANS_DTO> services, DataTable table)
{
int n = table.Rows.Count;
for (int i = 0; i < n; i++)
{
DataRow row = table.Rows[i];
SERVICE_TRANS_DTO sv = new SERVICE_TRANS_DTO();
sv.MaDV = int.Parse(row["MADV"].ToString());
sv.TenCongTy = row["TENCTY"].ToString();
sv.LinkWebService = row["LINKWS"].ToString();
sv.UserName = row["USERNAME"].ToString();
sv.PassWord = row["PASS_WORD"].ToString();
sv.TinhTrang = int.Parse(row["TINHTRANG"].ToString());
sv.Title = "Cập nhật";
sv.Website = row["WEBSITE"].ToString();
sv.BizAddress = row["BIZADDRESS"].ToString();
services.Add(sv);
}
}
public static int InsertServiceTrans(SERVICE_TRANS_DTO service)
{
try
{
int madv = ServiceTransDAO.InsertServiceTrans(service);
if (madv == -1)
{
return(-1);
}
/* foreach (TransportType type in types)
* {
* type.Madv = madv;
* ServiceTransDAO.InsertTransType(type);
* }*/
return(1);
}
catch (Exception e)
{
throw e;
}
}
protected void btnPayment_Click(object sender, EventArgs e)
{
string ma = rdvc.SelectedValue;
string[] arr = ma.Split(new char[] { ',' });
int madv = 0;
int.TryParse(arr[0], out madv);
int type = 0;
int.TryParse(arr[1], out type);
string bank = rdbank.SelectedValue;
string[] bankarr = bank.Split(new char[] { '+' });
string bankid = bankarr[0];
string stk = bankarr[1];
/* tao don hang , va xoa gio hang */
if (Session["Cart"] != null)
{
List <GioHang> carts = (List <GioHang>)Session["Cart"];
if (carts.Count > 0)
{
DON_HANG_DTO dh = new DON_HANG_DTO();
dh.DiaChiNhan = txtAddress.Text;
dh.DonViTienTe = carts[0].TienTe;
dh.NgayGiao = DateTime.Now;
dh.UserName = Session["User"].ToString();
dh.TongTien = 0;
foreach (GioHang cart in carts)
{
dh.TongTien += (cart.DonGia * cart.SoLuong);
}
int madh = 0;
madh = DonHangBUS.InsetOrder(dh);
dh.ChiTiet = new List <CHI_TIET_DON_HANG_DTO>();
foreach (GioHang cart in carts)
{
CHI_TIET_DON_HANG_DTO ct = new CHI_TIET_DON_HANG_DTO();
ct.donGia = cart.DonGia;
ct.donViTinh = cart.DonViTinh;
ct.maDonHang = madh;
ct.maSanPham = cart.MaSanPham;
ct.soLuong = cart.SoLuong;
try
{
DonHangBUS.InsertCTOrder(ct);
}
catch (Exception ex)
{
continue;
}
}
/* thanh toan */
SERVICE_BANK_DTO svbank = ServiceBankBUS.LayServiceBankTheoMaBank(bankid);
NganHang.KhachHangWS proxy1 = new BIZ.NganHang.KhachHangWS();
string sid = proxy1.Authenticate(svbank.UserName, svbank.PassWord);
int result = proxy1.TransferMoney(sid, txtId.Text, bankid, svbank.Stk, svbank.MaBank, dh.TongTien, "VND");
if (result == 1)
{
/* dang ky van chuyen */
SERVICE_TRANS_DTO svtran = ServiceTransBUS.GetServiceTransInfor(madv);
VanChuyen.FedexWebService1 proxy2 = new BIZ.VanChuyen.FedexWebService1();
sid = proxy2.Authenticate(svtran.UserName, svtran.PassWord);
string url = proxy2.TransportGoods(sid, madh.ToString(), carts.Count, DateTime.Now.AddDays(1), txtAddress.Text, type, svtran.BizAddress);
if (url.IndexOf(".aspx?") >= 0 || url.IndexOf("http://") >= 0 || url.IndexOf("https://") >= 0)
{
PACKAGEINFO_DTO pac = new PACKAGEINFO_DTO();
pac.URL = url;
pac.MaServiceTrans = svtran.MaDV;
pac.PackageInfo = madh.ToString();
try
{
DonHangBUS.InsertPackage(pac, madh);
foreach (GioHang cart in carts)
{
//CHI_TIET_DON_HANG_DTO ct = new CHI_TIET_DON_HANG_DTO();
try
{
ProductBUS.UpdateSLProduct(cart.MaSanPham, cart.SoLuong);
}
catch (Exception ex)
{
continue;
}
}
Session["Cart"] = null;
lbresult.ForeColor = Color.Green;
lbresult.Text = "Quá trình mua đã thành công";
}
catch (Exception ex)
{
throw ex;
}
}
else
{
lbresult.ForeColor = Color.Red;
lbresult.Text = "Đã thanh toán nhưng đặt vận chuyển thất bại";
}
}
else
{
switch (result)
{
case 2:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Tài khoản chuyển không đủ tiền";
break;
case 3:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Tài khoản chuyển không tồn tại";
break;
case 4:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Tài khoản nhận không tồn tại";
break;
case 5:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Mã ngân hàng chuyển tiền/Mã ngân hàng nhận tiền không tồn tại ";
break;
case 6:
lbresult.ForeColor = Color.Red;
lbresult.Text = "Lỗi khác";
break;
}
}
}
}
}