public static int GetReligionCastId(string ReligionName, string CastName)
{
int religionId = 0;
int CastId = 0;
int ReligionCastId = 0;
ReligionBAL religionBAL = new ReligionBAL();
IQueryable <Entities.Religion> religionEntities = religionBAL.FindBy(r => r.ReligionName.ToLower() == ReligionName.ToLower());
if (religionEntities != null && religionEntities.Count() > 0)
{
religionId = religionEntities.FirstOrDefault().ReligionId;
}
CastBAL CastBAL = new CastBAL();
IQueryable <Entities.Cast> CastEntities = CastBAL.FindBy(r => r.CastName.ToLower() == CastName.ToLower());
if (CastEntities != null && CastEntities.Count() > 0)
{
CastId = CastEntities.FirstOrDefault().CastId;
}
ReligionCastBAL ReligionCastBAL = new ReligionCastBAL();
IQueryable <Entities.ReligionCast> ReligionCastEntities = ReligionCastBAL.FindBy(r => r.ReligionId == religionId && r.CastId == CastId);
if (ReligionCastEntities != null && ReligionCastEntities.Count() > 0)
{
ReligionCastId = ReligionCastEntities.FirstOrDefault().ReligionCastId;
}
return(ReligionCastId);
}
public ActionResult Index()
{
List <ReligionCastVM> viewModels = new List <ReligionCastVM>();
ReligionCastBAL balObject = new ReligionCastBAL();
IQueryable <Entities.ReligionCast> entites = balObject.GetAll();
//ReligionBAL ReligionBAL = new ReligionBAL();
//IQueryable<Entities.Religion> Religions = ReligionBAL.GetAll();
//CastBAL CastBAL = new CastBAL();
//IQueryable<Entities.Cast> Casts = CastBAL.GetAll();
foreach (Entities.ReligionCast entity in entites)
{
ReligionCastVM viewModel = new ReligionCastVM();
viewModel.ReligionCastId = entity.ReligionCastId;
viewModel.ReligionId = entity.ReligionId;
viewModel.CastId = entity.CastId;
//viewModel.ReligionName = Religions.Where(c => c.ReligionId == entity.ReligionId).FirstOrDefault().ReligionName;
//viewModel.CastName = Casts.Where(c => c.CastId == entity.CastId).FirstOrDefault().CastName;
viewModel.ReligionName = entity.ReligionName;
viewModel.CastName = entity.CastName;
viewModel.ReserveCategory = entity.ReserveCategory;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <ReligionCastVM> {
Data = viewModels
}));
}
/// <summary>
/// method for get Reserve Category
/// </summary>
/// <param name="ReligionId">Religion Id</param>
/// <param name="CastId">Cast Id</param>
/// <returns>return string</returns>
public static string GetReserveCategory(int ReligionId, int CastId)
{
ReligionCastBAL religionCastBAL = new ReligionCastBAL();
IQueryable <Entities.ReligionCast> religionCasts = religionCastBAL.FindBy(cd => cd.ReligionId == ReligionId && cd.CastId == CastId);
if (religionCasts != null && religionCasts.Count() > 0)
{
return(religionCasts.FirstOrDefault().ReserveCategory);
}
return(string.Empty);
}
//
// POST: /SysAdmin/ReligionCast/Delete/5
//[HttpPost]
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
ReligionCastBAL balObject = new ReligionCastBAL();
balObject.Delete(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
//
// GET: /SysAdmin/ReligionCast/Edit/5
public ActionResult Edit(int id)
{
ReligionCastVM viewModel = new ReligionCastVM();
ReligionCastBAL balObject = new ReligionCastBAL();
IQueryable <Entities.ReligionCast> entites = balObject.FindBy(a => a.ReligionCastId == id);
if (entites != null && entites.Count() > 0)
{
Entities.ReligionCast entity = entites.FirstOrDefault();
viewModel.ReligionCastId = entity.ReligionCastId;
viewModel.ReligionId = entity.ReligionId;
viewModel.CastId = entity.CastId;
viewModel.ReligionName = entity.ReligionName;
viewModel.CastName = entity.CastName;
viewModel.ReserveCategory = entity.ReserveCategory;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
//
// GET: /SysAdmin/ReligionCast/Details/5
public ActionResult Details(int id)
{
ReligionCastVM viewModel = new ReligionCastVM();
ReligionCastBAL balObject = new ReligionCastBAL();
IQueryable <Entities.ReligionCast> entites = balObject.FindBy(a => a.ReligionCastId == id);
if (entites != null && entites.Count() > 0)
{
Entities.ReligionCast entity = entites.FirstOrDefault();
viewModel.ReligionCastId = entity.ReligionCastId;
viewModel.ReligionId = entity.ReligionId;
viewModel.CastId = entity.CastId;
ReligionBAL ReligionBAL = new ReligionBAL();
CastBAL CastBAL = new CastBAL();
viewModel.ReligionName = ReligionBAL.FindBy(c => c.ReligionId == entity.ReligionId).FirstOrDefault().ReligionName;
viewModel.CastName = CastBAL.FindBy(c => c.CastId == entity.CastId).FirstOrDefault().CastName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
public ActionResult Create(ReligionCastVM viewModel)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
Entities.ReligionCast entity = new Entities.ReligionCast();
entity.ReligionCastId = viewModel.ReligionCastId;
entity.ReligionId = viewModel.ReligionId;
entity.CastId = viewModel.CastId;
entity.ReserveCategory = viewModel.ReserveCategory;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
ReligionCastBAL balObject = new ReligionCastBAL();
balObject.Add(entity);
//this.TempData["AlertMessage"] = "Successfully Save !!!";
return(RedirectToAction("Index"));
}
else
{
ReligionBAL ReligionBAL = new ReligionBAL();
viewModel.Religions = from obj in ReligionBAL.GetAll() select new SelectListItem()
{
Text = obj.ReligionName, Value = obj.ReligionId.ToString()
};
return(View(viewModel));
}
}
catch
{
ReligionBAL ReligionBAL = new ReligionBAL();
viewModel.Religions = from obj in ReligionBAL.GetAll() select new SelectListItem()
{
Text = obj.ReligionName, Value = obj.ReligionId.ToString()
};
return(View(viewModel));
}
}
public ActionResult Edit(ReligionCastVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.ReligionCast entity = new Entities.ReligionCast();
entity.ReligionCastId = viewModel.ReligionCastId;
entity.ReligionId = viewModel.ReligionId;
entity.CastId = viewModel.CastId;
entity.ReserveCategory = viewModel.ReserveCategory;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
ReligionCastBAL balObject = new ReligionCastBAL();
balObject.Edit(entity);
return(RedirectToAction("Index"));
}
else
{
ReligionBAL ReligionBAL = new ReligionBAL();
viewModel.Religions = from obj in ReligionBAL.GetAll() select new SelectListItem()
{
Text = obj.ReligionName, Value = obj.ReligionId.ToString()
};
return(View(viewModel));
}
}
catch
{
ReligionBAL ReligionBAL = new ReligionBAL();
viewModel.Religions = from obj in ReligionBAL.GetAll() select new SelectListItem()
{
Text = obj.ReligionName, Value = obj.ReligionId.ToString()
};
return(View());
}
}
public ActionResult Select()
{
string mode = Request.QueryString["Grid-mode"];
if (!string.IsNullOrEmpty(mode))
{
return(this.RedirectToAction("Create"));
}
else
{
List <ReligionCastVM> viewModels = new List <ReligionCastVM>();
ReligionCastBAL balObject = new ReligionCastBAL();
IQueryable <Entities.ReligionCast> entites = balObject.GetAll();
//ReligionBAL ReligionBAL = new ReligionBAL();
//IQueryable<Entities.Religion> Religions = ReligionBAL.GetAll();
//CastBAL CastBAL = new CastBAL();
//IQueryable<Entities.Cast> Casts = CastBAL.GetAll();
foreach (Entities.ReligionCast entity in entites)
{
ReligionCastVM viewModel = new ReligionCastVM();
viewModel.ReligionCastId = entity.ReligionCastId;
viewModel.ReligionId = entity.ReligionId;
viewModel.CastId = entity.CastId;
//viewModel.ReligionName = Religions.Where(c => c.ReligionId == entity.ReligionId).FirstOrDefault().ReligionName;
//viewModel.CastName = Casts.Where(c => c.CastId == entity.CastId).FirstOrDefault().CastName;
viewModel.ReligionName = entity.ReligionName;
viewModel.CastName = entity.CastName;
viewModel.ReserveCategory = entity.ReserveCategory;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(this.View("Index", new GridModel <ReligionCastVM> {
Data = viewModels
}));
}
}
