public static bool Add(BusinessObjects.Schema schemaBO) { SchemaDA S = new SchemaDA(); var schema = new Schema { Id = Guid.NewGuid(), Name = schemaBO.Name, GrantMoney = schemaBO.GrantMoney, DateAdded = DateTime.Now }; S.context.Schemas.Add(schema); int affectedRows = S.context.SaveChanges(); S.context.Dispose(); if (affectedRows > 0) { return(true); } else { return(false); } }
public static BusinessObjects.Schema GetDetails(Guid Id) { SchemaDA S = new SchemaDA(); var InDb = S.context.Schemas.SingleOrDefault(s => s.Id == Id); BusinessObjects.Schema schema = new BusinessObjects.Schema { Id = InDb.Id, Name = InDb.Name, GrantMoney = InDb.GrantMoney, DateAdded = InDb.DateAdded }; S.context.Dispose(); return(schema); }
public static bool Delete(BusinessObjects.Schema schemaBO) { SchemaDA S = new SchemaDA(); var InDB = S.context.Schemas.SingleOrDefault(s => s.Id == schemaBO.Id); S.context.Schemas.Remove(InDB); int affectedRows = S.context.SaveChanges(); S.context.Dispose(); if (affectedRows > 0) { return(true); } else { return(false); } }
public static bool Update(BusinessObjects.Schema schemaBO) { SchemaDA S = new SchemaDA(); var InDb = S.context.Schemas.SingleOrDefault(s => s.Id == schemaBO.Id); InDb.Name = schemaBO.Name; InDb.GrantMoney = schemaBO.GrantMoney; int affectedRows = S.context.SaveChanges(); S.context.Dispose(); if (affectedRows > 0) { return(true); } else { return(false); } }
public static List <BusinessObjects.Schema> GetAll() { List <BusinessObjects.Schema> list = new List <BusinessObjects.Schema>(); SchemaDA S = new SchemaDA(); var listSchamaInDb = S.context.Schemas.ToList(); foreach (var InDb in listSchamaInDb) { BusinessObjects.Schema schema = new BusinessObjects.Schema { Id = InDb.Id, Name = InDb.Name, GrantMoney = InDb.GrantMoney, DateAdded = InDb.DateAdded }; list.Add(schema); } return(list); }
public static bool Delete(BusinessObjects.Schema schemaBO) { return(SchemaDA.Delete(schemaBO)); }
public static bool Update(BusinessObjects.Schema schemaBO) { return(SchemaDA.Update(schemaBO)); }
public static bool Add(BusinessObjects.Schema schemaBO) { return(SchemaDA.Add(schemaBO)); }