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