public Boolean addSubjectDetails(subject_details adding)
{
List <subject_details> slist = new List <subject_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
slist = dc.subject_details.OrderBy(a => a.subject_type).ToList();
int cc = slist.Count;
for (int i = 0; i < cc; i++)
{
subjType = slist[i].subject_type;
subjName = slist[i].subject_name;
if (adding.subject_type.Equals(subjType) && adding.subject_name.Equals(subjName))
{
count = 1;
break;
}
else
{
count = 0;
}
}
}
if (count == 0)
{
return(true);
}
else
{
return(false);
}
}
public Boolean updatingSubjects(subject_details updating)
{
List <subject_details> slist = new List <subject_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
slist = dc.subject_details.OrderBy(a => a.subject_type).ToList();
int cc = slist.Count;
for (int i = 0; i < cc; i++)
{
sid = slist[i].school_id;
int subId = slist[i].subject_id;
if (updating.subject_id.Equals(subId) && updating.school_id.Equals(sid))
{
count = 0;
break;
}
else
{
count = 1;
}
}
}
if (count == 0)
{
using (EdujinniEntity entities = new EdujinniEntity())
{
subject_details updatedCustomer = (from c in entities.subject_details
join p in entities.school_details on updating.school_id equals p.school_id
where c.subject_id == updating.subject_id
where c.school_id == updating.school_id
select c).FirstOrDefault();
updatedCustomer.subject_name = updating.subject_name;
updatedCustomer.subject_type = updating.subject_type;
updatedCustomer.update_date = DateTime.Now;
entities.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}