protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
DataTable dt = clsWeeklyOffHandler.GetWeekendWeekoffDetails("All");
if (textreasonid.Text.ToString() == "" && textreasonname.Text.ToString() == "")
{
gvReason.DataSource = dt;
gvReason.DataBind();
}
else
{
String[,] values =
{
{ "MWK_CD~" + textreasonid.Text.Trim(), "S" },
{ "MWK_CD~" + textreasonname.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvReason.DataSource = _tempDT;
gvReason.DataBind();
}
DropDownList ddl = (DropDownList)gvReason.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvReason.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvReason.PageIndex + 1).ToString();
Label lblcount = (Label)gvReason.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvReason.DataSource).Rows.Count.ToString() + " Records.";
if (gvReason.PageCount == 0)
{
((Button)gvReason.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvReason.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvReason.PageIndex + 1 == gvReason.PageCount)
{
((Button)gvReason.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvReason.PageIndex == 0)
{
((Button)gvReason.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvReason.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvReason.PageSize * gvReason.PageIndex) + 1) + " to " + (((gvReason.PageSize * (gvReason.PageIndex + 1)) - 10) + gvReason.Rows.Count);
gvReason.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
// bug 87 solved start --swapnil
protected void cmdSearch_Click(object sender, EventArgs e)
{
string strsql = "SELECT CLIENT_ID,CLIENT_NAME,CLIENT_DESC,CLIENT_SITE_ADDRESS,CLIENT_HO_ADDRESS,CLIENT_PHONE1," +
" CLIENT_PHONE2,CLIENT_CONTACT_PERSON1,CLIENT_CONTPER1_PHONE1,CLIENT_CONTPER1_PHONE2" +
" ,CLIENT_CONTACT_PERSON2,CLIENT_CONTPER2_PHONE1,CLIENT_CONTPER2_PHONE2 FROM TE_CLIENT_FILE where CLIENT_ISDELETED = '0'";
SqlDataAdapter daLVdetails = new SqlDataAdapter(strsql, conn);
DataTable dtLVdetails = new DataTable();
daLVdetails.Fill(dtLVdetails);
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "CLIENT_ID-" + txtCompanyId.Text.Trim(), "S" },
{ "CLIENT_NAME-" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dtLVdetails);
Grid.DataSource = _tempDT;
Grid.DataBind();
}
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
string strsql = " SELECT SCHEDULER_TASK_TYPE,SCHEDULER_DESCRIPTION,SCHEDULER_FREQUENCY,SUBSTRING(CONVERT(VARCHAR,SCHEDULER_TIME,114),0,6) AS SCHEDULER_TIME " +
" FROM SCHEDULER Where SCHEDULER_ISDELETED = '0' ORDER BY CASE WHEN ISNUMERIC(SCHEDULER_TASK_TYPE) = 1 THEN 0 ELSE 1 END, " +
" CASE WHEN ISNUMERIC(SCHEDULER_TASK_TYPE) = 1 THEN CAST(SCHEDULER_TASK_TYPE AS INT) ELSE 0 END ";
SqlDataAdapter da = new SqlDataAdapter(strsql, AccessController.m_connecton);
DataTable dt = new DataTable();
da.Fill(dt);
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "SCHEDULER_TASK_TYPE-" + txtCompanyId.Text.Trim(), "S" },
{ "SCHEDULER_DESCRIPTION-" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvScheduleSettings.DataSource = _tempDT;
gvScheduleSettings.DataBind();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblMessages.Visible = false;
ReportViewer1.Visible = false;
DataTable dt = clsEmployeeLeftHandler.GetAllLeftEmployees();
if (txtSearchEmployeeid.Text.ToString() == "")
{
gvLeaveData.DataSource = dt;
gvLeaveData.DataBind();
}
else
{
String[,] values =
{
{ "EL_EMP_ID~" + txtSearchEmployeeid.Text.Trim(), "S" },
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvLeaveData.DataSource = _tempDT;
gvLeaveData.DataBind();
}
DropDownList ddl = (DropDownList)gvLeaveData.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvLeaveData.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvLeaveData.PageIndex + 1).ToString();
Label lblcount = (Label)gvLeaveData.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvLeaveData.DataSource).Rows.Count.ToString() + " Records.";
if (gvLeaveData.PageCount == 0)
{
((Button)gvLeaveData.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvLeaveData.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvLeaveData.PageIndex + 1 == gvLeaveData.PageCount)
{
((Button)gvLeaveData.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvLeaveData.PageIndex == 0)
{
((Button)gvLeaveData.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvLeaveData.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvLeaveData.PageSize * gvLeaveData.PageIndex) + 1) + " to " + (gvLeaveData.PageSize * (gvLeaveData.PageIndex + 1));
gvLeaveData.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
DataTable dt = getTable();
if (txtUserID.Text.ToString() == "" && txtLevelID.Text.ToString() == "")
{
gvEvent.DataSource = dt;
gvEvent.DataBind();
}
else
{
String[,] values =
{
{ "Event_Employee_Code~" + txtUserID.Text.Trim(), "S" },
{ "Name~" + txtLevelID.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvEvent.DataSource = _tempDT;
gvEvent.DataBind();
}
DropDownList ddl = (DropDownList)gvEvent.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvEvent.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvEvent.PageIndex + 1).ToString();
Label lblcount = (Label)gvEvent.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvEvent.DataSource).Rows.Count.ToString() + " Records.";
if (gvEvent.PageCount == 0)
{
((Button)gvEvent.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvEvent.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEvent.PageIndex + 1 == gvEvent.PageCount)
{
((Button)gvEvent.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEvent.PageIndex == 0)
{
((Button)gvEvent.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvEvent.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEvent.PageSize * gvEvent.PageIndex) + 1) + " to " + (((gvEvent.PageSize * (gvEvent.PageIndex + 1)) - 10) + gvEvent.Rows.Count);
gvEvent.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "HolidayView");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtemp_code.Text.ToString() == "" && txtemp_name.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "EPD_EMPID~" + txtemp_code.Text.Trim(), "S" },
{ "EPD_EMP_NAME~" + txtemp_name.Text.Trim(), "S" }
};
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, _baseDT);
gvEmployee.DataSource = _tempDT;
gvEmployee.DataBind();
if (_tempDT.Rows.Count != 0)
{
DropDownList ddl = (DropDownList)gvEmployee.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvEmployee.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvEmployee.PageIndex + 1).ToString();
Label lblcount = (Label)gvEmployee.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvEmployee.DataSource).Rows.Count.ToString() + " Records.";
if (gvEmployee.PageCount == 0)
{
((Button)gvEmployee.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvEmployee.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmployee.PageIndex + 1 == gvEmployee.PageCount)
{
((Button)gvEmployee.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmployee.PageIndex == 0)
{
((Button)gvEmployee.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvEmployee.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmployee.PageSize * gvEmployee.PageIndex) + 1) + " to " + (gvEmployee.PageSize * (gvEmployee.PageIndex + 1));
((Label)gvEmployee.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmployee.PageSize * gvEmployee.PageIndex) + 1) + " to " + (((gvEmployee.PageSize * (gvEmployee.PageIndex + 1)) - 10) + gvEmployee.Rows.Count);
gvEmployee.BottomPagerRow.Visible = true;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblMessages.Text = string.Empty;
lblSaveMessages.Text = string.Empty;
clsEmployee objEmp = new clsEmployee();
DataTable dt = clsEmployeeHandler.GetEmployeeManagerDetails(ddlEmpStatus.SelectedValue.ToString(), "AllEmployees", "");
if (txtCompanyName.Text.ToString() == "" && txtCompanyID.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "EPD_empid~" + txtCompanyID.Text.Trim(), "S" },
{ "EPD_Name~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvEmployee.DataSource = _tempDT;
gvEmployee.DataBind();
_tempDT = _sc.searchTable(values, dt);
gvEmployee.DataSource = _tempDT;
gvEmployee.DataBind();
DropDownList ddl = (DropDownList)gvEmployee.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvEmployee.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvEmployee.PageIndex + 1).ToString();
Label lblcount = (Label)gvEmployee.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvEmployee.DataSource).Rows.Count.ToString() + " Records.";
if (gvEmployee.PageCount == 0)
{
((Button)gvEmployee.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvEmployee.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmployee.PageIndex + 1 == gvEmployee.PageCount)
{
((Button)gvEmployee.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmployee.PageIndex == 0)
{
((Button)gvEmployee.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvEmployee.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmployee.PageSize * gvEmployee.PageIndex) + 1) + " to " + (((gvEmployee.PageSize * (gvEmployee.PageIndex + 1)) - 10) + gvEmployee.Rows.Count);
gvEmployee.BottomPagerRow.Visible = true;
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeMasterView");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblMessages.Text = string.Empty;
lblMsg.Text = string.Empty;
lblError.Text = string.Empty;
DataTable dt = clsTimeZoneViewHandler.GetAllDetails("All");
if (txtTimezoneDesc.Text.ToString() == "" && txtTimezoneId.Text.ToString() == "")
{
gvTimezone.DataSource = dt;
gvTimezone.DataBind();
}
else
{
String[,] values =
{
{ "TZ_CODE~" + txtTimezoneId.Text.Trim(), "S" },
{ "TZ_DESCRIPTION~" + txtTimezoneDesc.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvTimezone.DataSource = _tempDT;
gvTimezone.DataBind();
}
DropDownList ddl = (DropDownList)gvTimezone.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvTimezone.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvTimezone.PageIndex + 1).ToString();
Label lblcount = (Label)gvTimezone.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvTimezone.DataSource).Rows.Count.ToString() + " Records.";
if (gvTimezone.PageCount == 0)
{
((Button)gvTimezone.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvTimezone.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvTimezone.PageIndex + 1 == gvTimezone.PageCount)
{
((Button)gvTimezone.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvTimezone.PageIndex == 0)
{
((Button)gvTimezone.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvTimezone.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvTimezone.PageSize * gvTimezone.PageIndex) + 1) + " to " + (((gvTimezone.PageSize * (gvTimezone.PageIndex + 1)) - gvTimezone.PageSize) + gvTimezone.Rows.Count);
gvTimezone.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblMessages.Text = "";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string strsql = "select ESS_GP_RowID,ess_GP_empid as EmpCode,ent_employee_personal_dtls.Epd_First_Name+ ' ' +ent_employee_personal_dtls.Epd_Last_Name as Name,convert(VARCHAR(20),Ess_GP_fromdt,103) as FromDate, case when convert(VARCHAR(20),Ess_GP_Todt,103)= convert(VARCHAR(20),Ess_GP_fromdt,103) " +
" then ''else convert(VARCHAR(20),Ess_GP_Todt,103) end as ToDate,convert(char(5),ESS_GP_FROMTM,8) as [In],convert(char(5),ESS_GP_TOTM,8) as [Out], Case ESS_GP_Status WHEN 'N' then 'Pending For Approval' " +
" when 'A' then 'Approved' When 'R' then 'Rejected' When 'C' then 'Cancelled' End as ESS_GP_Status from ESS_TA_GP,ent_employee_personal_dtls " +
" where ess_ta_gp.ess_gp_empid=ent_employee_personal_dtls.epd_empid " +
" and ess_gp_empid= '" + userid + "' and ess_gp_isdeleted='0' order by convert(datetime,Ess_GP_fromdt,103) desc";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
DataTable dt = new DataTable();
da.SelectCommand.CommandTimeout = 0;
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtTodate.Text.ToString() == "" && txtFromDate.Text.ToString() == "")
{
gvGP.DataSource = dt;
gvGP.DataBind();
}
else
{
String[,] values =
{
{ "fromdate~" + txtFromDate.Text.Trim(), "D" },
{ "Todate~" + txtTodate.Text.Trim(), "D" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvGP.DataSource = _tempDT;
gvGP.DataBind();
}
DropDownList ddl = (DropDownList)gvGP.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvGP.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvGP.PageIndex + 1).ToString();
Label lblcount = (Label)gvGP.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvGP.DataSource).Rows.Count.ToString() + " Records.";
if (gvGP.PageCount == 0)
{
((Button)gvGP.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvGP.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvGP.PageIndex + 1 == gvGP.PageCount)
{
((Button)gvGP.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvGP.PageIndex == 0)
{
((Button)gvGP.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvGP.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvGP.PageSize * gvGP.PageIndex) + 1) + " to " + (gvGP.PageSize * (gvGP.PageIndex + 1));
gvGP.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "ESS_TA_GP_View");
}
}
public void bindDataGrid()
{
try
{
DataTable _tempDT = new DataTable();
DataTable dt = new DataTable();
dt = GetDataTable(userid, cmbEntity.SelectedValue, ddlStatus.SelectedValue);
if (txtTodate.Text.ToString() == "" && txtFromDate.Text.ToString() == "" && txtEmpCode.Text.ToString() == "" && txtName.Text.ToString() == "")
{
gvManualAttnd.DataSource = dt;
gvManualAttnd.DataBind();
if (dt.Rows.Count != 0)
{
btnApprove.Enabled = true;
btnDelete.Enabled = true;
DropDownList ddl = (DropDownList)gvManualAttnd.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvManualAttnd.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvManualAttnd.PageIndex + 1).ToString();
Label lblcount = (Label)gvManualAttnd.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvManualAttnd.DataSource).Rows.Count.ToString() + " Records.";
if (gvManualAttnd.PageCount == 0)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvManualAttnd.PageIndex + 1 == gvManualAttnd.PageCount)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvManualAttnd.PageIndex == 0)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvManualAttnd.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvManualAttnd.PageSize * gvManualAttnd.PageIndex) + 1) + " to " + (gvManualAttnd.PageSize * (gvManualAttnd.PageIndex + 1));
gvManualAttnd.BottomPagerRow.Visible = true;
selectChk();
}
else
{
btnDelete.Enabled = false;
btnApprove.Enabled = false;
}
}
else
{
String[,] values =
{
{ "fromdate~" + txtFromDate.Text.Trim(), "D" },
{ "Todate~" + txtTodate.Text.Trim(), "D" },
{ "EmpID~" + txtEmpCode.Text.Trim(), "S" },
{ "Name~" + txtName.Text.Trim(), "S" }
};
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvManualAttnd.DataSource = _tempDT;
gvManualAttnd.DataBind();
if (_tempDT.Rows.Count != 0)
{
DropDownList ddl = (DropDownList)gvManualAttnd.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvManualAttnd.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvManualAttnd.PageIndex + 1).ToString();
Label lblcount = (Label)gvManualAttnd.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvManualAttnd.DataSource).Rows.Count.ToString() + " Records.";
if (gvManualAttnd.PageCount == 0)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvManualAttnd.PageIndex + 1 == gvManualAttnd.PageCount)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvManualAttnd.PageIndex == 0)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvManualAttnd.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvManualAttnd.PageSize * gvManualAttnd.PageIndex) + 1) + " to " + (gvManualAttnd.PageSize * (gvManualAttnd.PageIndex + 1));
gvManualAttnd.BottomPagerRow.Visible = true;
btnApprove.Enabled = true;
btnDelete.Enabled = true;
}
else
{
btnDelete.Enabled = false;
btnApprove.Enabled = false;
}
}
CommonValue();
}
catch (Exception ex)
{
}
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string strsql = "SELECT ESS_CO_RowID AS CO_ROWID,ESS_CO_EMPID CO_EMPID,'CO' AS LEAVECODE," +
"ESS_CO_REQUESTDT CO_REQUESTDT,CONVERT(VARCHAR(10),ESS_CO_FROMDT,105) CO_FROMDT," +
"ESS_CO_CD CO_CD,ESS_CO_RSNID CO_RSNID,ESS_CO_REMARK CO_REMARK,ESS_CO_SANCID CO_SANCID," +
"ESS_CO_SANCDT CO_SANCDT,ESS_CO_SANC_REMARK CO_SANC_REMARK," +
"ESS_CO_ORDER CO_ORDER,isnull(ESS_CO_STATUS,'N') CO_STATUS,ESS_CO_OLDSTATUS CO_OLDSTATUS," +
"ESS_CO_ISDELETED CO_ISDELETED,ESS_CO_DELETEDDATE CO_DELETEDDATE," +
"ESS_CO_DAYS CO_DAYS,CONVERT(VARCHAR(10),ESS_CO_LEAVEAGANISTDATE,105) ESS_CO_LEAVEAGANISTDATE" +
" FROM ESS_TA_CO WHERE ESS_CO_ISDELETED = 0 AND ESS_CO_STATUS = 'N'";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
da.SelectCommand.CommandTimeout = 0;
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtfromDate.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "CO_EMPID~" + txtfromDate.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvLVDetails.DataSource = _tempDT;
gvLVDetails.DataBind();
_tempDT = _sc.searchTable(values, dt);
gvLVDetails.DataSource = _tempDT;
gvLVDetails.DataBind();
DropDownList ddl = (DropDownList)gvLVDetails.BottomPagerRow.FindControl("ddlPageNo1");
for (int i = 1; i <= gvLVDetails.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvLVDetails.PageIndex + 1).ToString();
Label lblcount = (Label)gvLVDetails.BottomPagerRow.FindControl("lblTotal1");
lblcount.Text = ((DataTable)gvLVDetails.DataSource).Rows.Count.ToString() + " Records.";
if (gvLVDetails.PageCount == 0)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnPrevious1")).Enabled = false;
((Button)gvLVDetails.BottomPagerRow.FindControl("btnNext1")).Enabled = false;
}
if (gvLVDetails.PageIndex + 1 == gvLVDetails.PageCount)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnNext1")).Enabled = false;
}
if (gvLVDetails.PageIndex == 0)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnPrevious1")).Enabled = false;
}
((Label)gvLVDetails.BottomPagerRow.FindControl("lblShowing1")).Text = "Showing " + ((gvLVDetails.PageSize * gvLVDetails.PageIndex) + 1) + " to " + (gvLVDetails.PageSize * (gvLVDetails.PageIndex + 1));
gvLVDetails.BottomPagerRow.Visible = true;
}
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeMasterView");
}
}
private void BindgvPersonalisation()
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd;
if (ddlMode.SelectedValue == "Personalised")
{
//cmd = new SqlCommand("Select EPD_EMPID, EPD_FIRST_NAME + coalesce( EPD_MIDDLE_NAME, '' )+ EPD_LAST_NAME as Name from ENT_EMPLOYEE_PERSONAL_DTLS where EPD_PERSO_FLAG = 'P' or EPD_PERSO_FLAG is not null", conn);
cmd = new SqlCommand("Select EPD_EMPID, EPD_FIRST_NAME + coalesce( EPD_MIDDLE_NAME, '' )+ EPD_LAST_NAME as Name from ENT_EMPLOYEE_PERSONAL_DTLS EPD inner join ENT_EMPLOYEE_OFFICIAL_DTLS EOD on EPD.EPD_EMPID=EOD.EOD_EMPID where EOD.EOD_ACTIVE=1 and EPD_PERSO_FLAG = 'P' or EPD_PERSO_FLAG is not null", conn);
gvPersonalisation.Columns[0].Visible = false;
}
else if (ddlMode.SelectedValue == "NonPersonalised")
{
//cmd = new SqlCommand("Select EPD_EMPID, EPD_FIRST_NAME + coalesce( EPD_MIDDLE_NAME, '' )+ EPD_LAST_NAME as Name from ENT_EMPLOYEE_PERSONAL_DTLS where EPD_PERSO_FLAG <> 'P' or EPD_PERSO_FLAG is null", conn);
cmd = new SqlCommand("Select EPD_EMPID, EPD_FIRST_NAME + coalesce( EPD_MIDDLE_NAME, '' )+ EPD_LAST_NAME as Name from ENT_EMPLOYEE_PERSONAL_DTLS EPD inner join ENT_EMPLOYEE_OFFICIAL_DTLS EOD on EPD.EPD_EMPID=EOD.EOD_EMPID where EOD.EOD_ACTIVE=1 AND EPD_PERSO_FLAG <> 'P' or EPD_PERSO_FLAG is null", conn);
gvPersonalisation.Columns[0].Visible = true;
}
else
{
//cmd = new SqlCommand("Select EPD_EMPID, EPD_FIRST_NAME + coalesce( EPD_MIDDLE_NAME, '' )+ EPD_LAST_NAME as Name from ENT_EMPLOYEE_PERSONAL_DTLS", conn);
cmd = new SqlCommand("Select EPD_EMPID, EPD_FIRST_NAME + coalesce( EPD_MIDDLE_NAME, '' )+ EPD_LAST_NAME as Name from ENT_EMPLOYEE_PERSONAL_DTLS EPD inner join ENT_EMPLOYEE_OFFICIAL_DTLS EOD on EPD.EPD_EMPID=EOD.EOD_EMPID where EOD.EOD_ACTIVE=1", conn);
gvPersonalisation.Columns[0].Visible = true;
}
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtCompanyName.Text.ToString() == "" && txtCompanyID.Text.ToString() == "")
{
gvPersonalisation.DataSource = dt;
gvPersonalisation.DataBind();
//BindgvPersonalisation();
//cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "EPD_empid~" + txtCompanyID.Text.Trim(), "S" },
{ "Name~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvPersonalisation.DataSource = _tempDT;
gvPersonalisation.DataBind();
_tempDT = _sc.searchTable(values, dt);
gvPersonalisation.DataSource = _tempDT;
gvPersonalisation.DataBind();
}
DropDownList ddl = (DropDownList)gvPersonalisation.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvPersonalisation.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvPersonalisation.PageIndex + 1).ToString();
Label lblcount = (Label)gvPersonalisation.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvPersonalisation.DataSource).Rows.Count.ToString() + " Records.";
if (gvPersonalisation.PageCount == 0)
{
((Button)gvPersonalisation.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvPersonalisation.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvPersonalisation.PageIndex + 1 == gvPersonalisation.PageCount)
{
((Button)gvPersonalisation.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvPersonalisation.PageIndex == 0)
{
((Button)gvPersonalisation.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvPersonalisation.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvPersonalisation.PageSize * gvPersonalisation.PageIndex) + 1) + " to " + (gvPersonalisation.PageSize * (gvPersonalisation.PageIndex + 1));
((Label)gvPersonalisation.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvPersonalisation.PageSize * gvPersonalisation.PageIndex) + 1) + " to " + (((gvPersonalisation.PageSize * (gvPersonalisation.PageIndex + 1)) - 10) + gvPersonalisation.Rows.Count);
gvPersonalisation.BottomPagerRow.Visible = true;
//if (dt.Rows.Count != 0)
//{
// btnDelete.Enabled = true;
// btnSearch.Enabled = true;
//}
//else
//{
// btnDelete.Enabled = false;
// btnSearch.Enabled = false;
//}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "SACPersonalisation");
}
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
lblMessages.Text = "";
DataTable dt = GetOutPassData();
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "OP_EMPID~" + txtCompanyId.Text.Trim(), "S" },
{ "name~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvOutpass.DataSource = _tempDT;
gvOutpass.DataBind();
if (_tempDT.Rows.Count > 0)
{
btnDelete.Enabled = true;
btnSearch.Enabled = true;
DropDownList ddl = (DropDownList)gvOutpass.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvOutpass.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvOutpass.PageIndex + 1).ToString();
Label lblcount = (Label)gvOutpass.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvOutpass.DataSource).Rows.Count.ToString() + " Records.";
if (gvOutpass.PageCount == 0)
{
((Button)gvOutpass.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvOutpass.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvOutpass.PageIndex + 1 == gvOutpass.PageCount)
{
((Button)gvOutpass.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvOutpass.PageIndex == 0)
{
((Button)gvOutpass.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvOutpass.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvOutpass.PageSize * gvOutpass.PageIndex) + 1) + " to " + (((gvOutpass.PageSize * (gvOutpass.PageIndex + 1)) - 10) + gvOutpass.Rows.Count);
gvOutpass.BottomPagerRow.Visible = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
this.lblErrorEdit.Text = string.Empty;
clsEmployeeHierarchy objData = new clsEmployeeHierarchy();
DataTable dt = clsEmployeeHierarchyHandler.GetEmployeeManagerDetails("MngrHierarchy", objData);
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
gvEmpMgrHier.DataSource = dt;
gvEmpMgrHier.DataBind();
}
else
{
String[,] values =
{
{ "empid~" + txtCompanyId.Text.Trim(), "S" },
{ "EmpName~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvEmpMgrHier.DataSource = _tempDT;
gvEmpMgrHier.DataBind();
}
DropDownList ddl = (DropDownList)gvEmpMgrHier.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvEmpMgrHier.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvEmpMgrHier.PageIndex + 1).ToString();
Label lblcount = (Label)gvEmpMgrHier.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvEmpMgrHier.DataSource).Rows.Count.ToString() + " Records.";
if (gvEmpMgrHier.PageCount == 0)
{
((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmpMgrHier.PageIndex + 1 == gvEmpMgrHier.PageCount)
{
((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmpMgrHier.PageIndex == 0)
{
((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvEmpMgrHier.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmpMgrHier.PageSize * gvEmpMgrHier.PageIndex) + 1) + " to " + (((gvEmpMgrHier.PageSize * (gvEmpMgrHier.PageIndex + 1)) - 10) + gvEmpMgrHier.Rows.Count);
gvEmpMgrHier.BottomPagerRow.Visible = true;
if (dt.Rows.Count != 0)
{
btnDelete.Enabled = true;
btnSearch.Enabled = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeManagerHierarchy");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
string strsql = "";
if (Mstr_Con.State == ConnectionState.Closed)
{
Mstr_Con.Open();
}
strsql = "Select TC_TMP_CARD_ID,TC_EMPLOYEE_ID,CONVERT(VARCHAR(10),TC_ISSUEDT,103) AS TC_ISSUEDT ,CONVERT(VARCHAR(10),TC_RETURNDT,103) AS TC_RETURNDT,TC_REASON_ID FROM TA_TEMPCARD WHERE TC_ISDELETED=0";
SqlDataAdapter da = new SqlDataAdapter(strsql, Mstr_Con);
DataTable dt = new DataTable();
da.SelectCommand.CommandTimeout = 0;
da.Fill(dt);
if (Mstr_Con.State == ConnectionState.Open)
{
Mstr_Con.Close();
}
if (txtCompanyID.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
gvTempCard.DataSource = dt;
gvTempCard.DataBind();
}
else
{
String[,] values =
{
{ "TC_TMP_CARD_ID~" + txtCompanyID.Text.Trim(), "S" },
{ "TC_EMPLOYEE_ID~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvTempCard.DataSource = _tempDT;
gvTempCard.DataBind();
}
DropDownList ddl = (DropDownList)gvTempCard.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvTempCard.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvTempCard.PageIndex + 1).ToString();
Label lblcount = (Label)gvTempCard.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvTempCard.DataSource).Rows.Count.ToString() + " Records.";
if (gvTempCard.PageCount == 0)
{
((Button)gvTempCard.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvTempCard.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvTempCard.PageIndex + 1 == gvTempCard.PageCount)
{
((Button)gvTempCard.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvTempCard.PageIndex == 0)
{
((Button)gvTempCard.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvTempCard.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvTempCard.PageSize * gvTempCard.PageIndex) + 1) + " to " + (gvTempCard.PageSize * (gvTempCard.PageIndex + 1));
gvTempCard.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (Mstr_Con.State == ConnectionState.Open)
{
Mstr_Con.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "TemporaryCardViewMaster");
}
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
lblMessages.Text = "";
string strsql = " select MA_RECID, MA_EMPID , ent_employee_personal_dtls.Epd_First_Name + ' ' +ent_employee_personal_dtls.EPD_LAST_NAME as Name,convert(VARCHAR(20),MA_SWIPEFROMDATE,103) as FromDate, " +
" case " +
" when convert(VARCHAR(20),MA_SWIPETODATE,103)= convert(VARCHAR(20), " +
" MA_SWIPEFROMDATE,103) " +
" then '' else convert(VARCHAR(20),MA_SWIPETODATE,103) end as " +
" ToDate ,convert(char(5),MA_SWIPEFROMTIME,8) " +
" as [In_Time],convert(char(5),MA_SWIPETOTIME,8) as [Out_Time], " +
" MA_STATUS from TA_Manual_Att,ent_employee_personal_dtls " +
" inner join ENT_EMPLOYEE_OFFICIAL_DTLS " +
" on EPD_EMPID=EOD_EMPID " +
" where TA_Manual_Att.MA_EMPID=ent_employee_personal_dtls.epd_empid " +
" and MA_ISDELETED='0' and EPD_ISDELETED='0' and EOD_ACTIVE='1' ";
SqlDataAdapter da = new SqlDataAdapter(strsql, m_connectons);
DataTable dt = new DataTable();
da.Fill(dt);
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "MA_EMPID~" + txtCompanyId.Text.Trim(), "S" },
{ "name~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvManualAttnd.DataSource = _tempDT;
gvManualAttnd.DataBind();
if (_tempDT.Rows.Count > 0)
{
btnDelete.Enabled = true;
btnSearch.Enabled = true;
DropDownList ddl = (DropDownList)gvManualAttnd.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvManualAttnd.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvManualAttnd.PageIndex + 1).ToString();
Label lblcount = (Label)gvManualAttnd.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvManualAttnd.DataSource).Rows.Count.ToString() + " Records.";
if (gvManualAttnd.PageCount == 0)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvManualAttnd.PageIndex + 1 == gvManualAttnd.PageCount)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvManualAttnd.PageIndex == 0)
{
((Button)gvManualAttnd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvManualAttnd.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvManualAttnd.PageSize * gvManualAttnd.PageIndex) + 1) + " to " + (gvManualAttnd.PageSize * (gvManualAttnd.PageIndex + 1));
((Label)gvManualAttnd.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvManualAttnd.PageSize * gvManualAttnd.PageIndex) + 1) + " to " + (((gvManualAttnd.PageSize * (gvManualAttnd.PageIndex + 1)) - 10) + gvManualAttnd.Rows.Count);
gvManualAttnd.BottomPagerRow.Visible = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
}
protected void bindDataGrid()
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("USP_CARD_VIEW", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@strCommand", "SelectAll");
cmd.Parameters.Add("@nvarUserId", EmpId);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet dsTemplate = new DataSet();
da.Fill(dsTemplate);
conn.Close();
//drpCategory.DataSource = dsTemplate.Tables[1];
//drpCategory.DataTextField = "OCE_DESCRIPTION";
//drpCategory.DataValueField = "OCE_ID";
//drpCategory.DataBind();
if (txtCtlrID.Text.ToString() == "" && txtCtlrDesc.Text.ToString() == "")
{
gvCardView.DataSource = dsTemplate.Tables[0];
gvCardView.DataBind();
}
else
{
String[,] values =
{
{ "OCE_DESCRIPTION~" + txtCtlrID.Text.Trim(), "S" },
{ "nvarTemplateName~" + txtCtlrDesc.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dsTemplate.Tables[0]);
gvCardView.DataSource = _tempDT;
gvCardView.DataBind();
}
if (gvCardView.Rows.Count > 0)
{
DropDownList ddl = (DropDownList)gvCardView.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvCardView.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvCardView.PageIndex + 1).ToString();
Label lblcount = (Label)gvCardView.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvCardView.DataSource).Rows.Count.ToString() + " Records.";
if (gvCardView.PageCount == 0)
{
((Button)gvCardView.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvCardView.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvCardView.PageIndex + 1 == gvCardView.PageCount)
{
((Button)gvCardView.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvCardView.PageIndex == 0)
{
((Button)gvCardView.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvCardView.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvCardView.PageSize * gvCardView.PageIndex) + 1) + " to " + (gvCardView.PageSize * (gvCardView.PageIndex + 1));
gvCardView.BottomPagerRow.Visible = true;
btnDelete.Enabled = true;
btnSearch.Enabled = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "Card_View");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblMessages.Text = "";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("USP_AdminAnnouncement", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@strCommand", "Select");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (txtTodate.Text.ToString() == "" && txtFromDate.Text.ToString() == "")
{
gvAnnouncement.DataSource = dt;
gvAnnouncement.DataBind();
}
else
{
String[,] values =
{
{ "dtFromDate~" + txtFromDate.Text.Trim(), "S" },
{ "dtToDate~" + txtTodate.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvAnnouncement.DataSource = _tempDT;
gvAnnouncement.DataBind();
}
DropDownList ddl = (DropDownList)gvAnnouncement.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvAnnouncement.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvAnnouncement.PageIndex + 1).ToString();
Label lblcount = (Label)gvAnnouncement.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvAnnouncement.DataSource).Rows.Count.ToString() + " Records.";
if (gvAnnouncement.PageCount == 0)
{
((Button)gvAnnouncement.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvAnnouncement.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvAnnouncement.PageIndex + 1 == gvAnnouncement.PageCount)
{
((Button)gvAnnouncement.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvAnnouncement.PageIndex == 0)
{
((Button)gvAnnouncement.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvAnnouncement.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvAnnouncement.PageSize * gvAnnouncement.PageIndex) + 1) + " to " + (gvAnnouncement.PageSize * (gvAnnouncement.PageIndex + 1));
gvAnnouncement.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "AdminAnnouncement");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
string strsql = "";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
strsql = "EXEC Sp_InsertUnicode @strCommand ='View'";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
DataTable dt = new DataTable();
da.SelectCommand.CommandTimeout = 0;
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtCtlrID.Text.ToString() == "" && txtCtlrDesc.Text.ToString() == "")
{
gvView.DataSource = dt;
gvView.DataBind();
}
else
{
String[,] values =
{
{ "EMP_NAME~" + txtCtlrID.Text.Trim(), "S" },
{ "EPD_EMPID~" + txtCtlrDesc.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvView.DataSource = _tempDT;
gvView.DataBind();
}
DropDownList ddl = (DropDownList)gvView.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvView.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvView.PageIndex + 1).ToString();
Label lblcount = (Label)gvView.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvView.DataSource).Rows.Count.ToString() + " Records.";
if (gvView.PageCount == 0)
{
((Button)gvView.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvView.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvView.PageIndex + 1 == gvView.PageCount)
{
((Button)gvView.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvView.PageIndex == 0)
{
((Button)gvView.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvView.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvView.PageSize * gvView.PageIndex) + 1) + " to " + (gvView.PageSize * (gvView.PageIndex + 1));
gvView.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
private void BindgvEmpDetails()
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("getEmployeePersoDetails", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtEmpID.Text.ToString() == "" && txtEmpName.Text.ToString() == "")
{
gvEmpDetails.DataSource = dt;
gvEmpDetails.DataBind();
}
else
{
String[,] values =
{
{ "EPD_EMPID~" + txtEmpID.Text.Trim(), "S" },
{ "Emp_Name~" + txtEmpName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvEmpDetails.DataSource = _tempDT;
gvEmpDetails.DataBind();
}
if (dt.Rows.Count > 0)
{
DropDownList ddl = (DropDownList)gvEmpDetails.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvEmpDetails.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvEmpDetails.PageIndex + 1).ToString();
Label lblcount = (Label)gvEmpDetails.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvEmpDetails.DataSource).Rows.Count.ToString() + " Records.";
if (gvEmpDetails.PageCount == 0)
{
((Button)gvEmpDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvEmpDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmpDetails.PageIndex + 1 == gvEmpDetails.PageCount)
{
((Button)gvEmpDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEmpDetails.PageIndex == 0)
{
((Button)gvEmpDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvEmpDetails.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmpDetails.PageSize * gvEmpDetails.PageIndex) + 1) + " to " + (gvEmpDetails.PageSize * (gvEmpDetails.PageIndex + 1));
gvEmpDetails.BottomPagerRow.Visible = true;
}
}
catch (Exception ex)
{
}
}
public void bindDataGrid()
{
try
{
DataSet ds;
StringDictionary sd = new StringDictionary();
sd.Add("@cmd", "0");
ds = ExecuteSQL.ExecuteDataSet("PROC_ASSET_TAG_MASTER", sd);
if (ds.Tables.Count > 0)
{
if (txtTagNo.Text.ToString() == "" && txtTagStatus.Text.ToString() == "")
{
grdAsset.DataSource = ds.Tables[0];
grdAsset.DataBind();
}
else
{
DataTable _tempDT = new DataTable();
String[,] values =
{
{ "TagEPCID~" + txtTagNo.Text.Trim(), "S" },
{ "CurStatus~" + txtTagStatus.Text.Trim(), "S" }
};
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, ds.Tables[0]);
grdAsset.DataSource = _tempDT;
grdAsset.DataBind();
}
if (grdAsset.Rows.Count > 0)
{
DropDownList ddl = (DropDownList)grdAsset.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= grdAsset.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (grdAsset.PageIndex + 1).ToString();
Label lblcount = (Label)grdAsset.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)grdAsset.DataSource).Rows.Count.ToString() + " Records.";
if (grdAsset.PageCount == 0)
{
((Button)grdAsset.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)grdAsset.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (grdAsset.PageIndex + 1 == grdAsset.PageCount)
{
((Button)grdAsset.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (grdAsset.PageIndex == 0)
{
((Button)grdAsset.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)grdAsset.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((grdAsset.PageSize * grdAsset.PageIndex) + 1) + " to " + (grdAsset.PageSize * (grdAsset.PageIndex + 1));
grdAsset.BottomPagerRow.Visible = true;
}
}
}
catch (Exception ex)
{
lblMessages.Text = ex.Message;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
String _strWhereClause = "";
if (RBLDataType.SelectedValue.ToString() == "A")
{
_strWhereClause = "where AE.Event_Type in('01','02')";
}
if (RBLDataType.SelectedValue.ToString() == "01")
{
_strWhereClause = "where AE.Event_Type='01'";
}
if (RBLDataType.SelectedValue.ToString() == "02")
{
_strWhereClause = "where AE.Event_Type='02'";
}
string strsql = "select AE.Event_ID," + _strDecodeForEVENTTYPE + ",AE.Event_Datetime ," + //AE.Event_Trace,"+
"Case when AE.Event_Employee_Code=NULL then NULL " +
"else ( select EMP.EPD_FIRST_NAME+' '+EMP.EPD_LAST_NAME from ENT_EMPLOYEE_PERSONAL_DTLS EMP where EMP.EPD_EMPID=AE.Event_Employee_Code) " +
"End as Empname, " +
"Case when AE.Event_Employee_Code=NULL then NULL else AE.Event_Employee_Code END as Event_Employee_Code, " +
"Case When AE.Event_Reader_ID=NULL then NULL " +
"else ( Select READER_DESCRIPTION from ACS_READER where READER_ID=AE.Event_Reader_ID and CTLR_ID=AE.Event_Controller_ID) END as ReaderD ," +
"Case When AE.Event_Controller_ID=NULL then NULL " +
"else ( Select CTLR_DESCRIPTION from ACS_CONTROLLER where CTLR_ID= AE.Event_Controller_ID) END as CtrlD, " +
_strDecodeForCARDSTATUS + "," + _strDecodeForALARMTYPE + "," + _strDecodeForALARMACTION + " " +
" ,Event_Card_Code " +
"from ACS_Events AE " + _strWhereClause + " and Convert(varchar(20), AE.Event_Datetime, 101)= Convert(varchar(20), getdate(), 101) " +
"order by AE.Event_Datetime desc ";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.SelectCommand.CommandTimeout = 0;
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtUserID.Text.ToString() == "" && txtLevelID.Text.ToString() == "")
{
gvEvent.DataSource = dt;
gvEvent.DataBind();
}
else
{
String[,] values =
{
{ "Event_Employee_Code-" + txtUserID.Text.Trim(), "S" },
{ "Empname-" + txtLevelID.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvEvent.DataSource = _tempDT;
gvEvent.DataBind();
}
DropDownList ddl = (DropDownList)gvEvent.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvEvent.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvEvent.PageIndex + 1).ToString();
Label lblcount = (Label)gvEvent.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvEvent.DataSource).Rows.Count.ToString() + " Records.";
if (gvEvent.PageCount == 0)
{
((Button)gvEvent.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvEvent.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEvent.PageIndex + 1 == gvEvent.PageCount)
{
((Button)gvEvent.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvEvent.PageIndex == 0)
{
((Button)gvEvent.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvEvent.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEvent.PageSize * gvEvent.PageIndex) + 1) + " to " + (gvEvent.PageSize * (gvEvent.PageIndex + 1));
((Label)gvEvent.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEvent.PageSize * gvEvent.PageIndex) + 1) + " to " + (((gvEvent.PageSize * (gvEvent.PageIndex + 1)) - 10) + gvEvent.Rows.Count);
gvEvent.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "HolidayView");
}
}
protected void btnSearchDisbled_Click(object sender, EventArgs e)
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand("spGetEnableRecords", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.SelectCommand.CommandTimeout = 0;
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtRFIDDisabled.Text.ToString() == "" && txtemployeeIDDisabled.Text.ToString() == "" && txtVehregNoDisabled.Text == "" && txtVisitorIDDisabled.Text == "")
{
gvDisabled.DataSource = dt;
gvDisabled.DataBind();
}
else
{
String[,] values =
{
{ "rfid~" + txtRFIDDisabled.Text.Trim(), "S" },
{ "entityId~" + txtemployeeIDDisabled.Text.Trim(), "I" },
{ "entityId~" + txtVisitorIDDisabled.Text.Trim(), "I" },
{ "VehicleRegistrationNumber~" + txtVehregNoDisabled.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvDisabled.DataSource = _tempDT;
gvDisabled.DataBind();
}
DropDownList ddl = (DropDownList)gvDisabled.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvDisabled.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvDisabled.PageIndex + 1).ToString();
Label lblcount = (Label)gvDisabled.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvDisabled.DataSource).Rows.Count.ToString() + " Records.";
if (gvDisabled.PageCount == 0)
{
((Button)gvDisabled.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvDisabled.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvDisabled.PageIndex + 1 == gvDisabled.PageCount)
{
((Button)gvDisabled.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvDisabled.PageIndex == 0)
{
((Button)gvDisabled.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvDisabled.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvDisabled.PageSize * gvDisabled.PageIndex) + 1) + " to " + (gvDisabled.PageSize * (gvDisabled.PageIndex + 1));
((Label)gvDisabled.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvDisabled.PageSize * gvDisabled.PageIndex) + 1) + " to " + (((gvDisabled.PageSize * (gvDisabled.PageIndex + 1)) - 10) + gvDisabled.Rows.Count);
gvDisabled.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "VehicleAdministration");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
string strsql = "";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
//strsql = " select COMPANY_ID,COMPANY_NAME,COMPANY_ADDRESS,COMPANY_RO_ADDRESS1,COMPANY_RO_ADDRESS1," +
// " COMPANY_PHONE1,COMPANY_PHONE2,COMPANY_PIN,COMPANY_RO_PIN,COMPANY_RO_PHONE1,COMPANY_RO_PHONE2," +
// " COMPANY_CITY,COMPANY_RO_CITY,COMPANY_STATE,COMPANY_RO_STATE from ENT_COMPANY WHERE COMPANY_ISDELETED = '0'";
strsql = " select emp.EPD_EMPID as cc_emp_id ,emp.EPD_CARD_ID as CARD_CODE ,pin,usecount,ignore_apb, " +
" status,Convert(varchar,activation_date,103) as activation_date, " +
" Convert(varchar,expiry_date,103) as expiry_date FROM " +
" ENT_EMPLOYEE_PERSONAL_DTLS emp inner join " +
" ACS_CARD_CONFIG on(emp.EPD_EMPID=ACS_CARD_CONFIG.cc_emp_id) " +
" inner join ENT_EMPLOYEE_OFFICIAL_DTLS eod " +
" on emp.EPD_EMPID=eod.EOD_EMPID " +
" where emp.epd_isdeleted='0' and eod.EOD_ACTIVE='1' ";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
DataTable dt = new DataTable();
da.SelectCommand.CommandTimeout = 0;
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (textzoneid.Text.ToString() == "" && textzonename.Text.ToString() == "")
{
gvCardConfig.DataSource = dt;
gvCardConfig.DataBind();
}
else
{
String[,] values =
{
{ "cc_emp_id ~" + textzoneid.Text.Trim(), "S" },
{ "CARD_CODE ~" + textzonename.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvCardConfig.DataSource = _tempDT;
gvCardConfig.DataBind();
}
DropDownList ddl = (DropDownList)gvCardConfig.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvCardConfig.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvCardConfig.PageIndex + 1).ToString();
Label lblcount = (Label)gvCardConfig.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvCardConfig.DataSource).Rows.Count.ToString() + " Records.";
if (gvCardConfig.PageCount == 0)
{
((Button)gvCardConfig.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvCardConfig.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvCardConfig.PageIndex + 1 == gvCardConfig.PageCount)
{
((Button)gvCardConfig.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvCardConfig.PageIndex == 0)
{
((Button)gvCardConfig.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvCardConfig.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvCardConfig.PageSize * gvCardConfig.PageIndex) + 1) + " to " + (gvCardConfig.PageSize * (gvCardConfig.PageIndex + 1));
((Label)gvCardConfig.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvCardConfig.PageSize * gvCardConfig.PageIndex) + 1) + " to " + (((gvCardConfig.PageSize * (gvCardConfig.PageIndex + 1)) - 10) + gvCardConfig.Rows.Count);
gvCardConfig.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
lblMessages.Text = "";
string strsql = " select Rec_ID ,od_req_employee_id , " +
" convert(varchar(10),od_req_date,103) as od_req_date, " +
" convert(varchar(10),od_req_start_date,103) as od_req_start_date, " +
" convert(varchar(10),od_req_end_date,103) as od_req_end_date " +
" from TA_ODFDTR O INNER JOIN ENT_EMPLOYEE_PERSONAL_DTLS E " +
" ON E.EPD_EMPID=O.od_req_employee_id " +
" INNER JOIN ENT_EMPLOYEE_OFFICIAL_DTLS EOD " +
" ON E.EPD_EMPID= EOD.EOD_EMPID " +
" and OD_IsDeleted = 0 AND EPD_ISDELETED='0' and EOD_ACTIVE='1' ";
SqlDataAdapter daLVdetails = new SqlDataAdapter(strsql, AccessController.m_connecton);
DataTable dtLVdetails = new DataTable();
daLVdetails.Fill(dtLVdetails);
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "LVREQ_RECID~" + txtCompanyId.Text.Trim(), "S" },
{ "LVREQ_EMPID~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dtLVdetails);
gvLVDetails.DataSource = _tempDT;
gvLVDetails.DataBind();
if (_tempDT.Rows.Count > 0)
{
btnDelete.Enabled = true;
btnSearch.Enabled = true;
DropDownList ddl = (DropDownList)gvLVDetails.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvLVDetails.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvLVDetails.PageIndex + 1).ToString();
Label lblcount = (Label)gvLVDetails.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvLVDetails.DataSource).Rows.Count.ToString() + " Records.";
if (gvLVDetails.PageCount == 0)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvLVDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvLVDetails.PageIndex + 1 == gvLVDetails.PageCount)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvLVDetails.PageIndex == 0)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvLVDetails.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvLVDetails.PageSize * gvLVDetails.PageIndex) + 1) + " to " + (gvLVDetails.PageSize * (gvLVDetails.PageIndex + 1));
((Label)gvLVDetails.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvLVDetails.PageSize * gvLVDetails.PageIndex) + 1) + " to " + (((gvLVDetails.PageSize * (gvLVDetails.PageIndex + 1)) - 10) + gvLVDetails.Rows.Count);
gvLVDetails.BottomPagerRow.Visible = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
}
protected void cmdSearch_Click(object sender, EventArgs e)
{
string strsql = " SELECT LVREQ_RECID,LVREQ_EMPID,convert(varchar(10),LVREQ_REQDATE,103) as LVREQ_REQDATE, " +
" LVREQ_LV_ID, convert(varchar(10),LVREQ_FROMDATE,103) as LVREQ_FROMDATE,convert(varchar(10),LVREQ_TODATE,103) as LVREQ_TODATE, " +
" LVREQ_LVDAYS,LVTLEV_STATUS,LVREQ_SANCTION_EMPID FROM TA_LEAVE_REQ inner join ENT_EMPLOYEE_PERSONAL_DTLS e " +
" on LVREQ_EMPID=e.EPD_EMPID inner join ENT_EMPLOYEE_OFFICIAL_DTLS o " +
" on e.EPD_EMPID=o.EOD_EMPID where LVREQ_IsDeleted = '0' and EPD_ISDELETED='0' " +
" and EOD_ACTIVE='1' ORDER BY LVREQ_RECID DESC ";
SqlDataAdapter daLVdetails = new SqlDataAdapter(strsql, AccessController.m_connecton);
DataTable dtLVdetails = new DataTable();
daLVdetails.Fill(dtLVdetails);
if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "")
{
cmdReset_Click(sender, e);
}
else
{
String[,] values =
{
{ "LVREQ_EMPID~" + txtCompanyId.Text.Trim(), "S" },
{ "LVREQ_LV_ID~" + txtCompanyName.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dtLVdetails);
gvLVDetails.DataSource = _tempDT;
gvLVDetails.DataBind();
if (_tempDT.Rows.Count > 0)
{
DropDownList ddl = (DropDownList)gvLVDetails.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvLVDetails.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvLVDetails.PageIndex + 1).ToString();
Label lblcount = (Label)gvLVDetails.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvLVDetails.DataSource).Rows.Count.ToString() + " Records.";
if (gvLVDetails.PageCount == 0)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvLVDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvLVDetails.PageIndex + 1 == gvLVDetails.PageCount)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvLVDetails.PageIndex == 0)
{
((Button)gvLVDetails.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvLVDetails.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvLVDetails.PageSize * gvLVDetails.PageIndex) + 1) + " to " + (gvLVDetails.PageSize * (gvLVDetails.PageIndex + 1));
((Label)gvLVDetails.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvLVDetails.PageSize * gvLVDetails.PageIndex) + 1) + " to " + (((gvLVDetails.PageSize * (gvLVDetails.PageIndex + 1)) - 10) + gvLVDetails.Rows.Count);
gvLVDetails.BottomPagerRow.Visible = true;
btnDelete.Enabled = true;
btnSearch.Enabled = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string strsql = "select etc_rowid as rowid, etc_emp_id, EPD_FIRST_NAME +' '+ EPD_LAST_NAME as Name , etc_minimum_swipe,etc_shiftcode,etc_weekend, " +
" etc_weekoff,convert(varchar,etc_shift_start_date,103) as etc_shift_start_date " +
" from TNA_EMPLOYEE_TA_CONFIG conf inner join ENT_EMPLOYEE_PERSONAL_DTLS emp " +
" on conf.ETC_EMP_ID=emp.EPD_EMPID inner join ENT_EMPLOYEE_OFFICIAL_DTLS eop " +
" on emp.EPD_EMPID=eop.EOD_EMPID where ETC_ISDELETED='0' and emp.EPD_ISDELETED='0' and eop.EOD_ACTIVE='1' ";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
da.SelectCommand.CommandTimeout = 0;
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (textempid.Text.ToString() == "" && textshiftid.Text.ToString() == "")
{
bindDataGrid();
}
else
{
String[,] values =
{
{ "etc_emp_id~" + textempid.Text.Trim(), "S" },
{ "etc_shiftcode~" + textshiftid.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvTimeAttendanceView.DataSource = _tempDT;
gvTimeAttendanceView.DataBind();
}
DropDownList ddl = (DropDownList)gvTimeAttendanceView.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvTimeAttendanceView.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvTimeAttendanceView.PageIndex + 1).ToString();
Label lblcount = (Label)gvTimeAttendanceView.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvTimeAttendanceView.DataSource).Rows.Count.ToString() + " Records.";
if (gvTimeAttendanceView.PageCount == 0)
{
((Button)gvTimeAttendanceView.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvTimeAttendanceView.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvTimeAttendanceView.PageIndex + 1 == gvTimeAttendanceView.PageCount)
{
((Button)gvTimeAttendanceView.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvTimeAttendanceView.PageIndex == 0)
{
((Button)gvTimeAttendanceView.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvTimeAttendanceView.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvTimeAttendanceView.PageSize * gvTimeAttendanceView.PageIndex) + 1) + " to " + (gvTimeAttendanceView.PageSize * (gvTimeAttendanceView.PageIndex + 1));
((Label)gvTimeAttendanceView.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvTimeAttendanceView.PageSize * gvTimeAttendanceView.PageIndex) + 1) + " to " + (((gvTimeAttendanceView.PageSize * (gvTimeAttendanceView.PageIndex + 1)) - 10) + gvTimeAttendanceView.Rows.Count);
gvTimeAttendanceView.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeTimeAttendanceView");
}
}
protected void bindDataGrid()
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "USP_Backup";
cmd.Connection = conn;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@strCommand", "selectAll");
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet dt = new DataSet();
da.Fill(dt);
if (txtTodate.Text.ToString() == "" && txtDbName.Text.ToString() == "")
{
gvBackupData.DataSource = dt.Tables[0];
gvBackupData.DataBind();
}
else
{
String[,] values =
{
{ "dbName~" + txtDbName.Text.Trim(), "S" },
{ "createdDate~" + txtTodate.Text.Trim(), "D" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt.Tables[0]);
gvBackupData.DataSource = _tempDT;
gvBackupData.DataBind();
}
if (dt.Tables[0].Rows.Count != 0)
{
// btnApprove.Enabled = true;
// btnDelete.Enabled = true;
DropDownList ddl = (DropDownList)gvBackupData.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvBackupData.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvBackupData.PageIndex + 1).ToString();
Label lblcount = (Label)gvBackupData.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvBackupData.DataSource).Rows.Count.ToString() + " Records.";
if (gvBackupData.PageCount == 0)
{
((Button)gvBackupData.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvBackupData.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvBackupData.PageIndex + 1 == gvBackupData.PageCount)
{
((Button)gvBackupData.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvBackupData.PageIndex == 0)
{
((Button)gvBackupData.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvBackupData.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvBackupData.PageSize * gvBackupData.PageIndex) + 1) + " to " + (gvBackupData.PageSize * (gvBackupData.PageIndex + 1));
gvBackupData.BottomPagerRow.Visible = true;
}
else
{
// btnDelete.Enabled = false;
btnRestore.Enabled = false;
}
if (dt.Tables[1].Rows.Count > 0)
{
Label2.Text = "Last restored backup file - " + dt.Tables[1].Rows[0]["DbName"] + " Filepath: " + dt.Tables[1].Rows[0]["DbPath"] + " at " + dt.Tables[1].Rows[0]["RestoreTime"] + " by " + dt.Tables[1].Rows[0]["UserId"];
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
//string strsql = "select id,vehicleName,entityId,VehicleRegistrationNumber,rfId,CONVERT(varchar(10),enrollmentDate,103) as enrollmentDate,CONVERT(varchar(10),rfidValidityDate,103) as rfidValidityDate from veh_vehicleEnrollment where isdeleted=0";
string strsql = "select * from veh_controller where isdeleted=0";
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(strsql, conn);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.SelectCommand.CommandTimeout = 0;
DataTable dt = new DataTable();
da.Fill(dt);
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (txtControllerIDSerch.Text.ToString() == "" && txtControllerName.Text.ToString() == "")
{
gvController.DataSource = dt;
gvController.DataBind();
}
else
{
String[,] values =
{
{ "controllerDescription~" + txtControllerName.Text.Trim(), "S" },
{ "controllerID~" + txtControllerIDSerch.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvController.DataSource = _tempDT;
gvController.DataBind();
}
DropDownList ddl = (DropDownList)gvController.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvController.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvController.PageIndex + 1).ToString();
Label lblcount = (Label)gvController.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvController.DataSource).Rows.Count.ToString() + " Records.";
if (gvController.PageCount == 0)
{
((Button)gvController.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvController.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvController.PageIndex + 1 == gvController.PageCount)
{
((Button)gvController.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvController.PageIndex == 0)
{
((Button)gvController.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
//((Label)gvController.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvController.PageSize * gvController.PageIndex) + 1) + " to " + (gvController.PageSize * (gvController.PageIndex + 1));
((Label)gvController.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvController.PageSize * gvController.PageIndex) + 1) + " to " + (((gvController.PageSize * (gvController.PageIndex + 1)) - 10) + gvController.Rows.Count);
gvController.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "VehicleErollment");
}
}
public void bindDataGrid()
{
DataSet ds;
StringDictionary sd = new StringDictionary();
sd.Add("@cmd", "0");
ds = ExecuteSQL.ExecuteDataSet("PROC_ASSET_MASTER", sd);
if (ds.Tables.Count > 0)
{
if (txtAssetCode.Text.ToString() == "" && txtAssetDescription.Text.ToString() == "")
{
grdAsset.DataSource = ds.Tables[0];
grdAsset.DataBind();
}
else
{
DataTable _tempDT = new DataTable();
String[,] values =
{
{ "Asset_Code~" + txtAssetCode.Text.Trim(), "S" },
{ "Asset_Desc~" + txtAssetDescription.Text.Trim(), "S" }
};
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, ds.Tables[0]);
grdAsset.DataSource = _tempDT;
grdAsset.DataBind();
}
if (grdAsset.Rows.Count > 0)
{
DropDownList ddl = (DropDownList)grdAsset.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= grdAsset.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (grdAsset.PageIndex + 1).ToString();
Label lblcount = (Label)grdAsset.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)grdAsset.DataSource).Rows.Count.ToString() + " Records.";
if (grdAsset.PageCount == 0)
{
((Button)grdAsset.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)grdAsset.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (grdAsset.PageIndex + 1 == grdAsset.PageCount)
{
((Button)grdAsset.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (grdAsset.PageIndex == 0)
{
((Button)grdAsset.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)grdAsset.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((grdAsset.PageSize * grdAsset.PageIndex) + 1) + " to " + (grdAsset.PageSize * (grdAsset.PageIndex + 1));
grdAsset.BottomPagerRow.Visible = true;
}
ddlAstType.DataSource = ds.Tables[1];
ddlAstType.DataValueField = "CODE";
ddlAstType.DataTextField = "VALUE";
ddlAstType.DataBind();
ddlAstType.Items.Insert(0, new ListItem("Select Type", "0"));
ddlAstType.SelectedIndex = 0;
ddlEditType.DataSource = ds.Tables[1];
ddlEditType.DataValueField = "CODE";
ddlEditType.DataTextField = "VALUE";
ddlEditType.DataBind();
ddlEditType.Items.Insert(0, new ListItem("Select Type", "0"));
}
}