public bool DonViUpdate(DonViDTO dv)
{
string sql = "sp_DonViBH_Update";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = dv.Id_DonVi;
ds.Add(id);
SqlParameter mahoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
mahoa.Value = dv.MaHoa;
ds.Add(mahoa);
SqlParameter tendv = new SqlParameter("@tendv", SqlDbType.NVarChar);
tendv.Value = dv.TenDonVi;
ds.Add(tendv);
SqlParameter diachi = new SqlParameter("@diachi", SqlDbType.NVarChar);
diachi.Value = dv.DiaChi;
ds.Add(diachi);
SqlParameter mst = new SqlParameter("@mst", SqlDbType.VarChar);
mst.Value = dv.MaSoThue;
ds.Add(mst);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
protected void grDS_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = grDS.Rows[e.RowIndex];
TextBox txtmahoa = row.Cells[1].Controls[0] as TextBox;
TextBox txttendonvi = row.Cells[2].Controls[0] as TextBox;
TextBox txtdiachi = row.Cells[3].Controls[0] as TextBox;
TextBox txtmst = row.Cells[4].Controls[0] as TextBox;
int id=Int32.Parse(grDS.DataKeys[e.RowIndex].Value.ToString());
DonViDTO dv = new DonViDTO();
dv.Id_DonVi = id;
dv.TenDonVi = txttendonvi.Text;
dv.DiaChi = txtdiachi.Text;
dv.MaHoa = txtmahoa.Text;
dv.MaSoThue = txtmst.Text;
DonViBHDAO dvdao = new DonViBHDAO();
bool up=dvdao.DonViUpdate(dv);
if (up == true)
{
e.Cancel = true;
grDS.EditIndex = -1;
int ma = int.Parse(drNBH.SelectedItem.Value.ToString());
loadDS(ma);
}
else
Response.Write("");
}
public bool CapNhat(DonViDTO dv)
{
string sql = "sp_DonViBaoHiem_CapNhat";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter mahoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
mahoa.Value = dv.MaHoa;
ds.Add(mahoa);
SqlParameter tendv = new SqlParameter("@tendonvi", SqlDbType.NVarChar);
tendv.Value = dv.TenDonVi;
ds.Add(tendv);
SqlParameter diachi = new SqlParameter("@diachi", SqlDbType.NVarChar);
diachi.Value = dv.DiaChi;
ds.Add(diachi);
SqlParameter dienthoai = new SqlParameter("@dienthoai", SqlDbType.VarChar);
dienthoai.Value = dv.DienThoai;
ds.Add(dienthoai);
SqlParameter fax = new SqlParameter("@fax", SqlDbType.VarChar);
fax.Value = dv.Fax;
ds.Add(fax);
SqlParameter web = new SqlParameter("@website", SqlDbType.VarChar);
web.Value = dv.WebSite;
ds.Add(web);
SqlParameter mst = new SqlParameter("@masothue", SqlDbType.VarChar);
mst.Value = dv.MaSoThue;
ds.Add(mst);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public bool CapNhat(DonViDTO dv)
{
string sql = "sp_DonViBaoHiem_CapNhat";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter mahoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
mahoa.Value = dv.MaHoa;
ds.Add(mahoa);
SqlParameter tendv = new SqlParameter("@tendonvi",SqlDbType.NVarChar);
tendv.Value = dv.TenDonVi;
ds.Add(tendv);
SqlParameter diachi = new SqlParameter("@diachi",SqlDbType.NVarChar);
diachi.Value = dv.DiaChi;
ds.Add(diachi);
SqlParameter dienthoai = new SqlParameter("@dienthoai", SqlDbType.VarChar);
dienthoai.Value = dv.DienThoai;
ds.Add(dienthoai);
SqlParameter fax = new SqlParameter("@fax", SqlDbType.VarChar);
fax.Value = dv.Fax;
ds.Add(fax);
SqlParameter web = new SqlParameter("@website", SqlDbType.VarChar);
web.Value = dv.WebSite;
ds.Add(web);
SqlParameter mst = new SqlParameter("@masothue",SqlDbType.VarChar);
mst.Value = dv.MaSoThue;
ds.Add(mst);
return SqlDataAcessHelper.exNonStoreParas(sql,ds);
}
//thêm
private void button1_Click(object sender, EventArgs e)
{
DonViDTO DonVi = new DonViDTO();
DonVi.TenDonVi = txtTenDonVi.Text;
DbAck ack = DonViBUS.Insert(DonVi);
if (ack == DbAck.Ok)
{
MessageBox.Show("Thêm Thành Công", "Thông báo");
}
else
{
if (ack == DbAck.Unknown)
{
MessageBox.Show("Lỗi không xác định", "Thông báo");
}
else
{
}
}
loadListDonVi();
txtTenDonVi.Text = null;
}
public void Update(DonViDTO donViDTO)
{
DonVi donVi = _mapper.Map <DonVi>(donViDTO);
_unitOfWork.DonViRepository.Update(donVi);
_unitOfWork.CommitAsync();
}
public async Task <DonViDTO> Add(DonViDTO donViDTO)
{
DonVi donVi = _unitOfWork.DonViRepository.Add(_mapper.Map <DonVi>(donViDTO));
await _unitOfWork.CommitAsync();
return(_mapper.Map <DonViDTO>(donVi));
}
public string QueryUpdateDV(DonViDTO DV)
{
string query = "update DonVi set MaDonVi = '" + DV.MaDV + "',tenDonVi = '" + DV.TenDV + "',diaChi = '"
+ DV.DiaChiDV + "',SDT = '" + DV.SDTDV + "',namThanhLap = '" + DV.NamThanhLapDV + "' ";
return(query);
}
protected void grDS_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = grDS.Rows[e.RowIndex];
TextBox txtmahoa = row.Cells[1].Controls[0] as TextBox;
TextBox txttendonvi = row.Cells[2].Controls[0] as TextBox;
TextBox txtdiachi = row.Cells[3].Controls[0] as TextBox;
TextBox txtmst = row.Cells[4].Controls[0] as TextBox;
int id = Int32.Parse(grDS.DataKeys[e.RowIndex].Value.ToString());
DonViDTO dv = new DonViDTO();
dv.Id_DonVi = id;
dv.TenDonVi = txttendonvi.Text;
dv.DiaChi = txtdiachi.Text;
dv.MaHoa = txtmahoa.Text;
dv.MaSoThue = txtmst.Text;
DonViBHDAO dvdao = new DonViBHDAO();
bool up = dvdao.DonViUpdate(dv);
if (up == true)
{
e.Cancel = true;
grDS.EditIndex = -1;
int ma = int.Parse(drNBH.SelectedItem.Value.ToString());
loadDS(ma);
}
else
{
Response.Write("");
}
}
public DonViDTO LayDonVi(string mahoa)
{
string sql = "sp_DonViBH_LayDV";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter maHoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
maHoa.Value = mahoa;
ds.Add(maHoa);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
DonViDTO dv = new DonViDTO();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
dv.Id_DonVi = int.Parse(dr[0].ToString());
dv.TenDonVi = dr[1].ToString();
dv.Id_NhaBH = int.Parse(dr[2].ToString());
dv.DiaChi = dr[3].ToString();
dv.DienThoai = dr[4].ToString();
dv.Fax = dr[5].ToString();
dv.WebSite = dr[6].ToString();
dv.MaHoa = dr[7].ToString();
dv.MaSoThue = dr[8].ToString();
dv.SoVuThietHai = int.Parse(dr[9].ToString());
}
return(dv);
}
public string QueryInsertDV(DonViDTO DV)
{
string Query = "insert into DonVi VALUES('" + DV.MaDV + "', '" + DV.TenDV + "', '" + DV.DiaChiDV + "', '"
+ DV.SDTDV + "', '" + DV.NamThanhLapDV + "'";
return(Query);
}
protected void btnThem_Click(object sender, EventArgs e)
{
DonViDTO dvdto = new DonViDTO();
DonViBHDAO dvdao = new DonViBHDAO();
try
{
bool kq = dvdao.KiemTraMaHoa(txtMaHoa.Text);
if (kq == true)
txtThongBaoLoiMaHoa.Text = "Đã tồn tại mã hóa cho đơn vị khác !";
else
{
dvdto.MaHoa = txtMaHoa.Text.Trim();
dvdto.TenDonVi = txtTendonvi.Text.Trim();
dvdto.Id_NhaBH = int.Parse(drCTYTong.SelectedItem.Value.ToString());
dvdto.DiaChi = txtDiaChi.Text.Trim();
dvdto.DienThoai = txtDienThoai.Text.Trim();
dvdto.Fax = txtFax.Text.Trim();
dvdto.WebSite = txtWebsite.Text.Trim();
dvdto.MaSoThue = txtMaSoThue.Text;
//dvdto.MaNguoiDaiDien = int.Parse(drNguoiDaiDien.SelectedItem.Value.ToString());
dvdao.DonViMoi(dvdto);
txtThongBaoLoiMaHoa.Text = "";
//txtThemThanhCong.Text = "Succed!";
//Response.Redirect("~/pages/Claim.aspx");
Response.Write("<script>alert('Succeed!');</script>");
loadDVNBH();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public static DbAck Delete(DonViDTO DonVi)
{
DbAck result = DbAck.Unknown;
result = DonViDAO.Delete(DonVi);
return(result);
}
public static DbAck Insert(DonViDTO DonVi)
{
DbAck result = DbAck.Unknown;
result = DonViDAO.Insert(DonVi);
return(result);
}
public bool UpdateDV(DonViDTO DV)
{
bool table = false;
if (ConnectionSQL.ExecuteNonQuery(DV_DAO.QueryUpdateDV(DV)) > 0)
{
table = true;
}
return(table);
}
private void bunifuButton1_Click(object sender, EventArgs e)
{
if (tag == "Thêm")
{
if (!checkData())
{
return;
}
bool kq = bus.them(new DTO.DonViDTO(tb_name.Text, tb_note.Text));
if (kq)
{
MessageBox.Show("Thêm thành công");
this.Close();
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
else
{
if (chiTiet)
{
btnAdd.ButtonText = "Lưu";
enableAll();
chiTiet = false;
}
else
{
if (!checkData())
{
return;
}
DonViDTO dv = new DonViDTO()
{
MaDV1 = MaDV,
TenDV1 = tb_name.Text,
GhiChu1 = tb_note.Text
};
bool kq = bus.sua(dv);
if (kq == true)
{
MessageBox.Show("Sửa thành công");
disableAll();
btnAdd.ButtonText = "Sửa";
chiTiet = true;
}
else
{
MessageBox.Show("Sửa không thành công");
return;
}
}
}
}
public static DbAck Delete(DonViDTO DonVi)
{
string sql = "delete from DonVi where ten_don_vi = @Ten";
Dictionary <string, object> parameter = new Dictionary <string, object>();
parameter.Add("@Ten", DonVi.TenDonVi);
DbAck result = DataProvider.ExecNonQuery(sql, parameter);
return(DbAck.Unknown);
}
public static DbAck Insert(DonViDTO DonVi)
{
string sql = "insert into DonVi(ten_don_vi) values(@Ten)";
Dictionary <string, object> parameter = new Dictionary <string, object>();
parameter.Add("@Ten", DonVi.TenDonVi);
DbAck result = DataProvider.ExecNonQuery(sql, parameter);
return(result);
}
public async void GetByID_Test(string ms_dv, string expected)
{
DonVi donVi = new DonVi()
{
MS_DV = "1102000000", TenDonVi = "PHÒNG CÔNG NGHỆ THÔNG TIN"
};
_mockUnitOfWork.Setup(u => u.DonViRepository.GetById(It.IsAny <string>())).Returns(Task.FromResult(donVi));
DonViDTO actual = await _donViService.GetByID(ms_dv);
Assert.Equal(expected, actual.MS_DV);
}
public async Task <ActionResult> Update(string ms_dv)
{
if (ms_dv == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DonViDTO donViDTO = await _donViService.GetByID(ms_dv);
if (donViDTO == null)
{
return(HttpNotFound());
}
return(View(donViDTO));
}
public async Task <ActionResult> Delete(string ms_dv)
{
if (ms_dv == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DonViDTO donViDTO = await _donViService.Delete(ms_dv);
if (donViDTO == null)
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
dvdto = (DonViDTO)Session["DonViBH"];
txtTendonvi.Text = dvdto.TenDonVi;
txtDiaChi.Text = dvdto.DiaChi;
txtDienThoai.Text = dvdto.DienThoai;
txtFax.Text = dvdto.Fax;
txtWebsite.Text = dvdto.WebSite;
txtMaHoa.Text = dvdto.MaHoa;
txtMaSoThue.Text = dvdto.MaSoThue.ToString();
string NBH = bhdao.LayTen(dvdto.Id_NhaBH);
txtNhaBH.Text = NBH;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
dvdto = (DonViDTO)Session["DonViBH"];
txtTendonvi.Text = dvdto.TenDonVi;
txtDiaChi.Text = dvdto.DiaChi;
txtDienThoai.Text = dvdto.DienThoai;
txtFax.Text = dvdto.Fax;
txtWebsite.Text = dvdto.WebSite;
txtMaHoa.Text = dvdto.MaHoa;
txtMaSoThue.Text = dvdto.MaSoThue.ToString();
string NBH = bhdao.LayTen(dvdto.Id_NhaBH);
txtNhaBH.Text = NBH;
}
}
public bool DonViMoi(DonViDTO dv)
{
string sql = "sp_DonViBHMoi";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter name = new SqlParameter("@tendv", SqlDbType.NVarChar);
name.Value = dv.TenDonVi;
ds.Add(name);
SqlParameter maNhaBH = new SqlParameter("@manhabh", SqlDbType.Int);
maNhaBH.Value = dv.Id_NhaBH;
ds.Add(maNhaBH);
SqlParameter diaChi = new SqlParameter("@diachi", SqlDbType.NVarChar);
diaChi.Value = dv.DiaChi;
ds.Add(diaChi);
SqlParameter dienThoai = new SqlParameter("@dienthoai", SqlDbType.VarChar);
dienThoai.Value = dv.DienThoai;
ds.Add(dienThoai);
SqlParameter fax = new SqlParameter("@fax", SqlDbType.VarChar);
fax.Value = dv.Fax;
ds.Add(fax);
SqlParameter web = new SqlParameter("@website", SqlDbType.VarChar);
web.Value = dv.WebSite;
ds.Add(web);
SqlParameter mahoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
mahoa.Value = dv.MaHoa;
ds.Add(mahoa);
SqlParameter masothue = new SqlParameter("@mst", SqlDbType.VarChar);
masothue.Value = dv.MaSoThue;
ds.Add(masothue);
return(SqlDataAcessHelper.exNonStoreParas(sql, ds));
}
public bool DonViMoi(DonViDTO dv)
{
string sql = "sp_DonViBHMoi";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter name = new SqlParameter("@tendv", SqlDbType.NVarChar);
name.Value = dv.TenDonVi;
ds.Add(name);
SqlParameter maNhaBH = new SqlParameter("@manhabh", SqlDbType.Int);
maNhaBH.Value = dv.Id_NhaBH;
ds.Add(maNhaBH);
SqlParameter diaChi = new SqlParameter("@diachi", SqlDbType.NVarChar);
diaChi.Value = dv.DiaChi;
ds.Add(diaChi);
SqlParameter dienThoai = new SqlParameter("@dienthoai",SqlDbType.VarChar);
dienThoai.Value = dv.DienThoai;
ds.Add(dienThoai);
SqlParameter fax = new SqlParameter("@fax", SqlDbType.VarChar);
fax.Value = dv.Fax;
ds.Add(fax);
SqlParameter web = new SqlParameter("@website", SqlDbType.VarChar);
web.Value = dv.WebSite;
ds.Add(web);
SqlParameter mahoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
mahoa.Value = dv.MaHoa;
ds.Add(mahoa);
SqlParameter masothue = new SqlParameter("@mst", SqlDbType.VarChar);
masothue.Value = dv.MaSoThue;
ds.Add(masothue);
return SqlDataAcessHelper.exNonStoreParas(sql, ds);
}
protected void btnThem_Click(object sender, EventArgs e)
{
DonViDTO dvdto = new DonViDTO();
DonViBHDAO dvdao = new DonViBHDAO();
try
{
bool kq = dvdao.KiemTraMaHoa(txtMaHoa.Text);
if (kq == true)
{
txtThongBaoLoiMaHoa.Text = "Đã tồn tại mã hóa cho đơn vị khác !";
}
else
{
dvdto.MaHoa = txtMaHoa.Text.Trim();
dvdto.TenDonVi = txtTendonvi.Text.Trim();
dvdto.Id_NhaBH = int.Parse(drCTYTong.SelectedItem.Value.ToString());
dvdto.DiaChi = txtDiaChi.Text.Trim();
dvdto.DienThoai = txtDienThoai.Text.Trim();
dvdto.Fax = txtFax.Text.Trim();
dvdto.WebSite = txtWebsite.Text.Trim();
dvdto.MaSoThue = txtMaSoThue.Text;
//dvdto.MaNguoiDaiDien = int.Parse(drNguoiDaiDien.SelectedItem.Value.ToString());
dvdao.DonViMoi(dvdto);
txtThongBaoLoiMaHoa.Text = "";
//txtThemThanhCong.Text = "Succed!";
//Response.Redirect("~/pages/Claim.aspx");
Response.Write("<script>alert('Succeed!');</script>");
loadDVNBH();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
public static List <DonViDTO> SelectAllDonVi()
{
List <DonViDTO> listDonVi = null;
string sql = "Select * from DonVi";
DataTable dt = DataProvider.ExecQuery(sql);
if (dt != null && dt.Rows.Count > 0)
{
listDonVi = new List <DonViDTO>();
foreach (DataRow row in dt.Rows)
{
DonViDTO donvi = new DonViDTO();
donvi.TenDonVi = row.ItemArray[0].ToString();
listDonVi.Add(donvi);
}
}
return(listDonVi);
}
public bool sua(DonViDTO lb)
{
bool re = bdal.sua(lb);
return(re);
}
public async Task <ActionResult> DeleteConfirmed(string ms_dv)
{
DonViDTO donViDTO = await _donViService.Delete(ms_dv);
return(RedirectToAction("Index"));
}
public DonViDTO LayDonVi(string mahoa)
{
string sql = "sp_DonViBH_LayDV";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter maHoa = new SqlParameter("@mahoa",SqlDbType.VarChar);
maHoa.Value = mahoa;
ds.Add(maHoa);
DataTable dt = new DataTable();
dt = SqlDataAcessHelper.exStoreParas(sql, ds);
DonViDTO dv = new DonViDTO();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
dv.Id_DonVi = int.Parse(dr[0].ToString());
dv.TenDonVi = dr[1].ToString();
dv.Id_NhaBH = int.Parse(dr[2].ToString());
dv.DiaChi = dr[3].ToString();
dv.DienThoai = dr[4].ToString();
dv.Fax = dr[5].ToString();
dv.WebSite = dr[6].ToString();
dv.MaHoa = dr[7].ToString();
dv.MaSoThue = dr[8].ToString();
dv.SoVuThietHai = int.Parse(dr[9].ToString());
}
return dv;
}
public ActionResult Update(DonViDTO donViDTO)
{
_donViService.Update(donViDTO);
return(RedirectToAction("Index"));
}
public bool DonViUpdate(DonViDTO dv)
{
string sql = "sp_DonViBH_Update";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = dv.Id_DonVi;
ds.Add(id);
SqlParameter mahoa = new SqlParameter("@mahoa", SqlDbType.VarChar);
mahoa.Value = dv.MaHoa;
ds.Add(mahoa);
SqlParameter tendv = new SqlParameter("@tendv", SqlDbType.NVarChar);
tendv.Value = dv.TenDonVi;
ds.Add(tendv);
SqlParameter diachi = new SqlParameter("@diachi", SqlDbType.NVarChar);
diachi.Value = dv.DiaChi;
ds.Add(diachi);
SqlParameter mst = new SqlParameter("@mst", SqlDbType.VarChar);
mst.Value = dv.MaSoThue;
ds.Add(mst);
return SqlDataAcessHelper.exNonStoreParas(sql, ds);
}
public async Task <ActionResult> Insert(DonViDTO donViDTO)
{
DonViDTO result = await _donViService.Add(donViDTO);
return(RedirectToAction("Index"));
}
public string QueryDeleteDV(DonViDTO DV)
{
string Query = "delete DonVi where MaDonVi =" + DV.MaDV + "";
return(Query);
}
public bool them(DonViDTO lb)
{
bool re = bdal.them(lb);
return(re);
}
public bool xoa(DonViDTO lb)
{
bool re = bdal.xoa(lb);
return(re);
}
