public bool DiaryMoi(DiaryDTO dr)
{
string sql = "sp_Diary_insert2";
List<SqlParameter> ds = new List<SqlParameter>();
SqlParameter magdv = new SqlParameter("@maGDV", SqlDbType.Int);
magdv.Value = dr.MaGDV;
ds.Add(magdv);
SqlParameter macl = new SqlParameter("@maClaim", SqlDbType.VarChar);
macl.Value = dr.MaClaim;
ds.Add(macl);
SqlParameter ngaythuc = new SqlParameter("@ngaythuc", SqlDbType.DateTime);
ngaythuc.Value = dr.NgayThuc;
ds.Add(ngaythuc);
SqlParameter ngay = new SqlParameter("@ngay", SqlDbType.DateTime);
ngay.Value = dr.Ngay;
ds.Add(ngay);
SqlParameter diengiai = new SqlParameter("@diengiai", SqlDbType.NVarChar);
diengiai.Value = dr.DienGiai;
ds.Add(diengiai);
SqlParameter sogio = new SqlParameter("@sogio", SqlDbType.Float);
sogio.Value = dr.SoGio;
ds.Add(sogio);
SqlParameter batdau = new SqlParameter("@ngaygiobatdau", SqlDbType.DateTime);
batdau.Value = dr.NgayGioBatDau;
ds.Add(batdau);
SqlParameter ketthuc = new SqlParameter("@ngaygioketthuc", SqlDbType.DateTime);
ketthuc.Value = dr.NgayGioKetThuc;
ds.Add(ketthuc);
SqlParameter ketqua = new SqlParameter("@ketqua", SqlDbType.NVarChar);
ketqua.Value = dr.KetQua;
ds.Add(ketqua);
bool kq = SqlDataAcessHelper.exNonStoreParas(sql, ds);
return kq;
}
protected void btnThem_Click(object sender, EventArgs e)
{
DiaryDTO drdto = new DiaryDTO();
DiaryDAO drdao = new DiaryDAO();
string maclaim = txtThamChieu.Text;
bool kt = cl.KiemTraThamChieu(maclaim);
//string maGDV = Session["MaGDV"].ToString();
//string tengdv = Session["GDV"].ToString();
int maGDV = int.Parse(drGDV0.SelectedValue.ToString());
if (maGDV != null)
{
if (kt == true)
drdto.MaClaim = maclaim;
else
{
lbllThongBao.Text = "Chưa có claim này";
lbllThongBao.Visible = true;
}
drdto.MaGDV = maGDV;
drdto.NgayThuc = DateTime.Now;
drdto.Ngay =DateTime.Parse(txtNgay.Text);
drdto.DienGiai = txtDienGiai.Text.Trim();
drdto.SoGio = float.Parse(txtSoGio.Text);
drdto.NgayGioBatDau = DateTime.Parse(txtNgayBatDau.Text);
drdto.NgayGioKetThuc = DateTime.Parse(txtNgayKetThuc.Text);
drdto.KetQua = txtKetQuaGhiNhan.Text.Trim();
bool them = drdao.DiaryMoi(drdto);
if (them == true)
{
Response.Write("<script>alert('Đã thêm!');</script>");
}
else
{
lblThongBaoThem.Visible = true;
lblThongBaoThem.Text = "Have something wrong here!";
}
}
else
Response.Redirect("~/Pages/Longin.aspx");
}
protected void gvDSDiary_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = gvDSDiary.Rows[e.RowIndex];
TextBox maclaim = row.Cells[1].Controls[0] as TextBox;
TextBox diengiai = row.Cells[3].Controls[0] as TextBox;
TextBox ts = row.Cells[4].Controls[0] as TextBox;
TextBox date = row.Cells[5].Controls[0] as TextBox;
TextBox start = row.Cells[6].Controls[0] as TextBox;
TextBox end = row.Cells[7].Controls[0] as TextBox;
TextBox re = row.Cells[8].Controls[0] as TextBox;
int ma = int.Parse(gvDSDiary.DataKeys[e.RowIndex].Value.ToString());
DiaryDTO dr = new DiaryDTO();
dr.MaDiary = ma;
dr.MaClaim = maclaim.Text;
dr.DienGiai = diengiai.Text;
dr.SoGio = int.Parse(ts.Text);
dr.Ngay = DateTime.Parse(date.Text);
dr.NgayGioBatDau = DateTime.Parse(start.Text);
dr.NgayGioKetThuc = DateTime.Parse(end.Text);
dr.KetQua = re.Text;
bool up = drdao.CapNhatDiary(dr);
if (up == true)
{
e.Cancel = true;
gvDSDiary.EditIndex = -1;
loadDiaryAll();
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
tsdto = new DiaryDTO();
string maclaim = txtThamChieu.Text;
bool kt = cl.KiemTraThamChieu(maclaim);
int maGDV = int.Parse(Session["MaGDV"].ToString());
string tengdv = Session["GDV"].ToString();
if (maGDV != null)
{
if (kt == true)
{
tsdto.MaClaim = maclaim;
tsdto.MaGDV = maGDV;
tsdto.NgayThuc = DateTime.Now;
tsdto.Ngay = DateTime.Parse(txtNgay.Text);
tsdto.DienGiai = txtDienGiai.Text.Trim();
tsdto.SoGio = float.Parse(txtSoGio.Text);
tsdto.NgayGioBatDau = DateTime.Parse(txtNgayBatDau.Text);
tsdto.NgayGioKetThuc = DateTime.Parse(txtNgayKetThuc.Text);
tsdto.KetQua = txtKetQuaGhiNhan.Text.Trim();
bool them = drdao.DiaryMoi(tsdto);
if (them == true)
{
#region KiemTra_GuiMail
float gio = drdao.TongThoiLuongPhatSinh(maclaim);
bool updw = wr.CapNhatGioTichLuy(maclaim, gio);
#region BodysendLA
string bodyGDV = "Xin chào " + tengdv;
bodyGDV += "<br/> Bạn vừa cập nhật Diary mới. <br/> Thông tin Diary:<br/>";
bodyGDV += "<table width='100%' align='center' style='border-bottom-color:#CCC; border-bottom-style:solid; border-bottom-width:1px; " +
" border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;" +
" border-right-color:#CCC; border-right-style:solid; border-right-width:1px;'>";
bodyGDV += "<tr style='background-color: #040; color:#FFF; font-weight:bold;'>";
//bodyGDV += "<th width='10%'>Giám định viên</th>";
bodyGDV += "<th width='10%'>Tham chiếu</th>";
bodyGDV += "<th width='10%'>Ngày</th>";
bodyGDV += "<th width='30%'>Diễn giải</th>";
bodyGDV += "<th width='10%'>Số giờ</th>";
bodyGDV += "<th width='10%'>Start</th>";
bodyGDV += "<th width='10%'>Ended</th>";
bodyGDV += "<th width='30%'>Kết quả</th>";
bodyGDV += "</tr>";
bodyGDV += "<tr style='text-align:center'>";
//bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
//" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tengdv + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.MaClaim + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.Ngay + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.DienGiai + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.SoGio + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioBatDau + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioKetThuc + "</td>";
bodyGDV += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.KetQua + "</td>";
bodyGDV += "</tr>";
bodyGDV += "</table>";
#endregion
#region BodyMailGiamDoc
//timesheet gui giam doc
string bodyGiamDoc = "Thông báo! ";
bodyGiamDoc += "<br/>" + tengdv + " vừa cập nhật Dairy mới. <br/> Thông tin Diary:<br/>";
bodyGiamDoc += "<table width='100%' align='center' style='border-bottom-color:#CCC; border-bottom-style:solid; border-bottom-width:1px; " +
" border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;" +
" border-right-color:#CCC; border-right-style:solid; border-right-width:1px;'>";
bodyGiamDoc += "<tr style='background-color: #040; color:#FFF; font-weight:bold;'>";
bodyGiamDoc += "<th width='20%'>GĐV</th>";
bodyGiamDoc += "<th width='10%'>Tham chiếu</th>";
bodyGiamDoc += "<th width='10%'>Ngày Thực</th>";
bodyGiamDoc += "<th width='10%'>Ngày</th>";
bodyGiamDoc += "<th width='30%'>Diễn giải</th>";
bodyGiamDoc += "<th width='10%'>Số giờ</th>";
bodyGiamDoc += "<th width='10%'>Start</th>";
bodyGiamDoc += "<th width='10%'>Ended</th>";
bodyGiamDoc += "<th width='30%'>Kết quả</th>";
bodyGiamDoc += "</tr>";
bodyGiamDoc += "<tr style='text-align:center'>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tengdv + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.MaClaim + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayThuc + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.Ngay + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.DienGiai + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.SoGio + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioBatDau + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.NgayGioKetThuc + "</td>";
bodyGiamDoc += "<td style ='border-top-color:#CCC; border-top-style:solid; border-top-width:1px;" +
" border-left-color:#CCC; border-left-style:solid; border-left-width:1px;'>" + tsdto.KetQua + "</td>";
bodyGiamDoc += "</tr>";
bodyGiamDoc += "</table>";
#endregion
string sTo = "";
int idgdv = int.Parse(Session["MaGDV"].ToString());
GiamDinhVienDAO gdvdao = new GiamDinhVienDAO();
DataTable dt = new DataTable();
dt = gdvdao.GiamDinhVienTheoMa(idgdv);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
sTo = dr[3].ToString();
}
string ktmgdv = "", ktmgiamdoc = "";
int month = int.Parse(DateTime.Now.Month.ToString());
//ktmgiamdoc = smdao.KiemTraMailChinh("Timesheet","*****@*****.**", bodyGiamDoc, "Thông báo Diary của tháng " + month);
ktmgdv = smdao.KiemTraMailChinh("New_Claim",sTo, bodyGDV, "Thông báo cập nhật Diary");
if (updw == true && ktmgdv != "")
{
//Response.Redirect("~/Pages/DiaRy.aspx");
Response.Write("<script>alert('Updated!');</script>");
Response.Redirect(Request.Url.PathAndQuery, true);
}
#endregion
Response.Write("<script>alert('Đã thêm!');</script>");
}
else
{
lblThongBaoThem.Visible = true;
lblThongBaoThem.Text = "Have something wrong here!";
}
}
else
{
Response.Write("<script>alert('Mã Claim không hợp lệ!');</script>");
lbllThongBao.Visible = true;
}
}
else
Response.Redirect("~/Pages/Longin.aspx");
}