public bool IsRecordExists(EntityShift entDept)
{
bool flag = false;
try
{
tblShiftMaster obj = (from tbl in objData.tblShiftMasters
where tbl.IsDelete == false &&
tbl.ShiftName.ToUpper().ToString().Trim().Equals(entDept.ShiftName.ToUpper().ToString().Trim()) ||
tbl.StartTime.CompareTo(entDept.StartTime) == 0 ||
entDept.StartTime.CompareTo(tbl.EndTime) == -1 ||
tbl.EndTime.CompareTo(entDept.EndTime) == 1
select tbl).FirstOrDefault();
if (obj != null)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(flag);
}
public EntityShift GetShift(int p)
{
EntityShift lobjShift = (from tbl in objData.tblShiftMasters
where tbl.ShiftId.Equals(p) &&
tbl.IsDelete == false
select new EntityShift {
ShiftName = tbl.ShiftName, StartTime = tbl.StartTime, EndTime = tbl.EndTime
}).FirstOrDefault();
return(lobjShift);
}
public int InsertShift(EntityShift entDept)
{
try
{
tblShiftMaster obj = new tblShiftMaster()
{
ShiftName = entDept.ShiftName,
StartTime = entDept.StartTime,
EndTime = entDept.EndTime
};
objData.tblShiftMasters.InsertOnSubmit(obj);
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public int Update(EntityShift entDept)
{
try
{
tblShiftMaster test = (from tbl in objData.tblShiftMasters
where tbl.IsDelete == false &&
tbl.ShiftId == entDept.ShiftId
select tbl).FirstOrDefault();
test.ShiftName = entDept.ShiftName;
test.StartTime = entDept.StartTime;
test.EndTime = entDept.EndTime;
objData.SubmitChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
public EntityShift GetStartEndTime(int Doc)
{
try
{
EntityShift objShi = (from tbl in objData.tblShiftMasters
join tblS in objData.tblShiftAllocEmps
on tbl.ShiftId equals tblS.Shift_Id
join tblE in objData.tblEmployees
on tblS.Emp_Id equals tblE.PKId
where tblE.PKId == Doc &&
tblE.IsDelete.Equals(false)
select new EntityShift {
StartTime = tbl.StartTime, EndTime = tbl.EndTime
}).FirstOrDefault();
return(objShi);
}
catch (Exception ex)
{
throw ex;
}
}
