//For employees
protected void chkCtrlEmp_CheckedChanged(object sender, EventArgs e)
{
foreach (GridViewRow row in grid_Employee.Rows)
{
CheckBox ck = ((CheckBox)row.FindControl("chkCtrlEmp"));
EmpView _EmpView = new EmpView();
_EmpView.EmpID = Convert.ToInt32(row.Cells[1].Text);
_EmpView.EmpName = row.Cells[3].Text;
if (ck.Checked)
{
if (SelectedEmps.Where(aa => aa.EmpID == _EmpView.EmpID).Count() == 0)
{
SelectedEmps.Add(_EmpView);
}
}
else
{
if (SelectedEmps.Where(aa => aa.EmpID == _EmpView.EmpID).Count() > 0)
{
var _emp = SelectedEmps.Where(aa => aa.EmpID == _EmpView.EmpID).First();
SelectedEmps.Remove(_emp);
}
}
}
}
void populateEmpview()
{
DataTable dt = new DataTable();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
string sqlString = "SELECT Emp_ID,First_Name,Last_Name,Email,Mobile_number,DOB FROM Employee_Master_Table";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlString, con);
sda.Fill(dt);
}
if (dt.Rows.Count > 0)
{
EmpView.DataSource = dt;
EmpView.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
EmpView.DataSource = dt;
EmpView.DataBind();
EmpView.Rows[0].Cells.Clear();
EmpView.Rows[0].Cells.Add(new TableCell());
EmpView.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count;
EmpView.Rows[0].Cells[0].Text = "No Data Found";
EmpView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
void populateEmpview()
{
DataTable dt = new DataTable();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
string sqlString = "SELECT Emp_ID,User_Name,Date,Start_Time,End_Time,Project_Name FROM Time_sheet T JOIN Project_Master_table P on E.Project_ID = P.Project_ID JOIN Employee_Master_Table E on E.Emp_ID =";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlString, con);
sda.Fill(dt);
}
if (dt.Rows.Count > 0)
{
EmpView.DataSource = dt;
EmpView.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
EmpView.DataSource = dt;
EmpView.DataBind();
EmpView.Rows[0].Cells.Clear();
EmpView.Rows[0].Cells.Add(new TableCell());
EmpView.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count;
EmpView.Rows[0].Cells[0].Text = "No Data Found";
EmpView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
void populateProject()
{
DataTable dt = new DataTable();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
string sqlString = "SELECT Project_ID,Project_Name,Project_Description FROM Project_Master_table";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sqlString, con);
sda.Fill(dt);
}
if (dt.Rows.Count > 0)
{
EmpView.DataSource = dt;
EmpView.DataBind();
}
else
{
dt.Rows.Add(dt.NewRow());
EmpView.DataSource = dt;
EmpView.DataBind();
EmpView.Rows[0].Cells.Clear();
EmpView.Rows[0].Cells.Add(new TableCell());
EmpView.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count;
EmpView.Rows[0].Cells[0].Text = "No Data Found";
EmpView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
public ActionResult edit(EmpView empv)
{
if (ModelState.IsValid)
{
//Update
}
return(RedirectToAction("index"));
}
public ActionResult get(int id)
{
EmpModel emp = _dbcomp.GetEmp(id);
MapperConfiguration config = new MapperConfiguration(m => m.CreateMap <EmpModel, EmpView>());
var mapper = config.CreateMapper();
EmpView empv = new EmpView();
mapper.Map(emp, empv);
return(View("Emp", empv));
}
public ActionResult getedit(int id)
{
EmpModel emp = _dbcomp.GetEmp(id);
MapperConfiguration config = new MapperConfiguration(m => m.CreateMap <EmpModel, EmpView>());
var mapper = config.CreateMapper();
EmpView empv = new EmpView();
mapper.Map(emp, empv);
ViewBag.genderlist = new SelectList(empv.genderList, "id", "type", 2);
return(View("Empedit", empv));
}
public ActionResult add(EmpView empv)
{
if (ModelState.IsValid)
{
//Save
MapperConfiguration config = new MapperConfiguration(m => m.CreateMap <EmpView, EmpModel>());
var mapper = config.CreateMapper();
EmpModel emp = new EmpModel();
mapper.Map(empv, emp);
_dbcomp.AddEmp(emp);
}
else
{
var res = new ViewResult()
{
ViewName = "Error"
};
StringBuilder ss = new StringBuilder();
foreach (var modelError in ModelState)
{
string propertyName = modelError.Key;
if (modelError.Value.Errors.Count > 0)
{
foreach (var err in modelError.Value.Errors)
{
ss.Append("\n" + err.ErrorMessage);
}
}
}
res.TempData["error"] = ss.ToString();
return(res);
}
return(RedirectToAction("index"));
}
internal static bool IsValidDailyOT(IEnumerable <ViewDailyOTEntry> TempattOts, EmpView emp)
{
bool check = false;
foreach (var item in TempattOts)
{
if (item.DutyCode == "D")
{
if (emp.CalculateNOT == true)
{
if (emp.PerDayOTStartLimitHour > 0)
{
//int ClaimOT = (int)(item.ApprovedOTMin / 60);
int ClaimOT = (int)(item.ApprovedOTMin);
if (ClaimOT >= emp.PerDayOTStartLimitHour && ClaimOT <= emp.PerDayOTEndLimitHour)
{
}
else
{
check = true;
}
}
}
}
else if (item.DutyCode == "R")
{
if (emp.CalculateRestOT == true)
{
if (emp.PerDayROTStartLimitHour > 0)
{
int ClaimOT = (int)(item.ApprovedOTMin / 60);
if (ClaimOT >= emp.PerDayROTStartLimitHour && ClaimOT <= emp.PerDayROTEndLimitHour)
{
}
else
{
check = true;
}
}
}
}
else if (item.DutyCode == "G")
{
if (emp.CalculateGZOT == true)
{
if (emp.PerDayGOTStartLimitHour > 0)
{
int ClaimOT = (int)(item.ApprovedOTMin / 60);
if (ClaimOT >= emp.PerDayGOTStartLimitHour && ClaimOT <= emp.PerDayGOTEndLimitHour)
{
}
else
{
check = true;
}
}
}
}
}
return(check);
}
public VMAttMnDataPer processPermanentMonthlyAttSingle(DateTime startDate, DateTime endDate, EmpView _Emp, List <AttData> _EmpAttData)
{
//Get Attendance data of employee according to selected month
_attMonth = new VMAttMnDataPer();
try
{
EmpAttData = _EmpAttData;
}
catch (Exception ex)
{
}
string EmpMonth = _Emp.EmpID + endDate.Date.Month.ToString();
//Check for already processed data
_attMonth.StartDate = startDate;
_attMonth.EndDate = endDate;
TDays = 0;
WorkDays = 0;
PresentDays = 0;
AbsentDays = 0;
LeaveDays = 0;
RestDays = 0;
GZDays = 0;
EarlyIn = 0;
EarlyOut = 0;
LateIn = 0;
LateOut = 0;
WorkTime = 0;
NOT = 0;
GOT = 0;
TDays = Convert.ToByte((endDate - startDate).Days + 1);
CalculateMonthlyAttendanceSheet(EmpAttData);
_attMonth.Period = endDate.Date.Month.ToString() + endDate.Date.Year.ToString();
_attMonth.EmpMonth = EmpMonth;
_attMonth.EmpID = _Emp.EmpID;
_attMonth.EmpNo = _Emp.EmpNo;
_attMonth.EmpName = _Emp.EmpName;
return(_attMonth);
}
public AttMnDataPer processPermanentMonthlyAttSingle(DateTime startDate, DateTime endDate, EmpView _Emp, List <AttData> _EmpAttData)
{
//Get Attendance data of employee according to selected month
_attMonth = new AttMnDataPer();
try
{
EmpAttData = _EmpAttData;
}
catch (Exception ex)
{
}
string EmpMonth = _Emp.EmpID + endDate.Date.Month.ToString();
//Check for already processed data
_attMonth.StartDate = startDate;
_attMonth.EndDate = endDate;
_attMonth.PreDays = 0;
_attMonth.WorkDays = 0;
_attMonth.AbDays = 0;
_attMonth.LeaveDays = 0;
_attMonth.OfficialDutyDays = 0;
_attMonth.ExpectedWrkTime = 0;
_attMonth.GZDays = 0;
_attMonth.RestDays = 0;
_attMonth.TEarlyIn = 0;
_attMonth.TEarlyOut = 0;
_attMonth.TGZOT = 0;
_attMonth.TLateIn = 0;
_attMonth.TLateOut = 0;
_attMonth.TNOT = 0;
_attMonth.TotalDays = 0;
_attMonth.TWorkTime = 0;
_attMonth.OT1 = 0;
_attMonth.OT2 = 0;
_attMonth.OT3 = 0;
_attMonth.OT4 = 0;
_attMonth.OT5 = 0;
_attMonth.OT6 = 0;
_attMonth.OT7 = 0;
_attMonth.OT8 = 0;
_attMonth.OT9 = 0;
_attMonth.OT10 = 0;
_attMonth.OT11 = 0;
_attMonth.OT12 = 0;
_attMonth.OT13 = 0;
_attMonth.OT14 = 0;
_attMonth.OT15 = 0;
_attMonth.OT16 = 0;
_attMonth.OT17 = 0;
_attMonth.OT18 = 0;
_attMonth.OT19 = 0;
_attMonth.OT20 = 0;
_attMonth.OT21 = 0;
_attMonth.OT22 = 0;
_attMonth.OT23 = 0;
_attMonth.OT24 = 0;
_attMonth.OT25 = 0;
_attMonth.OT26 = 0;
_attMonth.OT27 = 0;
_attMonth.OT28 = 0;
_attMonth.OT29 = 0;
_attMonth.OT30 = 0;
_attMonth.OT31 = 0;
TDays = 0;
WorkDays = 0;
PresentDays = 0;
AbsentDays = 0;
LeaveDays = 0;
RestDays = 0;
GZDays = 0;
EarlyIn = 0;
EarlyOut = 0;
LateIn = 0;
LateOut = 0;
WorkTime = 0;
NOT = 0;
GOT = 0;
TDays = Convert.ToByte((endDate - startDate).Days + 1);
CalculateMonthlyAttendanceSheet(EmpAttData);
_attMonth.Period = endDate.Date.Month.ToString() + endDate.Date.Year.ToString();
_attMonth.EmpMonth = EmpMonth;
_attMonth.EmpID = _Emp.EmpID;
_attMonth.EmpNo = _Emp.EmpNo;
_attMonth.EmpName = _Emp.EmpName;
return(_attMonth);
}
public ActionResult addnew()
{
EmpView empv = new EmpView();
return(View("Empedit", empv));
}
