public static SERVICE_BANK_DTO LayServiceBankTheoMaBank(string mabank)
{
provider.connect();
string sqlCommand = "sp_LaySERVICEBANKTheoMaBank";
List<SqlParameter> list = new List<SqlParameter>();
list.Add(new SqlParameter("@MABANK", mabank));
try
{
SERVICE_BANK_DTO bank = new SERVICE_BANK_DTO();
DataTable table = provider.executeQueryDataTableProcedure(sqlCommand, list);
if (table != null && table.Rows.Count > 0)
{
DataRow dr = table.Rows[0];
bank.MaBank = dr["MABANK"].ToString();
bank.TenBank = dr["TENBANK"].ToString();
bank.UserName = dr["USERNAMEB"].ToString();
bank.PassWord = dr["PASSWORDB"].ToString();
bank.LinkWebService = dr["LINKWS"].ToString();
bank.AnhBank = dr["ANHBANK"].ToString();
bank.TinhTrangWS = int.Parse(dr["TINHTRANGWS"].ToString());
bank.Stk = dr["STK"].ToString();
bank.Website = dr["WEBSITE"].ToString();
}
return bank;
}
catch (Exception ex)
{
throw ex;
}
finally
{
provider.disconnect();
}
}
public static int InsertServiceBank(SERVICE_BANK_DTO bank)
{
provider.connect();
string sqlCommand = "sp_Insert_SERVICEBANK";
List<SqlParameter> list = new List<SqlParameter>();
list.Add(new SqlParameter("@MABANK", bank.MaBank));
list.Add(new SqlParameter("@TENBANK", bank.TenBank));
list.Add(new SqlParameter("@USERNAMEB", bank.UserName));
list.Add(new SqlParameter("@PASSWORDB", bank.PassWord));
list.Add(new SqlParameter("@LINKWS", bank.LinkWebService));
list.Add(new SqlParameter("@ANHBANK", bank.AnhBank));
list.Add(new SqlParameter("@TINHTRANGWS", bank.TinhTrangWS));
list.Add(new SqlParameter("@WEBSITE", bank.Website));
list.Add(new SqlParameter("@stk", bank.Stk));
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 ex)
{
throw ex;
}
finally
{
provider.disconnect();
}
}
public static int CapNhatServiceBank(SERVICE_BANK_DTO bank)
{
try
{
return ServiceBankDAO.CapNhatServiceBank(bank);
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
SERVICE_BANK_DTO bank = new SERVICE_BANK_DTO();
#region Lấy thông tin service bank
//lấy thông tin từ giao diện
bank.MaBank = txtMaBank.Text;
bank.TenBank = txtTenBank.Text;
bank.Website = txtwebsite.Text;
bank.UserName = txtUsername.Text;
bank.PassWord = txtpass.Text;
bank.Website = txtwebsite.Text;
bank.LinkWebService = txtAreaWebservice.Value;
//lấy trạng thái
bank.TinhTrangWS = int.Parse(radiobtnTinhTrang.SelectedValue.ToString());
bank.Stk = txtSTK.Text;
#endregion
try
{
//gọi hàm cập nhật webservice bank
int result = ServiceBankBUS.CapNhatServiceBank(bank);
if (result == 1)
{
//cập nhật thành công thì quay về trang danh sách Service bank
//Response.Redirect("XemDanhSachWebserviceBank.aspx");
string strScript = "<script>";
strScript += "alert('Bạn đã cập nhật thành công!');";
strScript += "window.location='XemDanhSachWebserviceBank.aspx';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
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";
throw ex;
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
SERVICE_BANK_DTO bank = new SERVICE_BANK_DTO();
#region Lấy thông tin Web Service Bank
bank.MaBank=txtMaBank.Text;
bank.TenBank=txtTenBank.Text;
bank.UserName=txtUsername.Text;
bank.PassWord=txtPassWord.Text;
bank.LinkWebService=txtLinksv.Text;
bank.AnhBank = fileuploadLinkHinhAnh.FileName;
if (dropTinhtrang.Text.CompareTo("Đang sử dụng") == 0)
{
bank.TinhTrangWS = 1;
}
else
{
bank.TinhTrangWS = 0;
}
bank.Website=txtWebsiteBank.Text;
bank.Stk = txtSTK.Text;
#endregion
try
{
ServiceBankBUS.InsertServiceBank(bank);
fileuploadLinkHinhAnh.SaveAs(Server.MapPath("../../Content/images/banks/" + bank.AnhBank));
lbResultInfo.Text="Thêm thành công!";
}
catch (Exception ex)
{
throw ex;
}
}
public static List<SERVICE_BANK_DTO> LayDanhSachServiceBankTheoTrangThai(int trangthai)
{
provider.connect();
List<SERVICE_BANK_DTO> ds = new List<SERVICE_BANK_DTO>();
string sqlCommand = "sp_LayDanhSachSERVICEBANKTheoTrangThai";
List<SqlParameter> list = new List<SqlParameter>();
list.Add(new SqlParameter("@trangthai", trangthai));
try
{
DataTable table = provider.executeQueryDataTableProcedure(sqlCommand, list);
foreach (DataRow dr in table.Rows)
{
SERVICE_BANK_DTO bank = new SERVICE_BANK_DTO();
bank.MaBank = dr["MABANK"].ToString();
bank.TenBank = dr["TENBANK"].ToString();
bank.UserName = dr["USERNAMEB"].ToString();
bank.PassWord = dr["PASSWORDB"].ToString();
bank.LinkWebService = dr["LINKWS"].ToString();
bank.AnhBank = "../../Content/images/banks/" + dr["ANHBANK"].ToString();
bank.TinhTrangWS = int.Parse(dr["TINHTRANGWS"].ToString());
bank.Website = dr["WEBSITE"].ToString();
bank.Stk = dr["STK"].ToString();
ds.Add(bank);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
provider.disconnect();
}
return ds;
}
public static int CapNhatServiceBank(SERVICE_BANK_DTO bank)
{
provider.connect();
string sqlCommand = "sp_UpdateSERVICEBANK";
List<SqlParameter> list = new List<SqlParameter>();
list.Add(new SqlParameter("@mabank", bank.MaBank));
list.Add(new SqlParameter("@tenbank", bank.TenBank));
list.Add(new SqlParameter("@pass", bank.PassWord));
list.Add(new SqlParameter("@linkws", bank.LinkWebService));
list.Add(new SqlParameter("@tinhtrangws", bank.TinhTrangWS));
list.Add(new SqlParameter("@website", bank.Website));
list.Add(new SqlParameter("@stk", bank.Stk));
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 ex)
{
throw ex;
}
finally
{
provider.disconnect();
}
}
