protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e) { decimal totalfees = 0; foreach (ListItem item in ddlCourse.Items) { if (item.Selected) { int courseid = Convert.ToInt32(item.Value); aspccEntities objdb = new aspccEntities(); var coursedetails = objdb.Courses.Where(x => x.Id == courseid).FirstOrDefault(); if (coursedetails != null) { totalfees = +(totalfees + coursedetails.Fee); } } } txtTotalFees.Text = Convert.ToString(totalfees); txtNetFees.Text = Convert.ToString(totalfees); List <string> keys = Request.Form.AllKeys.Where(key => key.Contains("txtrdInstallment")).ToList(); int intallment = keys.Count; if (intallment == 0) { txtDisCount.Text = "0"; btnAddInstallment_Click(sender, e); } }
protected void btnLogin_Click(object sender, EventArgs e) { try { string UserName = txtEmail.Text.Trim(); string pwd = txtpwd.Value; using (aspccEntities db = new aspccEntities()) { var result = db.Users.Where(x => x.UserName == UserName && x.PassWord == pwd).FirstOrDefault(); if (result != null) { Session["userDetails"] = result.UserName; if (result.UserType == 1) { Response.Redirect("~/admin/Dashboard.aspx"); } else { Response.Redirect("~/Students/Dashboard.aspx"); } } else { DivError.Visible = true; lblErrorMsg.Text = "User Id or Password Incorrect."; } } } catch (Exception ex) { DivError.Visible = true; } }
protected void btnChangePws_Click(object sender, EventArgs e) { try { string pwd = txtpwd.Value; string Oldpwd = txtOldPwd.Value; string Confirmpwd = txtConfirmpwd.Value; string user = Session["userDetails"].ToString(); aspccEntities dataBase = new aspccEntities(); User objuser = dataBase.Users.Where(x => x.UserName == user && x.PassWord == Oldpwd).First(); if (objuser == null) { DivError.Visible = true; lblErrorMsg.Text = "Old password Incorrect"; } else if (Confirmpwd != pwd) { DivError.Visible = true; lblErrorMsg.Text = "Password and Confirm password does not match."; } else { objuser.PassWord = Confirmpwd; dataBase.SaveChanges(); Response.Redirect("~/Login.aspx"); } } catch (Exception ex) { DivError.Visible = true; lblErrorMsg.Text = "Old password Incorrect"; } }
public void bindCityDropDown() { using (aspccEntities db = new aspccEntities()) { var citylist = db.Cities.ToList(); ddlCity.DataSource = citylist; ddlCity.DataTextField = "CityName"; ddlCity.DataValueField = "Id"; ddlCity.DataBind(); } }
public void bindAreaDropDown() { using (aspccEntities db = new aspccEntities()) { var Arealist = db.Areas.ToList(); ddlArea.DataSource = Arealist; ddlArea.DataTextField = "AreaName"; ddlArea.DataValueField = "Id"; ddlArea.DataBind(); } }
public void DataBaseBackUp(string dbpath) { try { using (aspccEntities db = new aspccEntities()) { db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, @"DECLARE @DBName NVARCHAR(max); SET @DBName = 'aspcc ' + CONVERT(nvarchar(50), getdate(), 113) + '.bak'; SET @DBName = '" + dbpath + "\\'+REPLACE(REPLACE(@DBName,' ',''),':',''); BACKUP DATABASE aspcc TO DISK = @DBName WITH NOFORMAT, INIT, NAME = N'aspcc Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"); } } catch (Exception ex) { } }
public void DeleteCourse(int id) { try { using (aspccEntities db = new aspccEntities()) { db.DeleteCourse(id); } } catch (Exception ex) { } }
public void Loginsert(string url, string method, string error, string innermgs) { try { using (aspccEntities db = new aspccEntities()) { db.InsertLog(error, url, method, innermgs); } } catch (Exception ex) { } }
public void Deleteexam(int id) { try { using (aspccEntities db = new aspccEntities()) { db.DeleteExam(id); } } catch (Exception ex) { com.Loginsert("DalDeleteexam", "Deleteexam", ex.StackTrace, ex.Message); } }
public void CopyExam(int fromid, int toid) { try { using (aspccEntities db = new aspccEntities()) { db.ExamCopyQuestion(fromid, toid); } } catch (Exception ex) { com.Loginsert("DalgetStudentexamById", "CopyExam", ex.StackTrace, ex.Message); } }
public void DeleteInquiry(int id) { try { using (aspccEntities db = new aspccEntities()) { db.DeleteInquiry(id); } } catch (Exception ex) { com.Loginsert("/admin/InquiryList", "DeleteInquiry", ex.StackTrace, ex.Message); } }
public void updateStudentExam(int Id, int StudentExamId, int QuestionId) { try { using (aspccEntities db = new aspccEntities()) { db.updateStudentExam(Id, StudentExamId, QuestionId); } } catch (Exception ex) { com.Loginsert("DalupdateStudentExam", "updateStudentExam", ex.StackTrace, ex.Message); } }
public void DeleteAdmission(int id) { try { using (aspccEntities db = new aspccEntities()) { db.DeleteAdmission(id); } } catch (Exception ex) { com.Loginsert("admin/AdmissionList", "DeleteAdmission", ex.StackTrace, ex.Message); } }
public int ExamQuestionInsertUpdate(clsExamQuestionOp objExamQuestionOp) { try { using (aspccEntities db = new aspccEntities()) { var result = db.ExamQuestionInsertUpdate(objExamQuestionOp.Id, objExamQuestionOp.ExamId, objExamQuestionOp.Question, objExamQuestionOp.Option1, objExamQuestionOp.Option2, objExamQuestionOp.Option3, objExamQuestionOp.Option4, objExamQuestionOp.CorrectAns); return(1); } } catch (Exception ex) { return(0); } }
public int InsertUpdateAdminssion(clsAdmission objAdmissio) { try { using (aspccEntities db = new aspccEntities()) { var result = db.InsertUpdateAdmission(objAdmissio.Id, objAdmissio.fname, objAdmissio.Mname, objAdmissio.Lname, objAdmissio.Address, objAdmissio.MobileH, objAdmissio.MobileF, objAdmissio.MobileP, objAdmissio.Email, objAdmissio.AreId, objAdmissio.QualificationId, objAdmissio.StreamId, objAdmissio.OccupationId, objAdmissio.CourseId, objAdmissio.SchoolName, objAdmissio.BirthDate, objAdmissio.PreferTimeTO, objAdmissio.PreferTimeFrom, objAdmissio.Remark, objAdmissio.TotalFees, objAdmissio.DisCount, objAdmissio.NetFees, objAdmissio.NoOfInstallment, objAdmissio.Installment1Rs, objAdmissio.Installment1Date, objAdmissio.Installment2Rs, objAdmissio.Installment2Date, objAdmissio.Installment3Rs, objAdmissio.Installment3Date, objAdmissio.Installment4Rs, objAdmissio.Installment4Date, objAdmissio.Installment5Rs, objAdmissio.Installment5Date, objAdmissio.Installment6Rs, objAdmissio.Installment6Date, objAdmissio.Installment7Rs, objAdmissio.Installment7Date, objAdmissio.Installment8Rs, objAdmissio.Installment8Date, objAdmissio.Installment9Rs, objAdmissio.Installment9Date, objAdmissio.Installment10Rs, objAdmissio.Installment10Date, objAdmissio.ModBy, objAdmissio.AdmissionNo, objAdmissio.RegNo, objAdmissio.AdmissionDate); return(1); } } catch (Exception ex) { com.Loginsert("admin/AdmissionAddEdit", "InsertUpdateAdminssion", ex.StackTrace, ex.Message); return(0); } }
public getCourseById_Result GetCourseById(int?id) { try { getCourseById_Result objcourse = new getCourseById_Result(); using (aspccEntities db = new aspccEntities()) { objcourse = db.getCourseById(id).FirstOrDefault(); return(objcourse); } } catch (Exception ex) { return(null); } }
public int InsertUpdateInquiry(ClsInquiry objClsInquiry) { try { using (aspccEntities db = new aspccEntities()) { var result = db.InsertUpdateInquiry(objClsInquiry.Id, objClsInquiry.fname, objClsInquiry.lname, objClsInquiry.CourseID, objClsInquiry.EmailId, objClsInquiry.Mobile, objClsInquiry.Address, objClsInquiry.AreaId, objClsInquiry.City, objClsInquiry.PreferTimeFrom, objClsInquiry.PreferTimeFrom, objClsInquiry.Final, objClsInquiry.Notes, objClsInquiry.EntBy, objClsInquiry.ModBy); return(1); } } catch (Exception ex) { com.Loginsert("/admin/InquiryAddEdit", "InsertUpdateInquiry", ex.StackTrace, ex.Message); return(0); } }
public List <getCourseList_Result> GetCourseList() { try { List <getCourseList_Result> courselist = new List <getCourseList_Result>(); using (aspccEntities db = new aspccEntities()) { courselist = db.getCourseList().ToList(); return(courselist); } } catch (Exception ex) { return(null); } }
public int CourseInsertUpdate(clsCourse objcourse) { try { using (aspccEntities db = new aspccEntities()) { var result = db.CourseInsertUpdate(objcourse.Id, objcourse.CourseName, objcourse.Fee, objcourse.Duration, objcourse.Active, 1, 1); //return Convert.ToInt32(result.FirstOrDefault()); return(1); } } catch (Exception ex) { return(0); } }
public int UpdateQuestionAnswere(int StudentExamDetailsId, int StudentExamId, int QuestionId, int Answer) { try { using (aspccEntities db = new aspccEntities()) { db.UpdateQuestionAnswere(StudentExamDetailsId, StudentExamId, QuestionId, Answer); return(1); } } catch (Exception ex) { com.Loginsert("DALUpdateQuestionAnswere", "UpdateQuestionAnswere", ex.StackTrace, ex.Message); return(0); } }
public int ExamInsertUpdate(clsExam objExam) { try { using (aspccEntities db = new aspccEntities()) { var result = db.ExamInsertUpdate(objExam.Id, objExam.CoruserId, objExam.Name, objExam.noofQestion, objExam.Isactive); return(1); } } catch (Exception ex) { com.Loginsert("DalExamInsertUpdate", "ExamInsertUpdate", ex.StackTrace, ex.Message); return(0); } }
public List <getAdmissionList_Result> GetAdminssionList() { try { List <getAdmissionList_Result> Adminssionlist = new List <getAdmissionList_Result>(); using (aspccEntities db = new aspccEntities()) { Adminssionlist = db.getAdmissionList().ToList(); return(Adminssionlist); } } catch (Exception ex) { com.Loginsert("Adminssionlist", "Adminssionlist", ex.StackTrace, ex.Message); return(null); } }
public List <ChkExamFinish_Result> checkExamFinish(int studentid, int examid) { try { List <ChkExamFinish_Result> ExamDetailslist = new List <ChkExamFinish_Result>(); using (aspccEntities db = new aspccEntities()) { ExamDetailslist = db.ChkExamFinish(studentid, examid).ToList(); return(ExamDetailslist); } } catch (Exception ex) { com.Loginsert("DalcheckExamFinish", "checkExamFinish", ex.StackTrace, ex.Message); return(null); } }
public getexamById_Result GetexamById(int?id) { try { getexamById_Result objexam = new getexamById_Result(); using (aspccEntities db = new aspccEntities()) { objexam = db.getexamById(id).FirstOrDefault(); return(objexam); } } catch (Exception ex) { com.Loginsert("DalGetexamById", "GetexamById", ex.StackTrace, ex.Message); return(null); } }
public GetStdUPdateQuestionAnswereById_Result GetStdUPdateQuestionAnswereById(int StudentExamDetailsId) { try { using (aspccEntities db = new aspccEntities()) { GetStdUPdateQuestionAnswereById_Result questiodetails = new GetStdUPdateQuestionAnswereById_Result(); questiodetails = db.GetStdUPdateQuestionAnswereById(StudentExamDetailsId).FirstOrDefault(); return(questiodetails); } } catch (Exception ex) { com.Loginsert("DalGetStdUPdateQuestionAnswereById", "GetStdUPdateQuestionAnswereById", ex.StackTrace, ex.Message); return(null); } }
public List <GetStdExamDetailsById_Result> GetStdExamDetailsById(int?StudentExamId) { try { using (aspccEntities db = new aspccEntities()) { List <GetStdExamDetailsById_Result> StudentExamDetails = new List <GetStdExamDetailsById_Result>(); StudentExamDetails = db.GetStdExamDetailsById(StudentExamId).ToList(); return(StudentExamDetails); } } catch (Exception ex) { com.Loginsert("DalcheckExamFinish", "checkExamFinish", ex.StackTrace, ex.Message); return(null); } }
public InsertExamStudentAttemptBystdId_Result InsertExamStudentAttemptBystdId(int?id, int studentid, int examid) { try { using (aspccEntities db = new aspccEntities()) { InsertExamStudentAttemptBystdId_Result StudentExamID = new InsertExamStudentAttemptBystdId_Result(); StudentExamID = db.InsertExamStudentAttemptBystdId(id, studentid, examid).FirstOrDefault(); return(StudentExamID); } } catch (Exception ex) { com.Loginsert("DalInsertExamStudentAttemptBystdId", "InsertExamStudentAttemptBystdId", ex.StackTrace, ex.Message); return(null); } }
public getAdmissionById_Result GetAdminssionById(int?id) { try { getAdmissionById_Result objAdminssion = new getAdmissionById_Result(); using (aspccEntities db = new aspccEntities()) { objAdminssion = db.getAdmissionById(id).FirstOrDefault(); return(objAdminssion); } } catch (Exception ex) { com.Loginsert("admin/AdmissionAddEdit", "GetAdminssionById", ex.StackTrace, ex.Message); return(null); } }
public List <viewResultByStdId_Result> viewResultByStdId(int StudentId, int Examid) { try { using (aspccEntities db = new aspccEntities()) { List <viewResultByStdId_Result> viewResult = new List <viewResultByStdId_Result>(); viewResult = db.viewResultByStdId(StudentId, Examid).ToList(); return(viewResult); } } catch (Exception ex) { com.Loginsert("DalviewResultByStdId", "viewResultByStdId", ex.StackTrace, ex.Message); return(null); } }
public List <getStudentExamResultbyStdExamId_Result> getStudentExamResultbyStdExamId(int Id) { try { using (aspccEntities db = new aspccEntities()) { List <getStudentExamResultbyStdExamId_Result> StudentExamrresultDetails = new List <getStudentExamResultbyStdExamId_Result>(); StudentExamrresultDetails = db.getStudentExamResultbyStdExamId(Id).ToList(); return(StudentExamrresultDetails); } } catch (Exception ex) { com.Loginsert("DalgetStudentExamResultbyStdExamId", "getStudentExamResultbyStdExamId", ex.StackTrace, ex.Message); return(null); } }