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;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
DanhMucThietHaiDAO dao = new DanhMucThietHaiDAO();
DanhMucThietHaiDTO thietHai = new DanhMucThietHaiDTO();
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.ThemDanhMucThietHai(thietHai);
Response.Write("<script>parent.reloaData();</script>");
panelGrid.Visible = true;
panelAddEdit.Visible = false;
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
string noidung = gdv.LayTenTheoMa(maGDV) + " created a summary of loss of case SR01" + thamchieu + " .";
SaveLogTracking(maGDV, noidung, thamchieu);
loadDanhMucThietHai();
}catch(Exception ex){
lblMessage.Text = ex.Message;
}
}
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 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>");
}