public static BusinessObjects.Job GetDetails(Guid Id) { BusinessObjects.Job job = null; using (ADOBathindaEntities context = new ADOBathindaEntities()) { var InDb = context.Jobs.SingleOrDefault(j => j.Id == Id); job = new BusinessObjects.Job { Id = InDb.Id, DateAdded = InDb.DateAdded, EndLatitude = InDb.EndLatitude, EndLongitude = InDb.EndLongitude, EstimatedBudget = InDb.EstimatedBudget, IsPathStored = InDb.IsPathStored, IsVerified = InDb.IsVerified, PreviousGrant = InDb.PreviousGrant, SchemaId = InDb.SchemaId, StartLatitude = InDb.StartLatitude, StartLongitude = InDb.StartLongitude, VillageId = InDb.VillageId, WorkNameId = InDb.WorkNameId }; } return(job); }
public static bool Update(BusinessObjects.Job jobBO) { int i = 0; using (ADOBathindaEntities context = new ADOBathindaEntities()) { var InDb = context.Jobs.SingleOrDefault(j => j.Id == jobBO.Id); InDb.IsPathStored = jobBO.IsPathStored; InDb.IsVerified = jobBO.IsVerified; InDb.SchemaId = jobBO.SchemaId; InDb.StartLatitude = jobBO.StartLatitude; InDb.StartLongitude = jobBO.StartLongitude; InDb.EstimatedBudget = jobBO.EstimatedBudget; InDb.EndLatitude = jobBO.EndLatitude; InDb.EndLongitude = jobBO.EndLongitude; InDb.PreviousGrant = jobBO.PreviousGrant; InDb.VillageId = jobBO.VillageId; InDb.WorkNameId = jobBO.WorkNameId; i = context.SaveChanges(); context.Dispose(); } if (i > 0) { return(true); } else { return(false); } }
public static List <BusinessObjects.Job> GetAllAssignedJobs() { List <BusinessObjects.Job> list = new List <BusinessObjects.Job>(); using (ADOBathindaEntities context = new ADOBathindaEntities()) { var JobsInDb = context.Jobs.Where(j => j.IsVerified == false).ToList(); foreach (var InDb in JobsInDb) { BusinessObjects.Job job = new BusinessObjects.Job { Id = InDb.Id, DateAdded = InDb.DateAdded, EndLatitude = InDb.EndLatitude, EndLongitude = InDb.EndLongitude, EstimatedBudget = InDb.EstimatedBudget, IsPathStored = InDb.IsPathStored, IsVerified = InDb.IsVerified, PreviousGrant = InDb.PreviousGrant, SchemaId = InDb.SchemaId, StartLatitude = InDb.StartLatitude, StartLongitude = InDb.StartLongitude, VillageId = InDb.VillageId, WorkNameId = InDb.WorkNameId }; list.Add(job); } } return(list); }
public static bool Add(BusinessObjects.Job jobBO) { int i = 0; var job = new Job { DateAdded = DateTime.Now, Id = Guid.NewGuid(), EstimatedBudget = jobBO.EstimatedBudget, IsPathStored = false, IsVerified = false, SchemaId = jobBO.SchemaId, VillageId = jobBO.VillageId, WorkNameId = jobBO.WorkNameId }; using (ADOBathindaEntities context = new ADOBathindaEntities()) { context.Jobs.Add(job); i = context.SaveChanges(); context.Dispose(); } if (i > 0) { return(true); } else { return(false); } }
public static bool Delete(BusinessObjects.Job jobBO) { int i = 0; using (ADOBathindaEntities context = new ADOBathindaEntities()) { var InDb = context.Jobs.SingleOrDefault(j => j.Id == jobBO.Id); context.Jobs.Remove(InDb); i = context.SaveChanges(); } if (i > 0) { return(true); } else { return(false); } }
public static bool Delete(BusinessObjects.Job jobBO) { return(JobDA.Delete(jobBO)); }
public static bool Update(BusinessObjects.Job jobBO) { return(JobDA.Update(jobBO)); }
public static bool Add(BusinessObjects.Job jobBO) { return(JobDA.Add(jobBO)); }