protected void gvDanhSachHangMucThietHai_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
dmdto = new DanhMucThietHaiDTO();
GridViewRow row = gvDanhSachHangMucThietHai.Rows[e.RowIndex];
//TextBox txtnhomhangmuc=row.Cells[0].Controls[0] as TextBox;
TextBox trangthai = row.Cells[1].Controls[0] as TextBox;
TextBox tinhtrang = row.Cells[2].Controls[0] as TextBox;
// CheckBox cktinhtrangthiethai = row.Cells[2].Controls[0] as CheckBox;
TextBox ykien = row.Cells[3].Controls[0] as TextBox;
int mahangmuc = int.Parse(gvDanhSachHangMucThietHai.DataKeys[e.RowIndex].Value.ToString());
dmdto.Ma = mahangmuc;
//string mathamchieu=cl.LayMaTheoTen(thamchieu);
dmdto.MaClaim = mathamchieu;
//dmdto.TenHangMuc= txtnhomhangmuc.Text;
dmdto.TrangThai = trangthai.Text;
//if (ckTinhTrang.Checked == true)
// dmdto.TinhTrang = "Yes";
//else
// dmdto.TinhTrang = "No";
dmdto.TinhTrang = tinhtrang.Text;;
dmdto.YKienGDV = ykien.Text;
bool kq = dmdao.CapNhatDanhMucThietHai(dmdto);
if (kq == true)
{
e.Cancel = true;
gvDanhSachHangMucThietHai.EditIndex = -1;
loadDanhSach(mathamchieu);
}
else
{
Response.Write("<script>alert('Fail!');</script>");
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
dmdto = new DanhMucThietHaiDTO();
dmdto.MaClaim = mathamchieu;
int mahangmuc = int.Parse(drHangMucTaiSan.SelectedItem.Value.ToString());
if (mahangmuc != 0)
{
dmdto.MaHangMuc = mahangmuc;
string trangthai = txtTrangThai.Text;
if (trangthai == "")
{
trangthai = "";
}
if (ckTinhTrang.Checked == true)
{
dmdto.TinhTrang = "Yes";
dmdto.ThietHaiHoanToan = trangthai;
dmdto.TrangThai = "";
}
else
{
dmdto.TinhTrang = "No";
dmdto.ThietHaiHoanToan = "";
dmdto.TrangThai = trangthai;
}
string ykien = txtYKienGDV.Text;
if (ykien != "")
{
dmdto.YKienGDV = ykien;
}
else
{
dmdto.YKienGDV = "";
}
bool kq = dmdao.ThemDanhMucThietHai(dmdto);
if (kq == true)
{
//Response.Write("<script> alert ('Update succeed!');</script>");
loadDanhSach(mathamchieu);
txtTrangThai.Text = "";
txtYKienGDV.Text = "";
ckTinhTrang.Checked = false;
}
else
{
Response.Write("<script> alert ('Fail!');</script>");
}
}
else
{
Response.Write("<script>alert('Chưa chọn hạng mục tài sản !');</script>");
}
}
public bool ThemDanhMucThietHai(DanhMucThietHaiDTO dm)
{
string sql = "sp_DanhMucThietHai_insert";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter maclaim = new SqlParameter("@maclaim", SqlDbType.VarChar);
maclaim.Value = dm.MaClaim;
ds.Add(maclaim);
SqlParameter mahangmuc = new SqlParameter("@mahangmuc", SqlDbType.Int);
mahangmuc.Value = dm.MaHangMuc;
ds.Add(mahangmuc);
SqlParameter trangthai = new SqlParameter("@trangthai", SqlDbType.NVarChar);
trangthai.Value = dm.TrangThai;
ds.Add(trangthai);
SqlParameter tinhtrang = new SqlParameter("@tinhtrang", SqlDbType.VarChar);
tinhtrang.Value = dm.TinhTrang;
ds.Add(tinhtrang);
SqlParameter ykien = new SqlParameter("@ykien", SqlDbType.NVarChar);
ykien.Value = dm.YKienGDV;
ds.Add(ykien);
SqlParameter thiethaiht = new SqlParameter("@thiethaihoantoan", SqlDbType.NVarChar);
thiethaiht.Value = dm.ThietHaiHoanToan;
ds.Add(thiethaiht);
SqlParameter motachung = new SqlParameter("@motachung", SqlDbType.NVarChar);
motachung.Value = dm.MoTaChung;
ds.Add(motachung);
bool kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return(kq);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
DanhMucThietHaiDAO dao = new DanhMucThietHaiDAO();
DanhMucThietHaiDTO thietHai = new DanhMucThietHaiDTO();
thietHai.Ma = int.Parse(hiddenDanhMucID.Value);
string thamchieu = Session["ThamChieu"].ToString();
thietHai.MaClaim = thamchieu;
thietHai.MaHangMuc = int.Parse(drDamaged.SelectedValue);
thietHai.ThietHaiHoanToan = txtTotally.Text;
thietHai.TrangThai = txtPartial.Text;
if (checkTinhTrang.Checked)
{
thietHai.TinhTrang = "Yes";
}
else
{
thietHai.TinhTrang = "No";
}
thietHai.YKienGDV = txtYKienGDV.Text;
thietHai.MoTaChung = txtMoTaChung.Text;
dao.CapNhatDanhMucThietHai(thietHai);
panelGrid.Visible = true;
panelAddEdit.Visible = false;
Response.Write("<script>parent.reloaData();</script>");
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
string noidung = gdv.LayTenTheoMa(maGDV) + " edited summary of loss of case" + thamchieu + " .";
SaveLogTracking(maGDV, noidung, thamchieu);
loadDanhMucThietHai();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public bool CapNhatDanhMucThietHai(DanhMucThietHaiDTO dm)
{
string sql = "sp_DanhMucThietHai_update";
List <SqlParameter> ds = new List <SqlParameter>();
SqlParameter ma = new SqlParameter("@ma", SqlDbType.Int);
ma.Value = dm.Ma;
ds.Add(ma);
ds.Add(new SqlParameter("@maHangMuc", dm.MaHangMuc));
ds.Add(new SqlParameter("@thiethaihoantoan", dm.ThietHaiHoanToan));
SqlParameter trangthai = new SqlParameter("@trangthai", SqlDbType.NVarChar);
trangthai.Value = dm.TrangThai;
ds.Add(trangthai);
SqlParameter tinhtrang = new SqlParameter("@tinhtrang", SqlDbType.VarChar);
tinhtrang.Value = dm.TinhTrang;
ds.Add(tinhtrang);
SqlParameter ykien = new SqlParameter("@ykien", SqlDbType.NVarChar);
ykien.Value = dm.YKienGDV;
ds.Add(ykien);
SqlParameter motachung = new SqlParameter("@motachung", SqlDbType.NVarChar);
motachung.Value = dm.MoTaChung;
ds.Add(motachung);
bool kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return(kq);
}
