protected void ddlShowDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
grid1.DataSource = lstLeaveAssignedRecord;
grid1.DataBind();
}
protected void ddlShowDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
grid1.DataSource = lstLeaveAssignedRecord;
grid1.DataBind();
}
protected void lkbEditLeaveAssinged_Click(object sender, EventArgs e)
{
popupEditLeaveAssigned.Show();
LinkButton b = (LinkButton)sender;
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
int Id = Convert.ToInt32(b.CommandArgument);
Session["empId"] = Id;
var y = lstLeaveAssignedRecord.Select(x => x).Where(d => d.EmployeeId == Id).FirstOrDefault();
EditgvLeaves.DataSource = y.lstAssignedRecord;
EditgvLeaves.DataBind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
List <LeaveAssignedRecord> lstLeaveAssignedRecord = new List <LeaveAssignedRecord>();
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DataSet ds;
int leaveId;
LeaveAssignedPerSession objLeaveAssignedPerSession = new LeaveAssignedPerSession();
ManageReports objManageReports = new ManageReports();
foreach (RepeaterItem i in EditgvLeaves.Items)
{
TextBox txtLeaveCount = (TextBox)i.FindControl("txtLeaveCount");
Label txtLeaveName = (Label)i.FindControl("txtLeave");
string leaveName = txtLeaveName.Text;
List <SqlParameter> lstParams = new List <SqlParameter>();
lstParams.Add(new SqlParameter("@name", leaveName));
string query = "Select Id from tblTypeOfLeave where Name = @name";
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstParams);
leaveId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
DateTime SessionStartDate, SessionEndDate;
if (DateTime.Now.Month >= 8)
{
SessionStartDate = new DateTime(DateTime.Now.Year, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year + 1, 07, 31);
}
else
{
SessionStartDate = new DateTime(DateTime.Now.Year - 1, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year, 07, 31);
}
objLeaveAssignedPerSession.EmployeeId = Convert.ToInt32(Session["empId"]);
objLeaveAssignedPerSession.leaveCount = Convert.ToInt32(txtLeaveCount.Text);
objLeaveAssignedPerSession.leaveType = leaveId;
objManageReports.UpdateLeavesAssignedPerSessionEmployeeWise(objLeaveAssignedPerSession, SessionStartDate, SessionEndDate);
}
popupEditLeaveAssigned.Hide();
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports1 = new ManageReports();
lstLeaveAssignedRecord = objManageReports1.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
//grid1.DataSource = lstLeaveAssignedRecord;
//grid1.DataBind();
}
protected void lkbEditLeaveAssinged_Click(object sender, EventArgs e)
{
popupEditLeaveAssigned.Show();
LinkButton b = (LinkButton)sender;
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
int Id = Convert.ToInt32(b.CommandArgument);
Session["empId"] = Id;
var y = lstLeaveAssignedRecord.Select(x => x).Where(d => d.EmployeeId == Id).FirstOrDefault();
EditgvLeaves.DataSource = y.lstAssignedRecord;
EditgvLeaves.DataBind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
List<LeaveAssignedRecord> lstLeaveAssignedRecord = new List<LeaveAssignedRecord>();
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DataSet ds;
int leaveId;
LeaveAssignedPerSession objLeaveAssignedPerSession = new LeaveAssignedPerSession();
ManageReports objManageReports = new ManageReports();
foreach (RepeaterItem i in EditgvLeaves.Items)
{
TextBox txtLeaveCount = (TextBox)i.FindControl("txtLeaveCount");
Label txtLeaveName = (Label)i.FindControl("txtLeave");
string leaveName = txtLeaveName.Text;
List<SqlParameter> lstParams = new List<SqlParameter>();
lstParams.Add(new SqlParameter("@name", leaveName));
string query = "Select Id from tblTypeOfLeave where Name = @name";
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstParams);
leaveId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
DateTime SessionStartDate, SessionEndDate;
if (DateTime.Now.Month >= 8)
{
SessionStartDate = new DateTime(DateTime.Now.Year, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year+1, 07, 31);
}
else
{
SessionStartDate = new DateTime(DateTime.Now.Year-1, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year, 07, 31);
}
objLeaveAssignedPerSession.EmployeeId = Convert.ToInt32(Session["empId"]);
objLeaveAssignedPerSession.leaveCount = Convert.ToInt32(txtLeaveCount.Text);
objLeaveAssignedPerSession.leaveType = leaveId;
objManageReports.UpdateLeavesAssignedPerSessionEmployeeWise(objLeaveAssignedPerSession, SessionStartDate,SessionEndDate);
}
popupEditLeaveAssigned.Hide();
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports1 = new ManageReports();
lstLeaveAssignedRecord = objManageReports1.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
//grid1.DataSource = lstLeaveAssignedRecord;
//grid1.DataBind();
}
