public List <ContestsClass> GetAllContestsById(int id)
{
List <ContestsClass> li = new List <ContestsClass>();
var AllContests = obj.Contests.Where(x => x.Status != 0 && x.Id.Equals(id)).ToList();
var count = AllContests.Count();
foreach (var details in AllContests)
{
ContestsClass temp = new ContestsClass();
temp.Id = details.Id;
temp.Name = details.Name;
try
{
temp.EntriesCount = details.EntriesCount.Value;
}
catch (Exception e) { temp.EntriesCount = 0; }
temp.Date = details.Date;
temp.WinnerName = details.WinnerName;
temp.Reward = details.Reward;
temp.Count = count;
li.Add(temp);
}
return(li);
}
public List <ContestsClass> GetLatestContests(int id)
{
int ShowRecords = 20;
int skip = id * ShowRecords;
var DesiMasala = "";
var AllRecords = obj.Contests.Count();
int max = (skip + ShowRecords);
if (max > AllRecords)
{
max = AllRecords;
}
DesiMasala = (skip + 1).ToString() + "-" + max.ToString() + "/" + AllRecords.ToString();
List <ContestsClass> li = new List <ContestsClass>();
var AllContests = obj.Contests.Skip(skip).Take(ShowRecords).Where(x => x.Status != 0).ToList();
var count = AllContests.Count();
int i = 0;
foreach (var details in AllContests)
{
if (i == 3)
{
break;
}
ContestsClass temp = new ContestsClass();
temp.Id = details.Id;
temp.Name = details.Name;
try
{
temp.EntriesCount = details.EntriesCount.Value;
}
catch (Exception e) { temp.EntriesCount = 0; }
temp.WinnerName = details.WinnerName;
temp.Reward = details.Reward;
temp.Date = details.Date;
temp.Count = count;
temp.NumberOfShowing = DesiMasala;
li.Add(temp);
i++;
}
List <ContestsClass> SortedList = li.OrderByDescending(x => x.AddDate).ToList();
return(SortedList);
}
public int PostContest(ContestsClass CC)
{
int check = 0;
try
{
Contest contest = new Contest();
contest.Name = CC.Name;
contest.EntriesCount = CC.EntriesCount;
contest.WinnerName = CC.WinnerName;
contest.Reward = CC.Reward;
contest.Date = DateTime.Now.ToShortDateString();
contest.AddDate = DateTime.Now.ToShortDateString();
contest.Status = 1;
obj.Contests.InsertOnSubmit(contest);
obj.SubmitChanges();
check = contest.Id;
}
catch (Exception e) { check = 0; }
return(check);
}
public int UpdateContest(ContestsClass CC)
{
int check = 0;
try
{
Contest contest = obj.Contests.First(x => x.Id.Equals(CC.Id));
contest.Name = CC.Name;
contest.EntriesCount = CC.EntriesCount;
contest.WinnerName = CC.WinnerName;
contest.Reward = CC.Reward;
if (CC.Date != "")
{
contest.Date = CC.Date;
}
contest.AddDate = DateTime.Now.ToString();
contest.Status = 1;
obj.SubmitChanges();
check = contest.Id;
}
catch (Exception e) { check = 0; }
return(check);
}
