public void Leave_Insert()
{
DateTime dt = DateTime.Now;
if (cb + "" == "")
{
//MessageBox.Show(PublicFunction.L_Get_Msg("msg", 19));
return;
}
if (!ck && (dt4.ToString("HHmm") + "" == "" || dt3.ToString("HHmm") + "" == ""))
{
//MessageBox.Show(PublicFunction.L_Get_Msg("msg", 191));
return;
}
string sql1 = "";
var _con = new SqlConnection(PublicFunction.connectionString);
_con.Open();
SqlTransaction tran = _con.BeginTransaction();
try
{
string sql = "";
//vs1.Row = i;
EMP_ID = /*vs1.Rows[i]["EMP_ID"]*/ EMP_ID + "";
INH_DT = (DateTime.ParseExact(INH_DT, "MM/dd/yyyy", CultureInfo.InvariantCulture)).ToString("yyyy/MM/dd");
TYP_ID = TYP_ID + "";
if (!Duplicate()) //Kiểm tra trùng ngày nghỉ phép
{
string SEQ_NO = T_String.GetMax("MAX(SEQ_NO)", "TBLLEAVE") + "";
int c = 0;
if (ck)
{
c = 1;
}
cal();
DateTime dtt = dt2;
//NhuY: xet nam tinh fep nam
string YYY = dtt.Year + "";
int iCloseDay = /*T_String.IsNullTo0(PublicFunction.GetOption("DAYCLOSE"))*/ 1;
if (iCloseDay <= 0)
{
iCloseDay = 1;
}
if (iCloseDay > 15 && dtt.Day >= iCloseDay && dtt.Month == 12)
{
YYY = (dtt.Year + 1) + "";
}
//NhuY
if (!Overflow(INH_DT, dtt, YYY))
{
sql = "Insert Into TBLLEAVE(SEQ_NO,EMP_ID,STR_DT,END_DT,STR_TM,END_TM,HOU_DY,HOU_TT,LEA_ID,"
+ "DAY_TT,DAY_BT,NOT_DR,BLT_NM,BLT_DT) values("
+ SEQ_NO + ","
+ "N'" + EMP_ID + "',"
+ "'" + dt1.ToString("yyyy/MM/dd") + "',"
+ "'" + dt2.ToString("yyyy/MM/dd") + "',";
if (ck)
{
sql += "Default,"
+ "Default,";
sql += "'" + txt_h + "',";
}
else
{
sql += "'" + dt3.ToString("HHmm") + "',"
+ "'" + dt4.ToString("HHmm") + "',";
sql += "'" + txt_h1 + "',";
}
sql += "'" + T_String.IsNullTo00(txt_hr) + "',"
+ "N'" + cb + "',"
+ "'" + T_String.IsNullTo00(txt_day) + "',"
+ "'" + c + "',"
+ "N'" + txt_note + "',N'" + USER_ID + "','" + dt.ToString("yyyy/MM/dd HH:mm") + "')";
SqlCommand cmd = new SqlCommand(sql, _con, tran);
cmd.ExecuteNonQuery();
//if (IsAnnualLeave(cb.SelectedValue + "")) //update ngay phep nam
//{
// if (T_String.IsNullTo0(T_String.GetDataFromSQL("Count(*)", "FILC04B", "EMP_ID=N'" + EMP_ID + "' and YYY_YY=N'" + ((DateTime)dt1.Value).ToString("yyyy") + "'")) <= 0)
// {
// sql = "Insert Into FILC04B(YYY_YY,EMP_ID,BLT_NM,BLT_DT) values (N'"
// + ((DateTime)dt1.Value).ToString("yyyy") + "',N'" + EMP_ID + "',N'" + PublicFunction.A_UserID + "','" + dt.ToString("yyyy/MM/dd HH:mm") + "')";
// cmd = new SqlCommand(sql, con, tran);
// cmd.ExecuteNonQuery();
// }
// //NhuY: sua tr/hop ngay ket ko la ngay 1
// if (PublicFunction.dayClose <= 15)
// {
// sql = "EMP_ID=N'" + EMP_ID + "' and "
// + "YEAR(STR_DT)='" + YYY + "' and "
// + "YEAR(END_DT)='" + YYY + "'";
// }
// else
// {
// sql = "EMP_ID=N'" + EMP_ID + "' AND STR_DT>='" + (int.Parse(YYY) - 1) + "/12/" + PublicFunction.dayClose
// + "' AND END_DT<'" + YYY + "/12/" + PublicFunction.dayClose + "'";
// }
// sql = "Update FILC04B set DID_QT=(Select SUM(DAY_TT) from FILC04A where " + sql
// + ") where EMP_ID=N'" + EMP_ID + "' and YYY_YY=N'" + YYY + "'";
// cmd = new SqlCommand(sql, con, tran);
// cmd.ExecuteNonQuery();
// //cmd = new SqlCommand(CalStaffDaNghi(EMP_ID, dtt, INH_DT), con, tran);
// //cmd.ExecuteNonQuery();
//}
if (sql1 != "")
{
sql1 += ",";
}
sql1 += "N'" + EMP_ID + "'";
//vs1.RemoveItem(i);
tran.Commit();
//Tiến hành chuyển dữ liệu chấm công
Leave_Attendance_Cal(EMP_ID, dt1, dt2, null);
}
else
{
// if(IsAnnualLeave(cb.SelectedValue+"") && PublicFunction.CUS_ID != "100")
// MessageBox.Show(EMP_ID+" "+ PublicFunction.L_Get_Msg("msg",55)
// +GetNgayPhepNam(EMP_ID,((DateTime)dt1.Value).ToString("yyyy"))+". ");
tran.Rollback();
}
}
else
{
//MessageBox.Show(vs1.Rows[i]["EMP_ID"] + " " + PublicFunction.L_Get_Msg("msg", 20));
err += " Lỗi thêm cho nhân viên " + EMP_ID;
tran.Rollback();
}
}
catch (Exception ex)
{
try
{
tran.Rollback();
}
catch { }
err = err + " " + ex.Message + " - " + ex.StackTrace;
//MessageBox.Show(ex.Message);
}
_con.Close();
}
