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