protected void btnUpdate_Click(object sender, EventArgs e)
{
TimeSheetDTO ts = new TimeSheetDTO();
ts.ID = int.Parse(lblID.Text);
if (drGDV.Visible == true)
ts.MaGDV = int.Parse(drGDV.SelectedItem.Value.ToString());
else
ts.MaGDV = int.Parse(lblID_GDV.Text);
bool kttc = cl.KiemTraThamChieu(txtThamChieu.Text);
if (kttc == true)
ts.ThamChieu = txtThamChieu.Text;
else
Response.Write("<script>alert('Case no. isn't true!');</script>");
ts.Ngay = txtNgay.Text;
if (drCongTac.Visible == true)
ts.IdCongTacTimeSheet = drCongTac.SelectedItem.Value.ToString();
else
ts.IdCongTacTimeSheet = lblID_CongTac.Text;
ts.DienGiai = txtDienGiaiChiTiet.Text;
string extr = txtEtraFee.Text;
if (extr != "")
ts.ExtraFee = extr;
else
ts.ExtraFee = "";
ts.ThoiLuongPhatSinh = float.Parse(txtSoGio.Text);
ts.TimeIssue = float.Parse(txtTIssue.Text);
bool up = tsdao.UpdateMa(ts);
if (up == true)
{
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
string noidung = gdvdao.LayTenTheoMa(maGDV) + " updated a timesheet of case " + txtThamChieu.Text + " .";
SaveLogTracking(maGDV, noidung, txtThamChieu.Text);
Response.Write("<script> window.parent.closeDialog(); </script>");
Response.Write("<script> window.parent.location.reload();</script>");
}
else
{
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
string noidung = gdvdao.LayTenTheoMa(maGDV) + " failed to update timesheet of case" + txtThamChieu.Text + " .";
SaveLogTracking(maGDV, noidung, txtThamChieu.Text);
Response.Write("<script>alert('Update fail!');</script>");
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
if (this.IsPostBack)
{
TimeSheetDTO tsdto = new TimeSheetDTO();
GiamDinhVienDAO gdv = new GiamDinhVienDAO();
int maGDV = int.Parse(Request.Cookies["MaGDV"].Value);
tsdto.MaGDV = maGDV;
string tengdv = lblGiamDinhVien.Text;
string maclaim = txtThamChieu.Text;
bool kt = cl.KiemTraThamChieu(maclaim);
float h = 0;
if (txtSoGio.Text != "" && float.TryParse(txtSoGio.Text, out h))
{
string diengiai = txtDienGiaiChiTiet.Text; ;
// string diengiaidetail = txtDienGiaiChiTiet.Text;
string loaidiengiai = "";
if (diengiai != "")
tsdto.DienGiai = diengiai;
else
tsdto.DienGiai = "";
string extr = txtEtraFee.Text;
if (extr != "")
tsdto.ExtraFee = extr;
else
tsdto.ExtraFee = "";
if (kt == true)
{
tsdto.ThamChieu = maclaim;
tsdto.Ngay = txtNgay.Text;
tsdto.IdCongTacTimeSheet = drDienGiai.SelectedItem.Value.ToString();
loaidiengiai = drDienGiai.SelectedItem.ToString();
if (int.Parse(drDienGiai.SelectedValue) !=0)
{
tsdto.ThoiLuongPhatSinh = float.Parse(txtSoGio.Text);
tsdto.GioThuc = DateTime.Now;
bool them = tsdao.ThemTimeSheet(tsdto);
if (them == true)
{
float time = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim);
wr.CapNhatGioTichLuy(maclaim, time);
string noidung = gdv.LayTenTheoMa(maGDV) + " created timesheet of case " + txtThamChieu.Text + " .";
SaveLogTracking(maGDV, noidung, txtThamChieu.Text);
#region KiemTra_GuiMail
float gio = tsdao.TongThoiLuongPhatSinhTheoCliam(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 TimeSheet mới. <br/> Thông tin TimeSheet:<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='25%'>Diễn giải</th>";
bodyGDV += "<th width='25%'>Chi tiết</th>";
bodyGDV += "<th width='10%'>Số giờ</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;'>" + tsdto.ThamChieu + "</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;'>" + loaidiengiai + "</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;'>" + 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.ThoiLuongPhatSinh + "</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 TimeSheet mới. <br/> Thông tin Timesheet :<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%'>LA</th>";
bodyGiamDoc += "<th width='10%'>Reference</th>";
bodyGiamDoc += "<th width='10%'>Date Update</th>";
bodyGiamDoc += "<th width='10%'>Date</th>";
bodyGiamDoc += "<th width='30%'>Description</th>";
bodyGiamDoc += "<th width='10%'>Time-Spent</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.ThamChieu + "</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.GioThuc + "</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;'>" + 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.ThoiLuongPhatSinh + "</td>";
bodyGiamDoc += "</tr>";
bodyGiamDoc += "</table>";
#endregion
string sTo = "";
int idgdv = int.Parse(Request.Cookies["MaGDV"].Value);
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());
//Send_Email("*****@*****.**", sTo, "Thông báo timesheet mới", bodyGiamDoc, "[email protected],[email protected]");
//sm.KiemTraMailChinhCC(sTo, bodyGiamDoc, "Timesheet Notification", "Timesheet", "*****@*****.**");
sm.KiemTraMailChinhCC(sTo, bodyGDV, "Timesheet Notification", "Timesheet", "*****@*****.**");
#endregion
ClearInputs(Page.Controls);
//Response.Write("<script> window.parent.closeDialog(); </script>");
//Response.Write("<script> window.parent.location.reload();</script>");
}
}
else
Response.Write("<script>alert('Chưa chọn loại công tác!');</script>");
}
}
else
Response.Write("<script>alert('Nhập sai định dạng giờ lẻ!');</script>");
}
}
public bool UpdateMa(TimeSheetDTO ts)
{
string sql = "sp_Timesheet_UpdateMa";
List<SqlParameter> ds = new List<SqlParameter>();
ds.Add(new SqlParameter("@id", ts.ID));
ds.Add(new SqlParameter("@idgdv",ts.MaGDV));
ds.Add(new SqlParameter("@thamchieu", ts.ThamChieu));
ds.Add(new SqlParameter("@ngay", ts.Ngay));
ds.Add(new SqlParameter("@idcongtac", ts.IdCongTacTimeSheet));
ds.Add(new SqlParameter("@diengiai", ts.DienGiai));
ds.Add(new SqlParameter("@gio", ts.ThoiLuongPhatSinh));
ds.Add(new SqlParameter("@gioissue",ts.TimeIssue));
ds.Add(new SqlParameter("@extra", ts.ExtraFee));
return SqlDataAcessHelper.exNonStoreParas(sql, ds);
}
public bool ThemTimeSheet(TimeSheetDTO ts)
{
string sql="sp_TimeSheet_Them";
List<SqlParameter>ds=new List<SqlParameter>();
SqlParameter a = new SqlParameter("@magdv", SqlDbType.Int);
a.Value = ts.MaGDV;
ds.Add(a);
SqlParameter b = new SqlParameter("@thamchieu", SqlDbType.NVarChar);
b.Value = ts.ThamChieu;
ds.Add(b);
SqlParameter c = new SqlParameter("@ngay", SqlDbType.NVarChar);
c.Value = ts.Ngay;
ds.Add(c);
SqlParameter e = new SqlParameter("@macongtactimesheet", SqlDbType.VarChar);
e.Value = ts.IdCongTacTimeSheet;
ds.Add(e);
SqlParameter f = new SqlParameter("@diengiai", SqlDbType.NVarChar);
f.Value = ts.DienGiai;
ds.Add(f);
SqlParameter g = new SqlParameter("@phatsinh", SqlDbType.Float);
g.Value = ts.ThoiLuongPhatSinh;
ds.Add(g);
SqlParameter giothuc = new SqlParameter("@giothuc", SqlDbType.DateTime);
giothuc.Value = ts.GioThuc;
ds.Add(giothuc);
SqlParameter extra = new SqlParameter("@extra",SqlDbType.NVarChar);
extra.Value = ts.ExtraFee;
ds.Add(extra);
return SqlDataAcessHelper.exNonStoreParas(sql, ds);
}
public bool SuaTimeSheet(TimeSheetDTO ts)
{
string sql= "sp_TimeSheet_Sua";
List<SqlParameter>ds=new List<SqlParameter>();
SqlParameter ma = new SqlParameter("@id", SqlDbType.Int);
ma.Value = ts.ID;
ds.Add(ma);
SqlParameter b = new SqlParameter("@thamchieu", SqlDbType.NVarChar);
b.Value = ts.ThamChieu;
ds.Add(b);
SqlParameter e = new SqlParameter("@macongtactimesheet", SqlDbType.VarChar);
e.Value = ts.IdCongTacTimeSheet;
ds.Add(e);
SqlParameter ngay = new SqlParameter("@ngay", SqlDbType.VarChar);
ngay.Value = ts.Ngay;
ds.Add(ngay);
SqlParameter f = new SqlParameter("@diengiai", SqlDbType.NVarChar);
f.Value = ts.DienGiai;
ds.Add(f);
SqlParameter g = new SqlParameter("@phatsinh", SqlDbType.Float);
g.Value = ts.ThoiLuongPhatSinh;
ds.Add(g);
return SqlDataAcessHelper.exNonStoreParas(sql, ds);
}
//protected void btnSave_Click(object sender, EventArgs e)
//{
// if (ddlFile.SelectedValue == "Excel")
// {
// HtmlForm form = new HtmlForm();
// string attachment = "attachment; filename=aaa.xls";
// Response.ClearContent();
// Response.AddHeader("content-disposition", attachment);
// Response.ContentType = "application/ms-excel";
// Response.Charset = "";
// Response.ContentEncoding = System.Text.Encoding.Unicode;
// Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
// StringWriter stw = new StringWriter();
// HtmlTextWriter htextw = new HtmlTextWriter(stw);
// gvDSTimeSheet.Columns[7].Visible = false;
// gvDSTimeSheet.Columns[8].Visible = false;
// form.Controls.Add(gvDSTimeSheet);
// this.Controls.Add(form);
// form.RenderControl(htextw);
// Response.Write(stw.ToString());
// Response.End();
// }
// if (ddlFile.SelectedValue == "Word")
// {
// Response.AddHeader("content-disposition", "attachment;filename=Export.doc");
// Response.Cache.SetCacheability(HttpCacheability.NoCache);
// Response.ContentType = "application/vnd.word";
// Response.ClearContent();
// Response.Charset = "";
// Response.ContentEncoding = System.Text.Encoding.Unicode;
// Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
// StringWriter stringWrite = new StringWriter();
// HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
// HtmlForm frm = new HtmlForm();
// gvDSTimeSheet.Columns[7].Visible = false;
// gvDSTimeSheet.Columns[8].Visible = false;
// gvDSTimeSheet.Parent.Controls.Add(frm);
// frm.Attributes["runat"] = "server";
// frm.Controls.Add(gvDSTimeSheet);
// frm.RenderControl(htmlWrite);
// Response.Write(stringWrite.ToString());
// Response.End();
// }
//}
protected void btnThem_Click(object sender, EventArgs e)
{
if (this.IsPostBack)
{
TimeSheetDTO tsdto = new TimeSheetDTO();
int maGDV = int.Parse(drGDV.SelectedItem.Value.ToString());
tsdto.MaGDV = maGDV;
string maclaim = txtThamChieu.Text;
bool kt = cl.KiemTraThamChieu(maclaim);
string diengiai;
if (kt == true)
{
tsdto.ThamChieu = maclaim;
tsdto.Ngay = txtNgay.Text;
tsdto.IdCongTacTimeSheet = drDienGiai.SelectedItem.Value.ToString();
diengiai = drDienGiai.SelectedItem.ToString();
tsdto.ThoiLuongPhatSinh = float.Parse(txtSoGio.Text);
bool them = tsdao.ThemTimeSheet(tsdto);
if (them == true)
{
float time = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim);
wr.CapNhatGioTichLuy(maclaim, time);
float gio = tsdao.TongThoiLuongPhatSinhTheoCliam(maclaim);
bool updw = wr.CapNhatGioTichLuy(maclaim, gio);
Response.Write("<script>alert('Đã thêm!');</script>");
}
}
}
}