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