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