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