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; } }
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); }