/// <summary> /// Initialize Db Context /// </summary> public DbContext() { if (Context == null) { Context = new ApniMaaDBEntities(); } }
public AddProspectModel() { using (ApniMaaDBEntities context = new ApniMaaDBEntities()) { this.CountryList = context.Countries.Select(a => new SelectListItem { Text = a.CountryName, Value = a.CountryID.ToString() }).ToList(); } }
/// <summary> /// Dispose the context /// </summary> public void Dispose() { if (Context != null) { Context.Dispose(); Context = null; } }
public AddDishModel() { using (ApniMaaDBEntities Context = new ApniMaaDBEntities()) { this.CategoryList = Context.Categories.Where(d => d.IsDeleted == false).ToList() .Select(a => new SelectListItem { Text = a.Name, Value = a.Id.ToString() }).ToList(); } }
public static string GenerateApplicationNo() { using (ApniMaaDBEntities Context = new ApniMaaDBEntities()) { var appno = "0001"; var prev = Context.MotherTbls.Max(p => p.ApplicationNo); if (prev != null) { appno = (Convert.ToInt32(prev) + 1).ToString("0000"); } return(appno); } }
public AddDishModel(Dish obj) { using (ApniMaaDBEntities Context = new ApniMaaDBEntities()) { this.CategoryList = Context.Categories.Where(d => d.IsDeleted == false).ToList() .Select(a => new SelectListItem { Text = a.Name, Value = a.Id.ToString() }).ToList(); } this.CategoryId = obj.CategoryId; this.Description = obj.Description; this.Name = obj.Name; }
/// <summary> /// Reinitiate the database context. /// </summary> public void ReinitiateContext() { Dispose(); Context = new ApniMaaDBEntities(); }