public void AddRegistrationNotice(Mails_tbl t) { db = new CollegeERPDBEntities(); db.Mails_tbl.Add(t); db.SaveChanges(); }
public static string SubmitCommentsToStudents(int UserIDs, string Comments, int page) { DBFunctions db = new DBFunctions(); db.UpdateSuggestionStatus(UserIDs); Mails_tbl temp = new Mails_tbl { RecieverID = UserIDs, Message = Comments, Subject = "SuggestionRequest", Status = 0, Date = DateTime.Now }; db.addmail(temp); List <UploadedQuestionaire> ques = db.getquestionairlist(page - 1, 10); return(ListAllQuestionaire_2(ques) + "?" + temp1); }
protected void Page_Load(object sender, EventArgs e) { string pagename = Path.GetFileName(Request.PhysicalPath); if (Session["admin"] != null) { if (!IsPostBack) { DBFunctions db = new DBFunctions(); Mails_tbl obj = new Mails_tbl {Message = "Registration for the new courses has been started. <a href=\"../EnrollCourse.aspx\">Click Here</a> to register. ",Subject="Registration",Status=0,Date=DateTime.Now }; db.AddRegistrationNotice(obj); db.UpdateStudentsCredits(); db.UpdateStudentSemester(); } } else { Response.Redirect("Login.aspx?Redirecturl=" + pagename); } }
protected void Page_Load(object sender, EventArgs e) { string pagename = Path.GetFileName(Request.PhysicalPath); if (Session["admin"] != null) { if (!IsPostBack) { DBFunctions db = new DBFunctions(); Mails_tbl obj = new Mails_tbl { Message = "Registration for the new courses has been started. <a href=\"../EnrollCourse.aspx\">Click Here</a> to register. ", Subject = "Registration", Status = 0, Date = DateTime.Now }; db.AddRegistrationNotice(obj); db.UpdateStudentsCredits(); db.UpdateStudentSemester(); } } else { Response.Redirect("Login.aspx?Redirecturl=" + pagename); } }
public void addmail(Mails_tbl mail) { db = new CollegeERPDBEntities(); db.Mails_tbl.Add(mail); db.SaveChanges(); }
public void addadmssion(List<Candidate_tbl> candidatelist) { db = new CollegeERPDBEntities(); int prgid=-1; foreach(var cand in candidatelist) { string matricno=DateTime.Now.Year+"-"+cand.Program_tbl.ProgramName+"-"+cand.ID; var std = db.AddmissionList_tbl.Where(x=>x.UserID==cand.ID).FirstOrDefault(); var info = db.StudentInfo_tbl.Where(x => x.UserId == cand.ID).FirstOrDefault(); if(std==null&&info==null){ StudentInfo_tbl student = new StudentInfo_tbl { ProgramID = cand.ProgrammeID, StudentLevel = "ND1", UserId = cand.ID, Semester = 0, DeptID = cand.Program_tbl.DeptID, FeeDiscount = "0", AcadamicYear = DateTime.Now.Year.ToString() }; StudentAcceptanceFee_tbl accfee = new StudentAcceptanceFee_tbl { ProgramID = cand.ProgrammeID, Userid = cand.ID, Status = 0 }; Mails_tbl mail = new Mails_tbl { RecieverID = cand.ID, Message ="Acceptence Fee Of "+ cand.Program_tbl.AcceptenceFee + " Has Been Assigned to You <br> Please Submit This Fees with in One Week", Subject = "Acceptence Fee", Date = DateTime.Now,Status=0 }; addmail(mail); db.StudentInfo_tbl.Add(student); int Year = Convert.ToInt16(student.AcadamicYear); Batches_table temp = db.Batches_table.Where(x => x.BatchYear == Year).FirstOrDefault(); AddmissionList_tbl admission = new AddmissionList_tbl { ProgrameID = cand.ProgrammeID, Status = 0, route = "Merit", UserID = cand.ID, MetricNo = matricno, Password = cand.Password,BatchID=temp.ID }; db.AddmissionList_tbl.Add(admission); db.StudentAcceptanceFee_tbl.Add(accfee); prgid = cand.ProgrammeID.Value; } var candidates = db.Candidate_tbl.Where(x => x.ProgrammeID == prgid).OrderByDescending(x => x.CuttoffPoints).Skip(100).ToList(); foreach(var c in candidates) { c.Status = -1; } var addmittedcandidates = db.Candidate_tbl.Where(x => x.ProgrammeID == prgid).OrderByDescending(x => x.CuttoffPoints).Take(100).ToList(); foreach (var c in addmittedcandidates) { c.Status = 1; } } db.SaveChanges(); }
public void updatequestion(Support_tbl ques) { db = new CollegeERPDBEntities(); db.Support_tbl.Attach(ques); // var progrm = db.Program_tbl.Where(x => x.ID == id).FirstOrDefault(); db.Entry(ques).State = EntityState.Modified; db.SaveChanges(); Mails_tbl mail = new Mails_tbl { RecieverID =ques.UserID, Date = DateTime.Now.Date, Message =ques.Answer, Status = 0, Subject = "Admin Answer" }; addmail(mail); }
public void updateenrollment(int appid,string status) { db = new CollegeERPDBEntities(); Enroll_Course ec = db.Enroll_Course.Where(x => x.ID == appid).FirstOrDefault(); ec.Status=int.Parse(status); db.SaveChanges(); if(status=="1") { assigncouresefee(ec.Uid.Value, ec.CourseID.Value); Mails_tbl mail = new Mails_tbl { RecieverID = ec.Uid, Date = DateTime.Now.Date, Message = "Your Enrollment Application for " + ec.Courses_tbl.Course + " has been approved, Please Submit $"+ec.Courses_tbl.Fee, Status = 0, Subject = "Enrollment Applications" }; addmail(mail); } else if(status=="-1") { Mails_tbl mail = new Mails_tbl { RecieverID = ec.Uid, Date = DateTime.Now.Date, Message = "Your Enrollment Application for " + ec.Courses_tbl.Course + " has been Rejected", Status = 0, Subject = "Enrollment Applications" }; addmail(mail); } }
public void acceptRequest(int reqid) { db = new CollegeERPDBEntities(); var member= db.LibraryMembers.Where(x => x.ID == reqid).FirstOrDefault(); member.Status = 1; member.JoinDate = DateTime.Now.Date; db.SaveChanges(); Mails_tbl mail = new Mails_tbl { RecieverID =member.UserID, Date = DateTime.Now.Date, Message = "Your Liberary Membership Request has been approved", Status = 0, Subject = "Liberary Membership" }; addmail(mail); }
public void updateorder(int id, int status) { db = new CollegeERPDBEntities(); var room = db.StudentRoom_Mapping.Where(x => x.ID == id).FirstOrDefault(); if (status == 1) { room.HostelRoom_tbl.Capacity -= 1; room.Status = status; db.SaveChanges(); Mails_tbl amail = new Mails_tbl { RecieverID = room.StudentID, Message = "your Request for Room No." + room.HostelRoom_tbl.RoomNo + " in " + room.HostelRoom_tbl.Hostel_tbl.Name + " Hostel has been approved", Date = DateTime.Now.Date, Subject = "Room Request", Status = 0 }; addmail(amail); } if (status == -1) { room.Status = status; db.SaveChanges(); Mails_tbl amail = new Mails_tbl { RecieverID = room.StudentID, Message = "your Request for Room No." + room.HostelRoom_tbl.RoomNo + " in " + room.HostelRoom_tbl.Hostel_tbl.Name + " Hostel has been Rejected", Date = DateTime.Now.Date, Subject = "Room Request", Status = 0 }; addmail(amail); } if(status==5) { room.HostelRoom_tbl.Capacity += 1; db.StudentRoom_Mapping.Remove(room); db.SaveChanges(); Mails_tbl amail = new Mails_tbl { RecieverID = room.StudentID, Message = "your Request for leaving Room No." + room.HostelRoom_tbl.RoomNo + " in " + room.HostelRoom_tbl.Hostel_tbl.Name + " Hostel has been Approved", Date = DateTime.Now.Date, Subject = "Room Leave Request", Status = 0 }; addmail(amail); return; } //room.Status = status; //db.SaveChanges(); }
public static string SubmitCommentsToStudents(int UserIDs, string Comments, int page) { DBFunctions db = new DBFunctions(); db.UpdateSuggestionStatus(UserIDs); Mails_tbl temp = new Mails_tbl { RecieverID = UserIDs, Message = Comments, Subject = "SuggestionRequest", Status = 0, Date = DateTime.Now }; db.addmail(temp); List<UploadedQuestionaire> ques = db.getquestionairlist(page-1, 10); return ListAllQuestionaire_2(ques) + "?" + temp1; }