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