public Boolean addingSchool(school_details sdetails) { List <school_details> cdetails = new List <school_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { cdetails = dc.school_details.OrderBy(a => a.school_name).ToList(); int cc = cdetails.Count; for (int i = 0; i < cc; i++) { mnumber = Convert.ToInt64(cdetails[i].admin_mobile_no); email = cdetails[i].admin_email; if (sdetails.admin_mobile_no.Equals(mnumber) && sdetails.admin_email.Equals(email)) { // scl_id = cdetails[i].school_id; count = 1; break; } else { count = 0; } } } if (count == 0) { return(true); } else { return(false); } }
public Boolean updateExamSubjectsList(school_details eupdate) { List <school_details> tlist = new List <school_details>(); using (EdujinniEntity dc = new EdujinniEntity()) { tlist = dc.school_details.OrderBy(a => a.school_name).ToList(); int cc = tlist.Count; for (int i = 0; i < cc; i++) { mnumber = Convert.ToInt64(tlist[i].admin_mobile_no); email = tlist[i].admin_email; // mnumber = tlist[i].school_phone_no; if (eupdate.admin_mobile_no.Equals(mnumber)) { count = 0; break; } else { count = 1; } } } if (count == 0) { using (EdujinniEntity entities = new EdujinniEntity()) { school_details updatedCustomer = (from c in entities.school_details //join p in entities.school_details on eupdate.school_id equals p.school_id where c.admin_mobile_no == eupdate.admin_mobile_no select c).FirstOrDefault(); updatedCustomer.password = eupdate.password; updatedCustomer.update_date = DateTime.Now; entities.SaveChanges(); } return(true); } else { return(false); } }
public Boolean adminLogin(school_details sdetails) { List <school_details> login = new List <school_details>(); using (EdujinniEntity entitu = new EdujinniEntity()) { login = entitu.school_details.OrderBy(a => a.school_name).ToList(); int cc = login.Count; for (int i = 0; i < cc; i++) { // mnumber = login[i].school_phone_no; mnumber = Convert.ToInt64(login[i].admin_mobile_no); email = login[i].admin_email; password = login[i].password; if (sdetails.admin_mobile_no.Equals(mnumber) || sdetails.admin_email.Equals(email)) { if (sdetails.password.Equals(password)) { count = 1; break; } } else { count = 0; } } } if (count == 1) { return(true); } else { return(false); } }