public Boolean addingExamClassDetails(exam_details exmclass)
{
List <exam_details> exlist = new List <exam_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
exlist = dc.exam_details.OrderBy(a => a.exam_type).ToList();
int cc = exlist.Count;
for (int i = 0; i < cc; i++)
{
examClass = exlist[i].exam_type;
sclId = exlist[i].school_id;
if (exmclass.exam_type.Equals(examClass) && exmclass.school_id.Equals(sclId))
{
count = 1;
break;
}
else
{
count = 0;
}
}
}
if (count == 0)
{
return(true);
}
else
{
return(false);
}
}
public Boolean updateExamClassDetails(exam_details edetails)
{
List <exam_details> tlist = new List <exam_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
tlist = dc.exam_details.OrderBy(a => a.exam_type).ToList();
int cc = tlist.Count;
for (int i = 0; i < cc; i++)
{
examClass = tlist[i].exam_type;
sclId = tlist[i].school_id;
exmId = tlist[i].exam_id;
if (edetails.school_id.Equals(sclId) && edetails.exam_id.Equals(exmId))
{
count = 0;
break;
}
else
{
count = 1;
}
}
}
if (count == 0)
{
using (EdujinniEntity entities = new EdujinniEntity())
{
exam_details updatedCustomer = (from c in entities.exam_details
join p in entities.school_details on edetails.school_id equals p.school_id
where c.exam_id == edetails.exam_id
where c.school_id == edetails.school_id
select c).FirstOrDefault();
updatedCustomer.exam_start_date = edetails.exam_start_date;
updatedCustomer.exam_end_date = edetails.exam_end_date;
updatedCustomer.update_date = DateTime.Now;
entities.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
public Boolean deleteExam(exam_details elist)
{
List <exam_details> tlist = new List <exam_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
tlist = dc.exam_details.OrderBy(a => a.exam_type).ToList();
int cc = tlist.Count;
for (int i = 0; i < cc; i++)
{
examClass = tlist[i].exam_type;
sclId = tlist[i].school_id;
exmId = tlist[i].exam_id;
if (elist.school_id.Equals(sclId) && elist.exam_id.Equals(exmId))
{
count = 0;
break;
}
else
{
count = 1;
}
}
}
if (count == 0)
{
using (EdujinniEntity entities = new EdujinniEntity())
{
exam_details custom = (from c in entities.exam_details
where c.exam_id == elist.exam_id
where c.school_id == elist.school_id
select c).FirstOrDefault();
entities.exam_details.Remove(custom);
entities.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
