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; } }