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;
}
