private bool SaveBasicDetails(tbl_Std_Admission_Details basicdetails) { bool result = false; using (OnlineStudentAdmissionEntities1 _entity = new OnlineStudentAdmissionEntities1()) { int userid = Convert.ToInt32(Session["ID"].ToString()); UserLogIn _user = _entity.UserLogIn.Where(x => x.Id == userid).Select(x => x).FirstOrDefault(); basicdetails.Username = _user.Username; basicdetails.Password = _user.Password; if (Session["Admission_id"] == null) { _entity.tbl_Std_Admission_Details.Add(basicdetails); _entity.SaveChanges(); result = true; tbl_Std_Admission_Details _student = _entity.tbl_Std_Admission_Details.Where(x => x.CreatedBy == userid).Select(x => x).FirstOrDefault(); _student.Admission_Id = basicdetails.Admission_Id; Session["Admission_Id"] = _student.Admission_Id; } else { tbl_Std_Admission_Details _student = _entity.tbl_Std_Admission_Details.Where(x => x.CreatedBy == userid).Select(x => x).FirstOrDefault(); _student.Name = basicdetails.Name; _student.Mobile = basicdetails.Mobile; _student.Gender = basicdetails.Gender; _student.Category = basicdetails.Category; _entity.SaveChanges(); result = true; } } return(result); }
protected void Page_Load(object sender, EventArgs e) { using (OnlineStudentAdmissionEntities1 _entity = new OnlineStudentAdmissionEntities1()) { if (Session["ID"] != null) { int userid = Convert.ToInt32(Session["ID"]); tbl_Std_Admission_Details _student = _entity.tbl_Std_Admission_Details.Where(x => x.CreatedBy == userid).Select(x => x).FirstOrDefault(); if (_student != null) { if (_student.Admission_Id != null) { { Session["Admission_id"] = _student.Admission_Id; lblApplicantName.Text = _student.Name; lblAppplicationStatus.Text = _student.Application_Status ? "Submitted" : "Pending"; lblVerification.Text = _student.Verification_Status ? "Verified" : "Pending"; lblAdmission_Id.Text = _student.Admission_Id; if (_student.Application_Status == true) { Session["Application_Status"] = "Submitted"; } else { Session["Application_Status"] = "Pending"; } } } } } } }
protected void btnBasic_Click(object sender, EventArgs e) { try { using (OnlineStudentAdmissionEntities1 _entity = new OnlineStudentAdmissionEntities1()) { tbl_Std_Admission_Details basicdetails = new tbl_Std_Admission_Details(); basicdetails.Name = txtApplicantName.Text.Trim(); basicdetails.Mobile = Convert.ToInt32(txtMobile.Text); basicdetails.Email = txtEmail.Text.Trim(); basicdetails.Gender = rdGender.SelectedValue; basicdetails.Category = ddlCategory.SelectedValue; basicdetails.CreatedBy = Convert.ToInt32(Session["ID"]); basicdetails.CreatedDate = DateTime.Now; bool result; result = SaveBasicDetails(basicdetails); // calling SaveStudentDetails method to save the record in table.Here passing a basic details object as parameter if (result == true) { Response.Redirect("Dashboard.aspx"); } else { } } } catch (Exception ex) { } }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = gdDetails.Rows[e.RowIndex]; string Id = Convert.ToString(gdDetails.DataKeys[e.RowIndex].Values[0]); string name = (row.FindControl("txtName") as TextBox).Text; DateTime dt = Convert.ToDateTime((row.FindControl("txtDateofbirth") as TextBox).Text); int mobile = Convert.ToInt32((row.FindControl("txtMobile") as TextBox).Text); string email = (row.FindControl("txtEmail") as TextBox).Text; RadioButtonList gender = (row.FindControl("rdGender") as RadioButtonList); DropDownList ddlCategory = (row.FindControl("ddlCategory") as DropDownList); using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { try { tbl_Std_Admission_Details user = (from c in entities.tbl_Std_Admission_Details where c.Admission_Id == Id select c).FirstOrDefault(); user.Name = name; user.Dateofbirth = dt; user.Mobile = mobile; user.Email = email; user.Gender = gender.SelectedValue; user.Category = ddlCategory.SelectedValue; entities.SaveChanges(); } catch (Exception ex) { } } gdDetails.EditIndex = -1; this.BindGrid(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = gdStatus.Rows[e.RowIndex]; string Id = Convert.ToString(gdStatus.DataKeys[e.RowIndex].Values[0]); string name = (row.FindControl("txtName") as TextBox).Text; DropDownList ddlApplicantion = (row.FindControl("ddlApplicantion") as DropDownList); DropDownList ddlVerification = (row.FindControl("ddlVerification") as DropDownList); using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { try { tbl_Std_Admission_Details user = (from c in entities.tbl_Std_Admission_Details where c.Admission_Id == Id select c).FirstOrDefault(); user.Name = name; user.Application_Status = Convert.ToBoolean(ddlApplicantion.SelectedValue); user.Verification_Status = Convert.ToBoolean(ddlVerification.SelectedValue); entities.SaveChanges(); } catch (Exception ex) { } } gdStatus.EditIndex = -1; this.BindGrid(); }
protected void btnLogIn_Click(object sender, EventArgs e) { OnlineStudentAdmissionEntities1 stdAdm = new OnlineStudentAdmissionEntities1(); var result = stdAdm.GetLoginInfo(txtUsername.Text.Trim(), txtPassword.Text.Trim()); string str = result.FirstOrDefault(); if (str != "User Does not Exists") { string userid = str.Split(',')[0]; string IsAdmin = str.Split(',')[1]; Session["ID"] = userid; //Session["IsAdmin"] = IsAdmin; Session["username"] = txtUsername.Text.Trim(); if (IsAdmin == "1") { Response.Redirect("AdminDashboard.aspx"); } else { Response.Redirect("Dashboard.aspx"); } } else { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + str + "');", true); } }
private void BindGrid() { using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { gdDetails.DataSource = (from adm in entities.tbl_Std_Admission_Details select new { adm.Admission_Id, adm.Name, adm.Dateofbirth, adm.Mobile, adm.Email, adm.Gender, adm.Category }).ToList(); gdDetails.DataBind(); } }
private void BindGrid() { using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { gdStatus.DataSource = (from adm in entities.tbl_Std_Admission_Details select new { adm.Admission_Id, adm.Name, adm.Application_Status, adm.Verification_Status, adm.Username }).ToList(); gdStatus.DataBind(); } }
private void BindGrid() { using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { gdUserInfo.DataSource = (from user in entities.UserLogIn select new { user.Id, user.Username, user.Password }).ToList(); gdUserInfo.DataBind(); } }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { string Id = Convert.ToString(gdDetails.DataKeys[e.RowIndex].Values[0]); using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { tbl_Std_Admission_Details user = (from c in entities.tbl_Std_Admission_Details where c.Admission_Id == Id select c).FirstOrDefault(); entities.tbl_Std_Admission_Details.Remove(user); entities.SaveChanges(); } this.BindGrid(); }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int Id = Convert.ToInt32(gdUserInfo.DataKeys[e.RowIndex].Values[0]); using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { UserLogIn user = (from c in entities.UserLogIn where c.Id == Id select c).FirstOrDefault(); entities.UserLogIn.Remove(user); entities.SaveChanges(); } this.BindGrid(); }
protected void Insert(object sender, EventArgs e) { using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { UserLogIn user = new UserLogIn { Username = txtUserName.Text, Password = txtPassword.Text, IsAdmin = false, LoginDate = System.DateTime.Now }; entities.UserLogIn.Add(user); entities.SaveChanges(); txtPassword.Text = ""; txtUserName.Text = ""; } this.BindGrid(); }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = gdUserInfo.Rows[e.RowIndex]; int Id = Convert.ToInt32(gdUserInfo.DataKeys[e.RowIndex].Values[0]); string name = (row.FindControl("txtName") as TextBox).Text; string password = (row.FindControl("txtPassword") as TextBox).Text; using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { UserLogIn user = (from c in entities.UserLogIn where c.Id == Id select c).FirstOrDefault(); user.Username = name; user.Password = password; entities.SaveChanges(); } gdUserInfo.EditIndex = -1; this.BindGrid(); }
protected void OnRowEditing(object sender, GridViewEditEventArgs e) { gdDetails.EditIndex = e.NewEditIndex; this.BindGrid(); GridViewRow row = gdDetails.Rows[e.NewEditIndex]; string Id = Convert.ToString(gdDetails.DataKeys[e.NewEditIndex].Values[0]); TextBox txtDateofbirth = (row.FindControl("txtDateofbirth") as TextBox); RadioButtonList rdGender = (row.FindControl("rdGender") as RadioButtonList); using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { try { tbl_Std_Admission_Details user = (from c in entities.tbl_Std_Admission_Details where c.Admission_Id == Id select c).FirstOrDefault(); txtDateofbirth.Text = user.Dateofbirth.ToString("yyyy-MM-dd"); rdGender.SelectedValue = user.Gender; } catch (Exception ex) { } } }
protected void OnRowEditing(object sender, GridViewEditEventArgs e) { gdStatus.EditIndex = e.NewEditIndex; this.BindGrid(); GridViewRow row = gdStatus.Rows[e.NewEditIndex]; string Id = Convert.ToString(gdStatus.DataKeys[e.NewEditIndex].Values[0]); DropDownList ddlApplicantion = (row.FindControl("ddlApplicantion") as DropDownList); DropDownList ddlVerification = (row.FindControl("ddlVerification") as DropDownList); using (OnlineStudentAdmissionEntities1 entities = new OnlineStudentAdmissionEntities1()) { try { tbl_Std_Admission_Details user = (from c in entities.tbl_Std_Admission_Details where c.Admission_Id == Id select c).FirstOrDefault(); ddlApplicantion.SelectedValue = Boolean.Parse((user.Application_Status).ToString())?"true":"false"; ddlVerification.SelectedValue = Boolean.Parse((user.Verification_Status).ToString()) ? "true" : "false"; } catch (Exception ex) { } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["Admission_id"] != null) { using (OnlineStudentAdmissionEntities1 _entity = new OnlineStudentAdmissionEntities1()) { string Admission_id = Convert.ToString(Session["Admission_id"]); tbl_Std_Admission_Details _student = _entity.tbl_Std_Admission_Details.Where(x => x.Admission_Id == Admission_id).Select(x => x).FirstOrDefault(); txtApplicantName.Text = _student.Name; txtMobile.Text = Convert.ToString(_student.Mobile); txtEmail.Text = _student.Email; rdGender.SelectedValue = _student.Gender; ddlCategory.SelectedValue = _student.Category; if (((string)Session["Application_Status"]) == "Submitted") { btnBasic.Enabled = false; } } } } }