public ATTENDANCE_IMPORT GetAttenancedate(int id)
{
using (var _dbcontext = new PayRollEntities())
{
return(_dbcontext.ATTENDANCE_IMPORT.Where(x => x.Id == id).FirstOrDefault());
}
}
public bool InsertProcessData(ProcessedData p)
{
using (var _dbcontext = new PayRollEntities())
{
var pd = (from d in _dbcontext.ProcessedData where d.Date == DbFunctions.TruncateTime(p.Date) && d.EmpCode == p.EmpCode select d).FirstOrDefault();
if (pd != null)
{
pd.HoursWorked = p.HoursWorked;
pd.ShiftCount = p.ShiftCount;
pd.Status = p.Status;
pd.ActualSalary = p.ActualSalary;
pd.AduitingSalary = p.AduitingSalary;
_dbcontext.Entry(pd).State = EntityState.Modified;
_dbcontext.SaveChanges();
}
else
{
_dbcontext.ProcessedData.Add(p);
_dbcontext.SaveChanges();
}
return(true);
}
}
public EmployeeViewModel GetEmployee(int EMPID)
{
using (var _dbcontext = new PayRollEntities())
{
return((from e in _dbcontext.EMPLOYEEs
where e.EMPID == EMPID
select new EmployeeViewModel()
{
EMPID = e.EMPID,
EMPCODE = e.EMPCODE,
MACCODE = e.MACCODE,
EMP_NAME = e.EMP_NAME,
FATHER_NAME = e.FATHER_NAME,
MOTHER_NAME = e.MOTHER_NAME,
DOB = e.DOB,
DOJ = e.DOJ,
MARITAL_STATUS = e.MARITAL_STATUS,
GENDER = e.GENDER,
ACTUAL_SALARY = e.ACTUAL_SALARY,
ADUITING_SALARY = e.ADUITING_SALARY,
UNITID = e.UNITID,
DEPARTMENTID = e.DEPARTMENTID,
DESIGNATIONID = e.DESIGNATIONID,
WAGES_TYPEID = e.WAGES_TYPEID,
IsActive = (bool)e.IsActive,
IsDeleted = (bool)e.IsDeleted,
Mode = e.Mode,
IMAGE = e.IMAGE
}).FirstOrDefault());
}
}
public bool UpdateEmployee(EMPLOYEE model)
{
using (var _dbcontext = new PayRollEntities())
{
var emp = (from e in _dbcontext.EMPLOYEEs where e.EMPID == model.EMPID select e).FirstOrDefault();
emp.ACTUAL_SALARY = model.ACTUAL_SALARY;
emp.ADUITING_SALARY = model.ADUITING_SALARY;
emp.DEPARTMENTID = model.DEPARTMENTID;
emp.DESIGNATIONID = model.DESIGNATIONID;
emp.DOB = model.DOB;
emp.DOJ = model.DOJ;
emp.EMPCODE = model.EMPCODE;
emp.EMP_NAME = model.EMP_NAME;
emp.FATHER_NAME = model.FATHER_NAME;
emp.MOTHER_NAME = model.MOTHER_NAME;
emp.GENDER = model.GENDER;
emp.MARITAL_STATUS = model.MARITAL_STATUS;
emp.MACCODE = model.MACCODE;
emp.UNITID = model.UNITID;
emp.WAGES_TYPEID = model.WAGES_TYPEID;
emp.ModifiedBy = model.ModifiedBy;
emp.ModifiedDate = model.ModifiedDate;
emp.Mode = model.Mode;
emp.IsActive = model.IsActive;
emp.IsDeleted = model.IsDeleted;
emp.IMAGE = model.IMAGE != "" ? model.IMAGE : emp.IMAGE;
_dbcontext.Entry(emp).State = EntityState.Modified;
_dbcontext.SaveChanges();
return(true);
}
}
public List <EmployeeViewModel> ListEmployee(filter f)
{
using (var _dbcontext = new PayRollEntities())
{
SqlConnection con = _dbcontext.Database.Connection as SqlConnection;
var eMPLOYEEData = con.Query <EMPLOYEE>("[dbo].[SP_GetEmployeelist] @Mode,@UNITID,@DEPARTMENTID,@DESIGNATIONID,@WAGES_TYPEID", new { Mode = f.Mode, UNITID = f.UNIT, DEPARTMENTID = f.Department, DESIGNATIONID = f.DESIGNATION, WAGES_TYPEID = f.Wagetype });
var Emp = (from e in eMPLOYEEData
join dep in _dbcontext.Departments on e.DEPARTMENTID equals dep.DepId
join des in _dbcontext.Designations on e.DESIGNATIONID equals des.DegId
join u in _dbcontext.UNITs on e.UNITID equals u.UnitId
join W in _dbcontext.WAGESTYPEs on e.WAGES_TYPEID equals W.WGId
select new EmployeeViewModel()
{
EMPID = e.EMPID,
EMPCODE = e.EMPCODE,
MACCODE = e.MACCODE,
EMP_NAME = e.EMP_NAME,
FATHER_NAME = e.FATHER_NAME,
MOTHER_NAME = e.MOTHER_NAME,
DOB = e.DOB,
DOJ = e.DOJ,
MARITAL_STATUS = e.MARITAL_STATUS,
GENDER = e.GENDER,
ACTUAL_SALARY = e.ACTUAL_SALARY,
ADUITING_SALARY = e.ADUITING_SALARY,
UNIT = u.Name,
DEPARTMENT = dep.DEPT,
DESIGNATION = des.DESG,
WAGESTYPE = W.Type
}).OrderBy(x => x.EMPCODE).ToList();
return(Emp);
}
}
public List <ShiftMaster> GetShiftMasterData(int WGID)
{
using (var _dbcontext = new PayRollEntities())
{
var res = (from sm in _dbcontext.ShiftMaster where sm.WGID == WGID select sm).ToList();
return(res);
}
}
public List <ATTENDANCE_IMPORT> GetAttenanceReport()
{
using (var _dbcontext = new PayRollEntities())
{
var res = (from ai in _dbcontext.ATTENDANCE_IMPORT select ai).ToList();
return(res);
}
}
public override void InitGridControlDataSource()
{
PayRollEntities entity = (PayRollEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity;
BindingSource bds = new BindingSource();
bds.DataSource = entity.EmployeePayRollsList;
DataSource = bds;
}
public WAGESTYPE GetWAGESTYPE(int WGID)
{
using (var _dbcontext = new PayRollEntities())
{
var res = (from w in _dbcontext.WAGESTYPEs where w.WGId == WGID select w).FirstOrDefault();
return(res);
}
}
public IEnumerable <SelectListItem> ListDesignation()
{
using (var context = new PayRollEntities())
{
IEnumerable <SelectListItem> listData;
listData = context.Database.SqlQuery <SelectListItem>("select Convert(nvarchar(10),DegId) as Value, DESG as Text from Designation where IsActive=1").ToList();
return(listData);
}
}
public IEnumerable <SelectListItem> ListWAGESTYPE()
{
using (var context = new PayRollEntities())
{
IEnumerable <SelectListItem> listData;
listData = context.Database.SqlQuery <SelectListItem>("select Convert(nvarchar(10),WGId) as Value, Type as Text from WAGESTYPE where IsActive=1").ToList();
return(listData);
}
}
public List <SalaryData> GetSalaryData(filter f)
{
using (var _dbcontext = new PayRollEntities())
{
SqlConnection con = _dbcontext.Database.Connection as SqlConnection;
var sd = con.Query <SalaryData>("[dbo].[GetSalaryData] @Mode,@WAGES_TYPEID,@StartDate,@EndDate", new { Mode = f.Mode, WAGES_TYPEID = f.Wagetype, StartDate = f.StartDate, EndDate = f.EndDate });
return(sd.ToList());
}
}
protected void BandedView_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
PayRollEntities entity = (PayRollEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity;
BandedGridView bandedView = (BandedGridView)MainView;
if (bandedView.FocusedRowHandle >= 0)
{
HREmployeePayRollsInfo objEmployeePayRollsInfo = (HREmployeePayRollsInfo)bandedView.GetRow(bandedView.FocusedRowHandle);
((PayRollModule)Screen.Module).CalculatePayRollTotalAmounts(objEmployeePayRollsInfo);
}
}
public bool UpdateEmployeeImage(int EMPID, string imgPath)
{
using (var _dbcontext = new PayRollEntities())
{
var emp = (from e in _dbcontext.EMPLOYEEs where e.EMPID == EMPID select e).FirstOrDefault();
emp.IMAGE = imgPath;
_dbcontext.Entry(emp).State = EntityState.Modified;
_dbcontext.SaveChanges();
return(true);
}
}
public List <AttenanceViewModel> GetAttenanceReport(filter f)
{
using (var _dbcontext = new PayRollEntities())
{
SqlConnection con = _dbcontext.Database.Connection as SqlConnection;
var eMPLOYEEData = con.Query <EMPLOYEE>("[dbo].[SP_GetEmployeelist] @Mode,@UNITID,@DEPARTMENTID,@DESIGNATIONID,@WAGES_TYPEID", new { Mode = f.Mode, UNITID = f.UNIT, DEPARTMENTID = f.Department, DESIGNATIONID = f.DESIGNATION, WAGES_TYPEID = f.Wagetype });
var Empdetails = (from e in eMPLOYEEData
join u in _dbcontext.UNITs on e.UNITID equals u.UnitId
join dep in _dbcontext.Departments on e.DEPARTMENTID equals dep.DepId
join des in _dbcontext.Designations on e.DESIGNATIONID equals des.DegId
select new AttenanceViewModel()
{
EMPID = e.EMPID,
Unit = u.Name,
Department = dep.DEPT,
Designation = des.DESG,
EmpName = e.EMP_NAME,
EmpCode = e.EMPCODE
}).ToList();
var ProcessedData = (from pd in _dbcontext.ProcessedData
where pd.Date == DbFunctions.TruncateTime(f.Date)
select pd).ToList();
var Attdetails = (from ai in _dbcontext.ATTENDANCE_IMPORT
where ai.AttendanceDate == DbFunctions.TruncateTime(f.Date)
select ai).ToList();
var res = (from e in Empdetails
join at in Attdetails on e.EmpCode equals at.EmployeeId into Attendance
from ai in Attendance.DefaultIfEmpty()
join pd in ProcessedData on e.EmpCode equals pd.EmpCode into Data
from d in Data.DefaultIfEmpty()
select new AttenanceViewModel()
{
EMPID = e.EMPID,
Unit = e.Unit,
Department = e.Department,
Designation = e.Designation,
EmpName = e.EmpName,
EmpCode = e.EmpCode,
InTime = ai != null ? ai.InTime : null,
OutTime = ai != null ? ai.OutTime : null,
PunchRecords = ai != null ? ai.PunchRecords : "",
Status = ai != null ? "Present" : "Absent",
Attenanceid = ai != null ? ai.Id : 0,
ShiftCount = d != null ? d.ShiftCount : 0m
}).ToList();
return(res);
}
}
public bool UpdateAttenance(AttenanceModel am)
{
using (var _dbcontext = new PayRollEntities())
{
var at = (from a in _dbcontext.ATTENDANCE_IMPORT where a.Id == am.Id select a).FirstOrDefault();
at.InTime = am.InTime;
at.OutTime = am.OutTime;
at.PunchRecords = am.PunchRecords;
_dbcontext.Entry(at).State = EntityState.Modified;
_dbcontext.SaveChanges();
return(true);
}
}
public int AddAttenance(ATTENDANCE_IMPORT ai)
{
using (var _dbcontext = new PayRollEntities())
{
var att = (from aim in _dbcontext.ATTENDANCE_IMPORT where aim.EmployeeId == ai.EmployeeId && aim.AttendanceDate == DbFunctions.TruncateTime(ai.AttendanceDate) select aim).FirstOrDefault();
if (att == null)
{
_dbcontext.ATTENDANCE_IMPORT.Add(ai);
_dbcontext.SaveChanges();
return(ai.Id);
}
else
{
return(-2);
}
}
}
public int AddEmployee(EMPLOYEE e)
{
using (var _dbcontext = new PayRollEntities())
{
var emp = (from em in _dbcontext.EMPLOYEEs where em.EMPCODE == e.EMPCODE select em).FirstOrDefault();
if (emp == null)
{
_dbcontext.EMPLOYEEs.Add(e);
_dbcontext.SaveChanges();
return(e.EMPID);
}
else
{
return(-2);
}
}
}
public List <Processeddata> GetProcessedAttenancedata(filter f)
{
using (var _dbcontext = new PayRollEntities())
{
var Attdetails = (from pd in _dbcontext.ProcessedData
join ai in _dbcontext.ATTENDANCE_IMPORT on pd.EmpCode equals ai.EmployeeId
join e in _dbcontext.EMPLOYEEs on pd.EmpCode equals e.EMPCODE
where pd.Date == DbFunctions.TruncateTime(f.Date) && ai.AttendanceDate == DbFunctions.TruncateTime(f.Date)
select new Processeddata
{
EmpId = pd.EmpCode,
EmpName = e.EMP_NAME,
HoursWorked = pd.HoursWorked,
ShiftCount = pd.ShiftCount,
Attenanceid = ai.Id,
Status = pd.Status
}).ToList();
return(Attdetails);
}
}
public List <AttenanceProcessModel> GetAttenancedata(DateTime date, int WGID)
{
using (var _dbcontext = new PayRollEntities())
{
var Attdetails = (from ai in _dbcontext.ATTENDANCE_IMPORT
join e in _dbcontext.EMPLOYEEs on ai.EmployeeId equals e.EMPCODE
where ai.AttendanceDate == DbFunctions.TruncateTime(date) && e.WAGES_TYPEID == WGID
select new AttenanceProcessModel
{
Id = ai.Id,
AttendanceLogId = ai.AttendanceLogId,
AttendanceDate = ai.AttendanceDate,
EmployeeId = ai.EmployeeId,
InTime = ai.InTime,
OutTime = ai.OutTime,
PunchRecords = ai.PunchRecords,
ActualSalary = e.ACTUAL_SALARY,
AduitingSalary = e.ADUITING_SALARY
}).ToList();
return(Attdetails);
}
}
