protected void ddlEmp_SelectedIndexChanged(object sender, EventArgs e)
{
bindDataPopUpGrid();
ScriptManager.RegisterClientScriptBlock(UpAdd, UpAdd.GetType(), "Script", "validateChosen();", true);
mpeAddCompOff.Show();
}
protected void btnSubmitAdd_Click(object sender, EventArgs e) // Pop Submit Comp Off
{
try
{
bool isSaved = false;
int fromdate = Convert.ToDateTime(txtfromDate1.Text).DayOfYear;
int toDate = Convert.ToDateTime(txtToDate1.Text).DayOfYear;
string from = Convert.ToDateTime(txtfromDate1.Text).Date.ToString("dd/MM/yy");
string to = Convert.ToDateTime(txtToDate1.Text).Date.ToString("dd/MM/yy");
string employeeID = "";
if (ValidateOnSubmit())
{
ArrayList arrlist = new ArrayList();
StringBuilder strError = new StringBuilder();
int difference = 0;
int j = 0;
if (fromdate == toDate)
{
difference = 1;
}
else
{
difference = (toDate - fromdate) + 1;
}
for (int i = 0; i < difference; i++)
{
arrlist.Add(Convert.ToDateTime(txtfromDate1.Text).AddDays(i).ToString("dd/MM/yyyy"));
}
foreach (GridViewRow gr in gvPopUp.Rows)
{
int rowIndex = gr.RowIndex;
CheckBox SaveRows = (CheckBox)gvPopUp.Rows[rowIndex].FindControl("SaveRows");
Label lblEMPID = (Label)gvPopUp.Rows[rowIndex].FindControl("lblEMPID");
if (SaveRows.Checked)
{
SqlDataAdapter da = new SqlDataAdapter("select top 1 1 from tday with(nolock) where TDAY_EMPCDE='" + lblEMPID.Text + "' and tday_date=Convert(datetime,'" + arrlist[j].ToString() + "',105) and tday_status='AB'", conn);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
strError.Append(arrlist[j].ToString());
}
j = j + 1;
}
}
if (strError.Length > 1)
{
lblAddError.Text = "Invalid Day Selection!";
lblAddError.Visible = true;
mpeAddCompOff.Show();
return;
}
j = 0;
foreach (GridViewRow gr in gvPopUp.Rows)
{
int rowIndex = gr.RowIndex;
CheckBox SaveRows = (CheckBox)gvPopUp.Rows[rowIndex].FindControl("SaveRows");
Label lblRowID = (Label)gvPopUp.Rows[rowIndex].FindControl("lblRowID");
Label lblFromDT = (Label)gvPopUp.Rows[rowIndex].FindControl("lblFromDT");
Label lblEMPID = (Label)gvPopUp.Rows[rowIndex].FindControl("lblEMPID");
if (SaveRows.Checked == true)
{
DateTime CO_fromdate = Convert.ToDateTime(arrlist[j].ToString());
string leaveDate = Convert.ToDateTime(lblFromDT.Text).ToString("dd/MM/yyyy");
DateTime LeaveAgainstDate = Convert.ToDateTime(leaveDate);
try
{
string strErrmsg = string.Empty;
string strSuccessMsg = string.Empty;
int rowID = 0;
employeeID = lblEMPID.Text;
SAVE_ESS_TA_CO(CO_fromdate, LeaveAgainstDate, rowID, employeeID, ref strErrmsg, ref strSuccessMsg);
j = j + 1;
if (strErrmsg.Trim().Length > 1)
{
lblAddError.Text = strErrmsg;
lblAddError.Visible = true;
isSaved = false;
}
else
{
lblAddError.Text = strSuccessMsg;
lblAddError.Visible = true;
isSaved = true;
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "ESSTACO");
}
}
}
}
if (isSaved)
{
//ResetAll();
txtfromDate.Text = "";
//FillEmployeeEntity();
txtfromDate1.Text = "";
txtToDate1.Text = "";
ddlEmp.SelectedIndex = 0;
ddlReasonType.SelectedIndex = -1;
txtRemark.Text = "";
bindDataPopUpGrid();
bindDataGrid();
mpeAddCompOff.Show();
ScriptManager.RegisterClientScriptBlock(UpAdd, UpAdd.GetType(), "Script", "validateChosen();", true);
}
}
catch (Exception ee)
{
UNOException.UNO_DBErrorLog(ee.Message, ee.StackTrace, "ESSTACO");
}
}
protected void btnAdd_Click1(object sender, EventArgs e)
{
ResetAll();
mpeAddCompOff.Show();
ScriptManager.RegisterClientScriptBlock(UpAdd, UpAdd.GetType(), "Script", "validateChosen();", true);
}
