public static IEnumerable <CodeTable> GetAll()
{
using (var context = new ATSCEEntities())
{
return(context.CodeTables.ToList());
}
}
public string Save()
{
string result = string.Empty;
try
{
using (var context = new ATSCEEntities())
{
if (this.CodeTableId <= 0)
{
context.CodeTables.Add(this);
}
else
{
context.Entry(this).State = System.Data.EntityState.Modified;
}
int rowAffected = context.SaveChanges();
if (rowAffected <= 0)
result = "Record is not saved";
}
}
catch (Exception ex)
{
// Log Exception here.
throw new Exception("Record is not saved");
}
return result;
}
public static CodeTable GetById(int codeTableId)
{
using (var context = new ATSCEEntities())
{
return(context.CodeTables.Single(r => r.CodeTableId == codeTableId));
}
}
public static CodeTable GetById(int codeTableId)
{
using (var context = new ATSCEEntities())
{
return context.CodeTables.Single(r => r.CodeTableId == codeTableId);
}
}
public string Save()
{
string result = string.Empty;
try
{
using (var context = new ATSCEEntities())
{
if (this.TimeSheetMasterId <= 0)
{
context.TimeSheetMasters.Add(this);
}
else
{
context.Entry(this).State = System.Data.EntityState.Modified;
}
context.SaveChanges();
foreach (TimeSheetDetail detail in this.TimeSheetDetail.ToList())
{
detail.Save();
}
}
}
catch (Exception)
{
throw new Exception("Record is not saved");
}
return(result);
}
public string Save()
{
string result = string.Empty;
try
{
using (var context = new ATSCEEntities())
{
if (this.CodeTableId <= 0)
{
context.CodeTables.Add(this);
}
else
{
context.Entry(this).State = System.Data.EntityState.Modified;
}
int rowAffected = context.SaveChanges();
if (rowAffected <= 0)
{
result = "Record is not saved";
}
}
}
catch (Exception ex)
{
// Log Exception here.
throw new Exception("Record is not saved");
}
return(result);
}
public static LeavePlan Save(LeavePlan leavePlan)
{
string result = string.Empty;
try
{
ATSCEEntities context = new ATSCEEntities();
if (leavePlan.LeavePlanId <= 0)
{
context.LeavePlans.Add(leavePlan);
}
else
{
context.Entry(leavePlan).State = System.Data.EntityState.Modified;
}
int rowAffected = context.SaveChanges();
if (rowAffected <= 0)
{
result = "Record is not saved";
}
return(leavePlan);
}
catch (Exception ex)
{
throw new Exception("Record is not saved [" + ex.Message + "]");
}
}
public static IEnumerable<CodeTable> GetAll()
{
using (var context = new ATSCEEntities())
{
return context.CodeTables.ToList();
}
}
public static IEnumerable <LeavePlan> GetAllLeavePlansForTeam(int userId)
{
ATSCEEntities context = new ATSCEEntities();
IEnumerable <LeavePlan> leaves = from allLeavePlans in context.LeavePlans
where (allLeavePlans.Person as Staff).SupervisorId == userId
select allLeavePlans;
return(leaves);
}
public static IEnumerable <LeavePlan> GetAllLeavePlansBySupervisorId(int id)
{
ATSCEEntities context = new ATSCEEntities();
IEnumerable <LeavePlan> leavesToSupervise = from allLeavePlans in context.LeavePlans
where (allLeavePlans.Person as Staff).SupervisorId == id
where allLeavePlans.Admitted == null
select allLeavePlans;
return(leavesToSupervise);
}
public static bool Delete(int id)
{
try
{
ATSCEEntities context = new ATSCEEntities();
TimeSheetMaster master = context.TimeSheetMasters.Find(id);
context.TimeSheetMasters.Remove(master);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static bool Delete(int leavePlanId)
{
try
{
ATSCEEntities context = new ATSCEEntities();
LeavePlan leaveplan = context.LeavePlans.Find(leavePlanId);
context.LeavePlans.Remove(leaveplan);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public static IEnumerable <LeavePlan> AdmitOrRejectLeaves(int LeavePlanId, bool AdmitReject)
{
ATSCEEntities context = new ATSCEEntities();
LeavePlan leaveToUpdate = context.LeavePlans.Where(lp => lp.LeavePlanId == LeavePlanId).FirstOrDefault();
if (AdmitReject)
{
leaveToUpdate.Admitted = true;
}
else
{
leaveToUpdate.Admitted = false;
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception("Could not admit or reject [" + ex.Message + "]");
}
return(GetAllLeavePlansBySupervisorId(int.Parse((leaveToUpdate.Person as Staff).SupervisorId.ToString())));
}
public static Person GetById(int PersonId)
{
ATSCEEntities context = new ATSCEEntities();
return(context.Persons.Find(PersonId));
}
public static TimeSheetMaster GetById(int TimeSheetMasterId)
{
ATSCEEntities context = new ATSCEEntities();
return(context.TimeSheetMasters.Find(TimeSheetMasterId));
}
public static IEnumerable <TimeSheetMaster> GetAll()
{
ATSCEEntities context = new ATSCEEntities();
return(context.TimeSheetMasters);
}
public static IEnumerable <LeaveCategory> getAll()
{
ATSCEEntities context = new ATSCEEntities();
return(context.LeaveCategories);
}
public static IEnumerable <LeavePlan> GetAll()
{
ATSCEEntities context = new ATSCEEntities();
return(context.LeavePlans.Include(l => l.LeaveCategory).Include(l => l.Person));
}
public static LeavePlan GetById(int leavePlanId)
{
ATSCEEntities context = new ATSCEEntities();
return(context.LeavePlans.Find(leavePlanId));
}
public static TimeSheetDetail GetById(int TimeSheetDetailId)
{
ATSCEEntities context = new ATSCEEntities();
return(context.TimeSheetDetails.Find(TimeSheetDetailId));
}
public static IEnumerable <Person> GetAll()
{
ATSCEEntities context = new ATSCEEntities();
return(context.Persons);
}