public Boolean addingAchievemnts(Achievement_details adding)
{
List <Achievement_details> list = new List <Achievement_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList();
int cc = list.Count;
for (int i = 0; i < cc; i++)
{
mnumber = list[i].achievement_type;
studentId = list[i].student_id;
sclId = list[i].school_id;
if (adding.achievement_type.Equals(mnumber) && adding.student_id.Equals(studentId) && adding.school_id.Equals(sclId))
{
count = 1;
break;
}
else
{
count = 0;
}
}
}
if (count == 0)
{
return(true);
}
else
{
return(false);
}
}
public Boolean updateAchievements(Achievement_details adetails)
{
List <Achievement_details> list = new List <Achievement_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList();
int cc = list.Count;
for (int i = 0; i < cc; i++)
{
int achId = list[i].achievement_id;
int sclId = list[i].school_id;
//mnumber = list[i].achievement_type;
//studentId = list[i].student_id;
if (adetails.school_id.Equals(sclId) && adetails.achievement_id.Equals(achId))
{
count = 1;
break;
}
else
{
count = 0;
}
}
}
if (count == 1)
{
using (EdujinniEntity entities = new EdujinniEntity())
{
Achievement_details updatedCustomer = (from c in entities.Achievement_details
where c.achievement_id == adetails.achievement_id
where c.school_id == adetails.school_id
select c).FirstOrDefault();
updatedCustomer.class_id = adetails.class_id;
updatedCustomer.section_id = adetails.section_id;
updatedCustomer.student_id = adetails.student_id;
updatedCustomer.achievement_student_name = adetails.achievement_student_name;
updatedCustomer.achievement_description = adetails.achievement_description;
updatedCustomer.achievement_date = adetails.achievement_date;
updatedCustomer.update_date = DateTime.Now;
entities.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
public Boolean deleteAchievements(Achievement_details adata)
{
List <Achievement_details> list = new List <Achievement_details>();
using (EdujinniEntity dc = new EdujinniEntity())
{
list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList();
int cc = list.Count;
for (int i = 0; i < cc; i++)
{
int aId = list[i].achievement_id;
sclId = list[i].school_id;
if (adata.achievement_id.Equals(aId) && adata.school_id.Equals(sclId))
{
count = 1;
break;
}
else
{
count = 0;
}
}
}
if (count == 1)
{
using (EdujinniEntity entities = new EdujinniEntity())
{
Achievement_details custom = (from c in entities.Achievement_details
where c.achievement_id == adata.achievement_id
where c.school_id == adata.school_id
select c).FirstOrDefault();
entities.Achievement_details.Remove(custom);
entities.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
