public static void CreateStockType(StockTypeModel stockTypeModel) { using (ctaDBEntities entities = new ctaDBEntities()) { Stock_Type st = new Stock_Type() { name = stockTypeModel.name }; entities.Stock_Type.Add(st); entities.SaveChanges(); if (!(entities.Database.Connection.State == ConnectionState.Closed)) { entities.Database.Connection.Close(); } } }
public static void UpdateStockType(StockTypeModel stockTypeModel) { using (ctaDBEntities entities = new ctaDBEntities()) { Stock_Type st = entities.Stock_Type.Where(s => s.Id == stockTypeModel.Id).FirstOrDefault(); if (st != null) { st.name = stockTypeModel.name; entities.SaveChanges(); } if (!(entities.Database.Connection.State == ConnectionState.Closed)) { entities.Database.Connection.Close(); } } }