public bool KhachHangMoi(KhachHangDTO kh) { string sql= "sp_KhachHangMoi"; List<SqlParameter> ds = new List<SqlParameter>(); SqlParameter ma = new SqlParameter("@ma", SqlDbType.Int); ma.Value = kh.MaKhachHang; ds.Add(ma); SqlParameter ten = new SqlParameter("@tenKH",SqlDbType.NVarChar); ten.Value = kh.TenKhachHang; ds.Add(ten); SqlParameter tenNguoiDaiDien = new SqlParameter("@tenNguoiDaiDien", SqlDbType.NVarChar); tenNguoiDaiDien.Value = kh.TenNguoiDaiDien; ds.Add(tenNguoiDaiDien); SqlParameter email = new SqlParameter("@email",SqlDbType.VarChar); email.Value = kh.Email; ds.Add(email); SqlParameter dienthoai = new SqlParameter("@dienthoai",SqlDbType.VarChar); dienthoai.Value = kh.DienThoai; ds.Add(dienthoai); SqlParameter fax = new SqlParameter("@fax", SqlDbType.VarChar); fax.Value = kh.Fax; ds.Add(fax); SqlParameter diachi = new SqlParameter("@diachi",SqlDbType.NVarChar); diachi.Value = kh.DiaChi; ds.Add(diachi); SqlParameter madvbh = new SqlParameter("@madvbh", SqlDbType.Int); madvbh.Value = kh.MaDonViBH; ds.Add(madvbh); return SqlDataAcessHelper.exNonStoreParas(sql,ds); }
public bool UpdateInfoPRIRFR(ClaimDTO cl, KhachHangDTO kh) { bool kq = false; string sql = "sp_Claim_InforPRIRFR_Update"; List<SqlParameter> ds = new List<SqlParameter>(); SqlParameter ma = new SqlParameter("@maclaim", SqlDbType.VarChar); ma.Value = cl.MaClaim; ds.Add(ma); SqlParameter date = new SqlParameter("@dateILA", SqlDbType.NVarChar); date.Value = cl.ILADATE; ds.Add(date); SqlParameter pono = new SqlParameter("@policyno", SqlDbType.NVarChar); pono.Value = cl.PolicyNo; ds.Add(pono); SqlParameter dol = new SqlParameter("@dol", SqlDbType.NVarChar); dol.Value = cl.Dol; ds.Add(dol); SqlParameter sc = new SqlParameter("@sortcause", SqlDbType.NVarChar); sc.Value = cl.SortCause; ds.Add(sc); SqlParameter pv = new SqlParameter("@phamvitt", SqlDbType.NVarChar); pv.Value = cl.PhamViTonThat; ds.Add(pv); SqlParameter napo = new SqlParameter("@namepolicy", SqlDbType.NVarChar); napo.Value = cl.NamePolicy; ds.Add(napo); SqlParameter sum = new SqlParameter("@suminsured", SqlDbType.NVarChar); sum.Value = cl.SumInsured; ds.Add(sum); SqlParameter eff = new SqlParameter("@effective", SqlDbType.NVarChar); eff.Value = cl.Effective; ds.Add(eff); SqlParameter deduc = new SqlParameter("@deductible", SqlDbType.NVarChar); deduc.Value = cl.MucMienThuong; ds.Add(deduc); SqlParameter dkbs = new SqlParameter("@dkbs", SqlDbType.NVarChar); dkbs.Value = cl.DKBS; ds.Add(dkbs); SqlParameter kn = new SqlParameter("@khieunai", SqlDbType.NVarChar); kn.Value = cl.KhieuNai; ds.Add(kn); SqlParameter duphong = new SqlParameter("@duphongboithuong", SqlDbType.NVarChar); duphong.Value = cl.DuPhongBoiThuong; ds.Add(duphong); SqlParameter makh = new SqlParameter("@makhachhang", SqlDbType.Int); makh.Value = kh.MaKhachHang; ds.Add(makh); SqlParameter trade = new SqlParameter("@trade", SqlDbType.NVarChar); trade.Value = kh.LinhVucKinhDoanh; ds.Add(trade); kq = SqlDataAcessHelper.exNonStoreParas(sql, ds); return kq; }
public bool UpdateInfo(ClaimDTO cl, KhachHangDTO kh) { bool kq = false; string sql = "sp_Claim_KhachHang_UpdateInfo"; List<SqlParameter> ds = new List<SqlParameter>(); SqlParameter ma = new SqlParameter("@idclaim", SqlDbType.VarChar); ma.Value = cl.MaClaim; ds.Add(ma); SqlParameter tenclaim = new SqlParameter("@tenclaim", SqlDbType.VarChar); tenclaim.Value = cl.TenClaim; ds.Add(tenclaim); SqlParameter pres = new SqlParameter("@presmises", SqlDbType.NVarChar); pres.Value = cl.Premises; ds.Add(pres); SqlParameter pono = new SqlParameter("@policyno", SqlDbType.NVarChar); pono.Value = cl.PolicyNo; ds.Add(pono); SqlParameter eff = new SqlParameter("@effective", SqlDbType.NVarChar); eff.Value = cl.Effective; ds.Add(eff); SqlParameter typo = new SqlParameter("@typepolicy", SqlDbType.VarChar); typo.Value = cl.TypePolicy; ds.Add(typo); SqlParameter dol = new SqlParameter("@dateofloss", SqlDbType.VarChar); dol.Value = cl.Dol; ds.Add(dol); SqlParameter tenndbh = new SqlParameter("@ndbh",SqlDbType.NVarChar); tenndbh.Value= kh.TenKhachHang; ds.Add(tenndbh); SqlParameter nguoilienhe = new SqlParameter("@contactpersonkh", SqlDbType.NVarChar); nguoilienhe.Value = kh.TenNguoiDaiDien; ds.Add(nguoilienhe); SqlParameter fax = new SqlParameter("@faxkh", SqlDbType.VarChar); fax.Value = kh.Fax; ds.Add(fax); SqlParameter dienthoai = new SqlParameter("@dienthoaikh", SqlDbType.VarChar); dienthoai.Value = kh.DienThoai; ds.Add(dienthoai); SqlParameter email = new SqlParameter("@emailkh", SqlDbType.VarChar); email.Value = kh.Email; ; ds.Add(email); SqlParameter diachi = new SqlParameter("@diachikh", SqlDbType.NVarChar); diachi.Value = kh.DiaChi; ds.Add(diachi); kq = SqlDataAcessHelper.exNonStoreParas(sql, ds); return kq; }
void KhachHangMoiTuKhaoSatRuiRo() { try { KhachHangDTO khdto = new KhachHangDTO(); KhachHangDAO khdao = new KhachHangDAO(); if (txtNguoiDuocBH.Text != null) khdto.TenKhachHang = txtNguoiDuocBH.Text; else khdto.TenKhachHang = ""; if (txtNguoiLienHe.Text != null) khdto.TenNguoiDaiDien = txtNguoiLienHe.Text; else khdto.TenNguoiDaiDien = ""; if (txtSoFax.Text != null) khdto.Fax = txtSoFax.Text; else khdto.Fax = ""; if (txtDienThoai.Text != null) khdto.DienThoai = txtDienThoai.Text; else khdto.DienThoai = ""; if (txtDiaChi.Text != null) khdto.DiaChi = txtDiaChi.Text; else khdto.DiaChi = ""; if (txtEmail.Text != null) khdto.Email = txtEmail.Text; else khdto.Email = ""; khdto.ChucVu = "__"; khdto.MaLoaiKhachHang = 1; khdto.MaLVKD = 7; khdao.KhachHangMoi(khdto); } catch (Exception ex) { lblThongBaoCapNhatYKienGDV.Text = ex.Message; } }
protected void LoadKhachHang(string maclaim) { KhachHangDTO kh = new KhachHangDTO(); kh = khdao.LayInfo(maclaim); txtInsured.Text = kh.TenKhachHang.ToString(); lblinsured.Text = kh.TenKhachHang.ToString(); txtContactPerson.Text = kh.TenNguoiDaiDien.ToString(); txtAddress.Text = kh.DiaChi.ToString(); txtPhone.Text = kh.DienThoai.ToString(); txtFaxno.Text = kh.Fax.ToString(); txtEmail.Text = kh.Email.ToString(); }
protected void btnCapNhatInfoBasic_Click(object sender, EventArgs e) { KhachHangDTO khm1 = new KhachHangDTO(); ClaimDTO clm1 = new ClaimDTO(); string maclaim = cldao.LayMaTheoTen(lblThamChieuHead.Text); if (maclaim != null) { clm1.MaClaim = maclaim; clm1.TenClaim = txtReferencenumber.Text; clm1.Premises = txtPremises.Text; clm1.PolicyNo = txtPolicyNo.Text; clm1.Effective = txtEffective.Text; clm1.TypePolicy = txtTypeOfloss.Text; khm1.TenKhachHang = txtInsured.Text; khm1.TenNguoiDaiDien = txtContactPerson.Text; khm1.Fax = txtFaxno.Text; khm1.DienThoai = txtPhone.Text; khm1.Email = txtEmail.Text; khm1.DiaChi = txtAddress.Text; clm1.Dol = txtDateofloss.Text; bool up = cldao.UpdateInfo(clm1, khm1); if (up == true) { string m=sm.CapNhatInfoBasic(clm1, khm1); Response.Write("<script>alert('Updated!');</script>"); } } }
public bool UpdateKHBasic(KhachHangDTO kh) { string sql = "sp_KhachHang_UpdateKH"; List<SqlParameter> ds = new List<SqlParameter>(); SqlParameter makh = new SqlParameter("@maKH", SqlDbType.Int); makh.Value = kh.MaKhachHang; ds.Add(makh); SqlParameter insured = new SqlParameter("@tenndbh", SqlDbType.NVarChar); insured.Value = kh.TenKhachHang; ds.Add(insured); SqlParameter adress = new SqlParameter("@diachi", SqlDbType.NVarChar); adress.Value = kh.DiaChi; ds.Add(adress); SqlParameter daidien = new SqlParameter("@tendaidien", SqlDbType.NVarChar); daidien.Value = kh.TenNguoiDaiDien; ds.Add(daidien); SqlParameter phone = new SqlParameter("@dienthoai", SqlDbType.VarChar); phone.Value = kh.DienThoai; ds.Add(phone); SqlParameter fax = new SqlParameter("@fax", SqlDbType.VarChar); fax.Value = kh.Fax; ds.Add(fax); SqlParameter trade = new SqlParameter("@trade", SqlDbType.NVarChar); trade.Value = kh.LinhVucKinhDoanh; ds.Add(trade); SqlParameter email = new SqlParameter("@email", SqlDbType.NVarChar); email.Value = kh.Email; ds.Add(email); return SqlDataAcessHelper.exNonStoreParas(sql, ds); }
public KhachHangDTO LayInfo(string maclaim) { KhachHangDTO kh = new KhachHangDTO(); string sql = "sp_KhachHang_select"; List<SqlParameter> ds = new List<SqlParameter>(); SqlParameter macl = new SqlParameter("@maclaim", SqlDbType.VarChar); macl.Value = maclaim; ds.Add(macl); DataTable dt = new DataTable(); dt = SqlDataAcessHelper.exStoreParas(sql, ds); if (dt.Rows.Count > 0) { DataRow dr= dt.Rows[0]; kh.TenKhachHang = dr[0].ToString(); kh.TenNguoiDaiDien = dr[1].ToString(); kh.DiaChi = dr[2].ToString(); kh.DienThoai = dr[3].ToString(); kh.Fax = dr[5].ToString(); kh.Email = dr[4].ToString(); } return kh; }
protected void btnUpdate_Click(object sender, EventArgs e) { ClaimDTO cldto = new ClaimDTO(); KhachHangDTO khdto = new KhachHangDTO(); string id=Session["ThamChieu"].ToString(); if (id != "") { cldto.MaClaim = id; cldto.TenClaim = txtTenClaim.Text; string iladate = txtDateILA.Text.Trim(); if (iladate != "") cldto.ILADATE = iladate; else cldto.ILADATE = ""; string nameP = txtPolicyNo.Text.Trim(); if (nameP != "") cldto.PolicyNo = nameP; else cldto.PolicyNo = ""; string dol = txtDOL.Text.Trim(); if (dol != "") cldto.Dol = dol; else cldto.Dol = ""; string cause = txtCauseloss.Text.Trim(); if (cause != "") cldto.SortCause = cause; else cldto.SortCause = ""; string pvtt = txtExtendofloss.Text.Trim(); if (pvtt != "") cldto.PhamViTonThat = pvtt; else cldto.PhamViTonThat = ""; string nametypo = txtTypepolicy.Text.Trim(); if (nametypo != "") cldto.NamePolicy = nametypo; else cldto.NamePolicy = ""; string sumI = txtSuminsured.Text.Trim(); if (sumI != "") cldto.SumInsured = sumI; else cldto.SumInsured = ""; string gd = txtperiod.Text.Trim(); if (gd != "") cldto.Effective = gd; else cldto.Effective = ""; string mmt = txtDeductible.Text.Trim(); if (mmt != "") cldto.MucMienThuong = mmt; else cldto.MucMienThuong = ""; string dkbs = txtExtensionclaise.Text.Trim(); if (dkbs != "") cldto.DKBS = dkbs; else cldto.DKBS = ""; string kn = txtKhieuNai.Text.Trim(); if (kn != "") cldto.KhieuNai = kn; else cldto.KhieuNai = ""; string dpbt = txtInterimreserve.Text; if (dpbt!="") cldto.DuPhongBoiThuong = dpbt; else cldto.DuPhongBoiThuong = ""; int maKH = cl.ClaimMaKH(id); if (maKH != 0) khdto.MaKhachHang = maKH; khdto.LinhVucKinhDoanh = txtTrade.Text.Trim(); bool up = cl.UpdateInfoPRIRFR(cldto, khdto); int maGDV = int.Parse(Request.Cookies["MaGDV"].Value); if (up == true) { sm.CapNhatInfoBasicPR(cldto, khdto); sm.CapNhatInfoBasicFR(cldto); string noidung = gdv.LayTenTheoMa(maGDV) + " edited cover preliminary report of case " + id + " ."; SaveLogTracking(maGDV, noidung, id); Response.Write("<script>parent.closeDialog();</script>"); Response.Write("<script>parent.reloaData();</script>"); } else { string noidung = gdv.LayTenTheoMa(maGDV) + " faild to edit cover preliminary report of case " + id + " ."; SaveLogTracking(maGDV, noidung, id); Response.Write("<script> alert('Error Update!');</script>"); } } }