void ViewClaim(string idclaim)
{
DataTable dt = new DataTable();
ClaimDAO cl = new ClaimDAO();
dt = cl.ViewSiteSurveyRecord(idclaim);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lblNgayThucHien.Text = DateTime.Today.ToShortDateString();
lblThamChieu.Text = dr[1].ToString();
lblGDV.Text = dr[2].ToString();
lblInsurer.Text = dr[3].ToString();
lblSubsidiary.Text = dr[4].ToString();
lblSoHDBH.Text = dr[5].ToString();
lblEffective.Text = dr[6].ToString();
lblInsured.Text = dr[7].ToString();
lblFax.Text = dr[8].ToString();
lblAddress.Text = dr[9].ToString();
lblContectPerson.Text = dr[10].ToString();
lblPhone.Text = dr[11].ToString();
lblEmail.Text = dr[12].ToString();
lblPremises.Text = dr[13].ToString();
lblDateofloss.Text = dr[14].ToString();
lblTypeofloss.Text = dr[15].ToString();
lblCircumstances.Text = dr[16].ToString();
lblTBCQCN.Text = dr[17].ToString();
lblFurtherNotes.Text = dr[18].ToString();
lblExtentOfloss.Text = dr[19].ToString();
lblInitialReserve.Text = dr[20].ToString();
lblAppendixAttached.Text = dr[21].ToString();
lblKhuyenCao.Text = dr[22].ToString();
lblYKien.Text = dr[23].ToString();
lblNgayGioKetThuc.Text = dr[24].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string mathamchieu = Session["ThamChieu"].ToString();
DataTable dt = new DataTable();
ClaimDAO cl = new ClaimDAO();
dt = cl.TomTat(mathamchieu);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lblThamChieu.Text = dr[0].ToString();
lblGDV1.Text = dr[1].ToString();
lblDonVi.Text = dr[2].ToString();
lblNDBH.Text = dr[3].ToString();
lblDiaChi.Text = dr[4].ToString();
lblNguoiLienHe.Text = dr[5].ToString();
lblSoHDBH.Text = dr[6].ToString();
lblHieuLuc.Text = dr[7].ToString();
lblFax.Text = dr[8].ToString();
lblSoDienThoai.Text = dr[9].ToString();
lblEmail.Text = dr[10].ToString();
lblDiaDiemTT.Text = dr[11].ToString();
lblLoaiHinhTonThat.Text = dr[12].ToString();
lblNgayTonThat.Text = dr[13].ToString();
lblDienBienTonThat.Text = dr[14].ToString();
lblThongBaoCQChucNang.Text = dr[15].ToString();
lblNguyenNhanTT.Text = dr[16].ToString();
lblPhamViBH.Text = dr[17].ToString();
lblDienBienKhieuNai.Text = dr[18].ToString();
lblMoTaPhamViThietHai.Text = dr[19].ToString();
lblGiaTriDeXuat.Text = dr[20].ToString();
lblGiaTriThuHoi.Text = dr[21].ToString();
lblKetLuan.Text = dr[22].ToString();
}
}
public static void fixBugValueClaim(String idClaim)
{
//Add colums update
//String[]colums = { "DienBienTonThat", "PhamViTonThat", "DePhongVaKhuyenCao", "YKienGDV", "GioiThieu" };
String sql = "SELECT * FROM CLAIM WHERE ID_CLAIM = " + idClaim;
DataTable dt = SqlDataAcessHelper.exQuery(sql);
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
ClaimDAO claimDao = new ClaimDAO();
foreach (DataColumn c in dt.Columns)
{
String key = c.ColumnName;
if (key!= "ID_Claim" && row[key] != null)
{
String valueOld = row[key].ToString();
if (valueOld.StartsWith("<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n"))
{
String valueNew = valueOld.Replace("<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n", "").Replace("\r\n</body>\r\n</html>", "");
claimDao.updateClaimField(idClaim, key, valueNew);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = "";
if(Session["ThamChieu"]!= null)
id = Session["ThamChieu"].ToString();
HttpCookie ck = Request.Cookies["MaGDV"];
if (ck == null)
{
linklogin.Visible = true;
}
else
{
DataTable dt = new DataTable();
int idgdv = int.Parse(Request.Cookies["MaGDV"].Value);
dt = gdvdao.LayTenvaChucVu(idgdv);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
string name = dr[0].ToString();
lblName.Text = name;
string chucvu = dr[1].ToString();
lblChucVu.Text = chucvu;
}
linklogin.Visible = false;
ClaimDAO dao = new ClaimDAO();
claimName = dao.getClaimField(id, "TenClaim").ToString();
}
}
void ViewClaim(string idclaim)
{
ClaimDAO cl = new ClaimDAO();
DataTable dt = new DataTable();
dt = cl.ViewSiteSurveyRecord(idclaim);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lblNgayThucHien.Text = dr[0].ToString();
}
}
protected void btnHoanTat_Click(object sender, EventArgs e)
{
string mcl = null;
if (Session["ThamChieu"] != null)
{
mcl = Session["ThamChieu"].ToString();
mathamchieu = thamchieu;
}
else
{
mcl = Request.QueryString["IDClaim"];
}
//string mcl = Request.QueryString["IDClaim"];
Response.Redirect("~/Pages/SiteSurveyRecordView.aspx?IDClaim=" + mcl);
ClaimDAO cldao = new ClaimDAO();
// quay tro lại trang form
//string ma = cldao.LayMaTheoTen(thamchieu);
//Response.Redirect("~Pages/InformationForm.aspx?Reference=" + mcl);
}
void loadinfo(string id)
{
DataTable dt = new DataTable();
ClaimDAO cl = new ClaimDAO();
dt = cl.ClaimMaster(id);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lblThamChieuHead.Text = dr[0].ToString();
lblinsured.Text = dr[1].ToString();
txtbrief.Text = dr[2].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["claimID"] != null)
mClaimID = Request.QueryString["claimID"];
if (mClaimID.Trim() != "")
{
if (!IsPostBack)
{
//mClaimID = Session["ThamChieu"].ToString();
string done = dailyDao.KiemTraTinhTrang(mClaimID, "PR");
if (done != null && done.ToLower() == "yes")
{
isLock = true;
}
loadData();
ClaimDAO dao = new ClaimDAO();
claimName = dao.getClaimField(mClaimID, "TenClaim").ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!this.IsPostBack)
{
HttpCookie ck = Request.Cookies["MaGDV"];
if (ck == null)
Response.Redirect("~/Pages/Login.aspx");
else
{
load_DropDownlist();
ClaimDAO cldao = new ClaimDAO();
string ma = cldao.LayMa();
lblSTT.Text = ma;
int maNhaBH = int.Parse(drNBH.SelectedItem.Value.ToString());
load_DonViBaoHiem(maNhaBH);
load_SLGDV();
}
//ThemQLHutThuoc();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ThamChieu"] != null)
{
mClaimID = Session["ThamChieu"].ToString();
loadData();
ClaimDAO dao = new ClaimDAO();
claimName = dao.getClaimField(mClaimID, "TenClaim").ToString();
}
}
void LoadInfor(string maclaim)
{
ClaimDAO cl= new ClaimDAO();
DataTable dt = new DataTable();
dt = cl.GetBasicInfor(maclaim);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txtNBH.Text = dr[2].ToString();
txtDonVi.Text=dr[3].ToString();
txtTenKhachHang.Text=dr[4].ToString();
txtDiaChi.Text=dr[5].ToString();
txtNguoiDaiDien.Text=dr[6].ToString();
txtPhone.Text=dr[7].ToString();
txtFax.Text=dr[8].ToString();
txtEmail.Text=dr[9].ToString();
txtKinhDoanh.Text=dr[10].ToString();
txtPolicyNo.Text=dr[11].ToString();
txtPeriodfrom.Text=dr[12].ToString();
txtPremises.Text=dr[13].ToString();
txtDateofloss.Text=dr[14].ToString();
txttenloaihinhtt.Text=dr["LoaiHinhTonThat"].ToString();
maLHTT=int.Parse(dr["ID_LoaiHinhTonThat"].ToString());
}
}
protected void loadTheoThamChieu(string thamchieu)
{
ClaimDAO cdao = new ClaimDAO();
DataTable dt2 = new DataTable();
dt2 = tsdao.TimeSheetTheoThamChieu(thamchieu);
gvDSTimeSheet.DataSource = dt2;
gvDSTimeSheet.DataBind();
if (dt2.Rows.Count > 0)
{
gvDSTimeSheet.Visible = true;
//ddlFile.Visible = true;
//btnSave.Visible = true;
}
else
{
//ddlFile.Visible = false;
//btnSave.Visible = false;
}
}
protected void loadDSTimeSheet(int idgdv, string thamchieu)
{
ClaimDAO cdao = new ClaimDAO();
DataTable dt2 = new DataTable();
//dt = cdao.ClaimTheoTen(thamchieu);
//DataRow dr = dt.Rows[0];
//string maclaim = dr[0].ToString();
TimeSheetDAO tsdao = new TimeSheetDAO();
dt2 = tsdao.DSTimeSheet(idgdv, thamchieu);
gvDSTimeSheet.DataSource = dt2;
gvDSTimeSheet.DataBind();
if (dt2.Rows.Count > 0)
{
gvDSTimeSheet.Visible = true;
//ddlFile.Visible = true;
//btnSave.Visible = true;
}
else
{
//ddlFile.Visible = false;
//btnSave.Visible = false;
}
}
protected void btnTim_Click(object sender, EventArgs e)
{
int magdv = int.Parse(drGDV0.SelectedItem.Value.ToString());
//GiamDinhVienDAO gdvdao = new GiamDinhVienDAO();
//DataTable dtgdv = gdvdao.MaGiamDinhVienTheoTen(tengdv);
//int idgdv = 0;
//if (dtgdv.Rows.Count > 0)
//{
// DataRow dr = dtgdv.Rows[0];
// idgdv = int.Parse(dr[0].ToString());
//}
ClaimDAO cdao = new ClaimDAO();
string matc= txtMaThamChieuT.Text;
string thamchieu = cdao.TenClaim(matc);
//DataTable dtc = cdao.ClaimTheoTen(thamchieu);
if (matc!="" )
{
bool kt = cl.KiemTraThamChieu(matc);
if (kt == true)
{
loadDSTimeSheet(magdv, matc);
gvDSTimeSheet.Visible = true;
}
}
//if (matc == "")
//{
// LoadTSTheoThamchieu(matc);
//}
if (matc == "")
{
loadTheoGDV(magdv);
}
//if (dtgdv.Rows.Count == 0)
//{
// loadTheoThamChieu(matc);
//}
}
