public static object Maplist() { List <CSMAP> MAP = new List <CSMAP>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Class_section_MAP.Join(db.Classname, x => x.ClassId, y => y.ClassId, (x, y) => new { x.ClassId, y.Class, x.Id, x.Section, x.SectionId, }).ToList(); foreach (var item in obj) { CSMAP ad = new CSMAP(); ad.Classid = item.ClassId; ad.Class = item.Class; ad.Id = item.Id; ad.Section = item.Section; ad.Sectionid = item.SectionId; MAP.Add(ad); } } return(MAP); }
public static object Create2(string mode, int contestantid, string firstname, string lastname, DateTime dob, bool active, int district, string gender) { List <Contestant> NAB = new List <Contestant>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { if (mode == "InsertMode") { Contestant obj = new Contestant(); obj.Firstname = firstname; obj.Lastname = lastname; obj.DateOfBirth = dob; obj.IsActive = active; obj.DistrictId = district; obj.Gender = gender; db.Contestants.Add(obj); db.SaveChanges(); return(NAB); } else { return(ContestantDetailList()); } } }
public static object button1(int[] listOfIds) { List <NabaT12> NAB = new List <NabaT12>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { if (listOfIds.Length > 0) { foreach (var id in listOfIds) { var list = db.Table_2.Where(x => x.Id == id).ToList(); Table_2 dataOfTable1 = list.FirstOrDefault(); Table_1 insertIntoTable1 = new Table_1(); insertIntoTable1.Name1 = dataOfTable1.Name2; insertIntoTable1.Name1Id = id; db.Table_1.Add(insertIntoTable1); db.SaveChanges(); db.Table_2.Remove(dataOfTable1); db.SaveChanges(); } } return(db.Table_1.ToList()); } }
public static object GetAllContestant() { List <Naba2> NAB = new List <Naba2>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Contestants.Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.Gender, y.Name, x.DateOfBirth, x.IsActive }).ToList(); foreach (var item in obj) { Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; NAB.Add(ad); } return(NAB); } }
public static object ContestantDetails(Naba2 a, string FullName) { List <Naba2> NAB = new List <Naba2>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var ContestantList = db.Contestants.Where(x => x.Firstname.StartsWith(FullName)).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name }) .ToList(); foreach (var item in ContestantList) { Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; NAB.Add(ad); } return(NAB); } }
public static object ContestantDetailList() { List <Naba1> NAB = new List <Naba1>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Contestants.Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.Gender, y.Name, x.DateOfBirth }).ToList(); foreach (var item in obj) { Naba1 cd = new Naba1(); cd.ConstantId = item.Id; cd.FullName = item.Firstname + " " + item.Lastname; cd.DateOfBirth = item.DateOfBirth.Value.ToShortDateString(); cd.District = item.Name; cd.Gender = item.Gender; NAB.Add(cd); } return(NAB); } }
public static object Userlist() { using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.SignUp.ToList(); return(obj); } }
public object DistrictList() { using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Districts.ToList(); return(obj); } }
public ActionResult Create12() { using (NabayubakDBEntities db = new NabayubakDBEntities()) { ViewBag.Districtslist = db.Districts.ToList(); } return(View()); }
//public ActionResult Loginpage() //{ // var obj = sign.Userlist(); // return View(obj); //} public ActionResult Loginpage() { using (NabayubakDBEntities db = new NabayubakDBEntities()) { ViewBag.Userlist = db.SignUp.ToList(); } ViewBag.loginStatus = "jhghg"; return(View()); }
public ActionResult Delete(int?Id = 0) { using (NabayubakDBEntities db = new NabayubakDBEntities()) { var delete = db.Contestants.Where(x => x.Id == Id).FirstOrDefault(); db.Contestants.Remove(delete); db.SaveChanges(); } return(RedirectToAction("Index")); }
public static object ConstantRating1(int id) { List <Naba2> Clist = new List <Naba2>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Contestants.Find(id); int?districtId = obj.DistrictId; return(obj); } }
public static object signup2(string Firstname, string Lastname, string Username, string Password, DateTime Birthday, string Gender) { using (NabayubakDBEntities db = new NabayubakDBEntities()) { { SignUp obj = new SignUp(); obj.Firstname = Firstname; obj.Lastname = Lastname; obj.Username = Username; obj.Password = Password; obj.Birthday = Birthday; obj.Gender = Gender; db.SignUp.Add(obj); db.SaveChanges(); return(obj); } } }
public static object Cascadedropdownclasslist() { List <CSMAP> MAP = new List <CSMAP>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Classname.ToList(); foreach (var item in obj) { CSMAP ad = new CSMAP(); ad.Classid = item.ClassId; ad.Class = item.Class; MAP.Add(ad); } } return(MAP); }
public static object RateConstant(int id, int rate) { var date = ""; using (NabayubakDBEntities db = new NabayubakDBEntities()) { var a = DateTime.Now; var b = DateTime.Today; var c = DateTime.Today.ToShortDateString(); var d = DateTime.Today.ToString("yyyy-MM-dd"); ContestantRating ins = new ContestantRating(); ins.ContestantId = id; ins.RateDate = DateTime.Today; ins.Rating = rate; db.ContestantRatings.Add(ins); db.SaveChanges(); return(ConstantwithRating()); } }
public static object Section() { List <CSMAP> MAP = new List <CSMAP>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Sectionname.ToList(); foreach (var item in obj) { CSMAP ad = new CSMAP(); ad.Sectionid = item.SectionId; ad.Section = item.Section; MAP.Add(ad); } } return(MAP); }
public static object Getlist2() { List <NabaT12> NAB = new List <NabaT12>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Table_2.ToList(); foreach (var item in obj) { NabaT12 ad = new NabaT12(); ad.Id = item.Id; ad.Name2 = item.Name2; ad.Namae2Id = item.Name2Id; NAB.Add(ad); } } return(NAB); }
public ActionResult Loginpage(string Username, string Password) { var obj = sign.Login1(Username, Password); if (obj == true) { return(RedirectToAction("Profil")); } else { using (NabayubakDBEntities db = new NabayubakDBEntities()) { ViewBag.Userlist = db.SignUp.ToList(); } ViewBag.loginStatus = "False"; return(View());//RedirectToAction("Loginpage"); } ViewBag.loginStatus = "False"; return(View());//RedirectToAction("Loginpage"); }
public ActionResult SavePhoto(HttpPostedFileBase filea, int constantid) { if (filea != null && filea.ContentLength > 0) { //file name lera aako var fileName = Path.GetFileName(filea.FileName); //file save garne path var path = Path.Combine(Server.MapPath("~/Photos"), constantid + fileName); filea.SaveAs(path); var imagepath = "/Photos/"; using (NabayubakDBEntities db = new NabayubakDBEntities()) { var stdPhoto = db.Contestants.Where(x => x.Id == constantid).FirstOrDefault(); stdPhoto.PhotoUrl = imagepath + constantid + fileName; db.SaveChanges(); } } return(View()); }
public ActionResult Edit(Contestant a, int Id) { using (NabayubakDBEntities db = new NabayubakDBEntities()) { var edit = db.Contestants.Where(x => x.Id == Id).FirstOrDefault(); edit.Firstname = a.Firstname; edit.Lastname = a.Lastname; edit.DateOfBirth = a.DateOfBirth; edit.IsActive = a.IsActive; edit.DistrictId = a.DistrictId; edit.Gender = a.Gender; db.SaveChanges(); // for delete //var delete = db.Contestants.Where (x => x.Id == Id).FirstOrDefault(); // db.Contestants.Remove(delete); // db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Edit(int id = 0) { Contestant con = new Contestant(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { con = db.Contestants.Find(id); int?districtId = con.DistrictId; ViewBag.Districtslist = db.Districts.ToList().Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.Name, Selected = (x.Id == 1) }); //ViewBag.Districtslist = db.Districts.ToList(); if (con == null) { return(HttpNotFound()); } // return View(con); } return(View(con)); }
public static object Cascadedropdownsectionlist(int Classid) { List <CSMAP> MAP = new List <CSMAP>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Class_section_MAP.Where(x => x.ClassId == Classid).ToList(); foreach (var item in obj) { CSMAP ad = new CSMAP(); ad.Id = item.Id; ad.Classid = item.ClassId; ad.Section = item.Section; ad.Sectionid = item.SectionId; MAP.Add(ad); } } return(MAP); }
public static bool Login1(string Username, string Password) { using (NabayubakDBEntities db = new NabayubakDBEntities()) { var loginresult = db.SignUp.Where(s => s.Username == Username && s.Password == Password).FirstOrDefault(); if (loginresult != null) { if (Password == loginresult.Password.ToString()) { return(true); } else { return(false); } } else { return(false); } } }
public static object ConstantwithRating() { List <Naba2> NAB = new List <Naba2>(); using (NabayubakDBEntities db = new NabayubakDBEntities()) { var obj = db.Contestants.Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.Gender, y.Name, x.DateOfBirth, x.IsActive }).ToList(); foreach (var item in obj) { decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id).Count(); if (CheckContestent > 0) { { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } return(NAB); }
public static object ConstantwithRating(String searchBy, DateTime Fromdate, DateTime Todate, string Gender, bool?IsActive, string search) { List <Naba2> NAB = new List <Naba2>(); try { using (NabayubakDBEntities db = new NabayubakDBEntities()) if (searchBy == "Gender" && IsActive == true) { var ContestantList = db.Contestants.Where(x => x.Gender == Gender && x.IsActive == IsActive).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name, }) .ToList(); foreach (var item in ContestantList) { DateTime fromdate = Fromdate.Date; DateTime todate = Todate.Date; decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count(); if (CheckContestent > 0) { if (Fromdate != null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count()); } else if (Fromdate != null && Todate == null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Count()); } else if (Fromdate == null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Count()); } else { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } else if (searchBy == "Gender" && IsActive == false) { var ContestantList = db.Contestants.Where(x => x.Gender == Gender && x.IsActive == IsActive).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name, }) .ToList(); foreach (var item in ContestantList) { DateTime fromdate = Fromdate.Date; DateTime todate = Todate.Date; decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count(); if (CheckContestent > 0) { if (Fromdate != null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count()); } else if (Fromdate != null && Todate == null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Count()); } else if (Fromdate == null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Count()); } else { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } else if (searchBy == "Name" && IsActive == true) { var ContestantList = db.Contestants.Where(x => x.Firstname.StartsWith(search) && x.IsActive == IsActive).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name }) .ToList(); foreach (var item in ContestantList) { DateTime fromdate = Fromdate.Date; DateTime todate = Todate.Date; decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count(); if (CheckContestent > 0) { if (Fromdate != null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count()); } else if (Fromdate != null && Todate == null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Count()); } else if (Fromdate == null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Count()); } else { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } else if (searchBy == "Name" && IsActive == false) { var ContestantList = db.Contestants.Where(x => x.Firstname.StartsWith(search) && x.IsActive == IsActive).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name }) .ToList(); foreach (var item in ContestantList) { DateTime fromdate = Fromdate.Date; DateTime todate = Todate.Date; decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count(); if (CheckContestent > 0) { if (Fromdate != null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count()); } else if (Fromdate != null && Todate == null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Count()); } else if (Fromdate == null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Count()); } else { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } else if (Fromdate != null && Todate != null && IsActive == true) { var ContestantList = db.Contestants.Where(x => x.IsActive == IsActive).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name, }) .ToList(); foreach (var item in ContestantList) { DateTime fromdate = Fromdate.Date; DateTime todate = Todate.Date; decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count(); if (CheckContestent > 0) { if (Fromdate != null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count()); } else if (Fromdate != null && Todate == null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Count()); } else if (Fromdate == null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } else if (Fromdate != null && Todate != null && IsActive == false) { var qab = db.ContestantRatings.Where(x => x.RateDate >= Fromdate && x.RateDate <= Todate).ToList(); var ContestantList = db.Contestants.Where(x => x.IsActive == IsActive).Join(db.Districts, x => x.DistrictId, y => y.Id, (x, y) => new { x.Id, x.Firstname, x.Lastname, x.DateOfBirth, x.Gender, x.IsActive, y.Name, }) .ToList(); foreach (var item in ContestantList) { DateTime fromdate = Fromdate; DateTime todate = Todate; decimal sum = 0; decimal count = 0; var CheckContestent = db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count(); if (CheckContestent > 0) { if (Fromdate != null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate && x.RateDate <= todate).Count()); } else if (Fromdate != null && Todate == null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate >= fromdate).Count()); } else if (Fromdate == null && Todate != null) { sum = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Select(x => x.Rating).ToList().Sum()); count = Convert.ToDecimal(db.ContestantRatings.Where(x => x.ContestantId == item.Id && x.RateDate <= todate).Count()); } decimal AverageRate = Convert.ToDecimal(sum / count); int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = AverageRate; ad.Ratercount = Ratercount; NAB.Add(ad); } else if (CheckContestent == 0) { int Ratercount = CheckContestent; Naba2 ad = new Naba2(); ad.ConstantId = item.Id; ad.District = item.Name; ad.Dateofbirth = item.DateOfBirth.Value.ToShortDateString(); ad.FullName = item.Firstname + " " + item.Lastname; ad.Gender = item.Gender; ad.IsActive = item.IsActive; ad.Averagerating = 0; ad.Ratercount = Ratercount; NAB.Add(ad); } } } return(NAB); } catch (Exception) { return(0); } }