public string UpdateStudentRecord(tblStudentRecord model)
{
string result = string.Empty;
try
{
int count = _db.tblStudentRecords.Where(a => a.ID != model.ID && a.RollNo == model.RollNo).Count();
if (count > 0)
{
result = "-1";
return(result);
}
tblStudentRecord data = _db.tblStudentRecords.Where(a => a.ID == model.ID).FirstOrDefault();
if (data != null)
{
data.Address = model.Address;
data.City = model.City;
data.Email = model.Email;
data.LastUpdatedDate = model.LastUpdatedDate;
data.Name = model.Name;
data.Phone = model.Phone;
data.RollNo = model.RollNo;
data.State = model.State;
data.ClassId = model.ClassId;
_db.SaveChanges();
result = "1";
}
}
catch (Exception a1)
{
}
return(result);
}
public tblStudentRecord GetTblStudentRecordById(int id)
{
tblStudentRecord tblStudentRecord = new tblStudentRecord();
tblStudentRecord = _db.tblStudentRecords.Where(a => a.Id == id).FirstOrDefault();
return(tblStudentRecord);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind_course();
bind_year();
if (Request.QueryString["ID"] != null)
{
hddn_studentId.Value = Request.QueryString["ID"].ToString();
btn_submit.Text = "Update";
btn_submit.CommandName = "update";
btn_submit.CommandArgument = hddn_studentId.Value;
tblStudentRecord data = mm.GetTblStudentRecordById(Convert.ToInt32(hddn_studentId.Value));
if (data != null)
{
txt_address.Text = data.Address;
txt_batch.Text = data.Batch;
txt_city.Text = data.City;
txt_email.Text = data.EmailId;
txt_fatherName.Text = data.FatherName;
txt_motherName.Text = data.MotherName;
txt_name.Text = data.Name;
txt_phoneNumber.Text = data.PhoneNumber;
txt_pincode.Text = data.Pincode;
txt_state.Text = data.State;
ddl_course.SelectedValue = data.CourseId.ToString();
ddl_year.SelectedValue = data.YearId.ToString();
}
}
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
tblStudentRecord data = new tblStudentRecord();
data.Address = txt_address.Text.Trim();
data.Batch = txt_batch.Text.Trim();
data.City = txt_city.Text.Trim();
data.CourseId = Convert.ToInt32(ddl_course.SelectedValue);
data.EmailId = txt_email.Text.Trim();
data.FatherName = txt_fatherName.Text.Trim();
data.LastUpdatedDate = DateTime.UtcNow;
data.MotherName = txt_motherName.Text.Trim();
data.Name = txt_name.Text.Trim();
data.PhoneNumber = txt_phoneNumber.Text.Trim();
data.Pincode = txt_pincode.Text.Trim();
data.State = txt_state.Text.Trim();
data.YearId = Convert.ToInt32(ddl_year.SelectedValue);
if (btn_submit.CommandName == "add")
{
data.CreatedDate = DateTime.UtcNow;
int id = mm.AddStudentRecord(data);
if (id > 0)
{
clear();
Page.RegisterStartupScript("puneet", "<script>opendialog(1,\"Your profile added successfully\");window.setTimeout(function(){window.location.href = \"/viewstudentrecords\"}, 3000);</script>");
}
else if (id == -1)
{
Page.RegisterStartupScript("puneet", "<script>opendialog(2,\"Email or Phonenumber is already exists. Please try another\");</script>");
}
else
{
Page.RegisterStartupScript("puneet", "<script>opendialog(2,\"Error! in adding your profile\");</script>");
}
}
else if (btn_submit.CommandName == "update")
{
data.Id = Convert.ToInt32(btn_submit.CommandArgument);
string result = mm.updateStudentRecord(data);
if (result == "1")
{
clear();
Page.RegisterStartupScript("puneet", "<script>opendialog(1,\"Your profile updated successfully\");window.setTimeout(function(){window.location.href = \"/viewstudentrecords\"}, 3000);</script>");
}
else if (result == "-1")
{
Page.RegisterStartupScript("puneet", "<script>opendialog(2,\"Email or Phonenumber is already exists. Please try another\");</script>");
}
else
{
Page.RegisterStartupScript("puneet", "<script>opendialog(2,\"Error! in updating your profile\");</script>");
}
}
}
public bool DeletetblStudentRecord(int id)
{
bool status = false;
tblStudentRecord tblStudentRecord = _db.tblStudentRecords.Where(a => a.Id == id).FirstOrDefault();
if (tblStudentRecord != null)
{
_db.tblStudentRecords.Remove(tblStudentRecord);
_db.SaveChanges();
status = true;
}
return(status);
}
//Gridview Eventfire to show full record of student.
protected void grd_ShowView_RowCommand(object sender, GridViewCommandEventArgs e)
{
int id = 0;
Int32.TryParse(e.CommandArgument.ToString(), out id);
if (e.CommandName == "edt")
{
btn_save.CommandArgument = id.ToString();
btn_save.CommandName = "update";
btn_save.Text = "Update";
tblStudentRecord data = mm.GetStudentRecordByID(id);
if (data != null)
{
pnl_saveData.Visible = true;
pnl_showGrid.Visible = false;
txt_address.Text = data.Address;
txt_city.Text = data.City;
txt_email.Text = data.Email;
txt_name.Text = data.Name;
txt_phone.Text = data.Phone;
txt_rollNo.Text = data.RollNo;
txt_state.Text = data.State;
if (data.ClassId > 0)
{
ddl_class.SelectedValue = data.ClassId.ToString();
div_teacher.Style.Add("display", "block");
ddl_teacher.DataSource = mm.GetTeacherByID(data.ClassId.Value);
ddl_teacher.DataTextField = "TeacherName";
ddl_teacher.DataValueField = "Id";
ddl_teacher.DataBind();
ddl_teacher.Enabled = false;
}
}
}
//Create method to delete the record.
else if (e.CommandName == "dlt")
{
bool status = mm.DeleteStudentRecordById(id);
if (status == true)
{
bind_showStudentRecords();
}
}
}
//Create function to delete record from database.
public bool DeleteStudentRecordById(int id)
{
bool status = false;
try
{
tblStudentRecord tblStudentRecord = _db.tblStudentRecords.Where(a => a.ID == id).FirstOrDefault();
if (tblStudentRecord != null)
{
_db.tblStudentRecords.Remove(tblStudentRecord);
_db.SaveChanges();
status = true;
}
}
catch (Exception a1)
{ }
return(status);
}
public string updateStudentRecord(tblStudentRecord model)
{
string result = "0";
tblStudentRecord tblStudentRecord = new tblStudentRecord();
try
{
int count = _db.tblStudentRecords.Where(a => a.Id != model.Id && (a.EmailId == model.EmailId || a.PhoneNumber == model.PhoneNumber)).Count();
if (count == 0)
{
tblStudentRecord = _db.tblStudentRecords.Where(a => a.Id == model.Id).FirstOrDefault();
if (tblStudentRecord != null)
{
tblStudentRecord.Address = model.Address;
tblStudentRecord.Batch = model.Batch;
tblStudentRecord.City = model.City;
tblStudentRecord.CourseId = model.CourseId;
tblStudentRecord.EmailId = model.EmailId;
tblStudentRecord.FatherName = model.FatherName;
tblStudentRecord.LastUpdatedDate = model.LastUpdatedDate;
tblStudentRecord.MotherName = model.MotherName;
tblStudentRecord.YearId = model.YearId;
tblStudentRecord.Name = model.Name;
tblStudentRecord.PhoneNumber = model.PhoneNumber;
tblStudentRecord.Pincode = model.Pincode;
tblStudentRecord.State = model.State;
_db.SaveChanges();
result = "1";
}
}
else
{
result = "-1";
}
}
catch (Exception qa)
{
}
return(result);
}
public int AddStudentRecord(tblStudentRecord model)
{
int id = 0;
try
{
int count = _db.tblStudentRecords.Where(a => a.EmailId == model.EmailId || a.PhoneNumber == model.PhoneNumber).Count();
if (count == 0)
{
_db.tblStudentRecords.Add(model);
_db.SaveChanges();
id = model.Id;
}
else
{
id = -1;
}
}
catch (Exception a1)
{ }
return(id);
}
//Create function to save new record into database.
public int SaveStudentRecords(tblStudentRecord model)
{
int id = 0;
try
{
int Count = _db.tblStudentRecords.Where(a => a.Name == model.Name && a.RollNo == model.RollNo).Count();
if (Count == 0)
{
_db.tblStudentRecords.Add(model);
_db.SaveChanges();
id = model.ID;
}
else
{
id = -1;
}
}
catch (Exception a1)
{
}
return(id);
}
public tblStudentRecord GetStudentRecordByID(int id)
{
tblStudentRecord tblStudentRecord = _db.tblStudentRecords.Where(a => a.ID == id).FirstOrDefault();
return(tblStudentRecord);
}
//Create the ClickEvent of Save Button to Save the New Data.
protected void btn_save_Click(object sender, EventArgs e)
{
lbl_result.Text = string.Empty;
tblStudentRecord tblStudentRecord = new tblStudentRecord();
tblStudentRecord.Name = txt_name.Text.Trim();
tblStudentRecord.RollNo = txt_rollNo.Text.Trim();
tblStudentRecord.Address = txt_address.Text.Trim();
tblStudentRecord.City = txt_city.Text.Trim();
tblStudentRecord.Email = txt_email.Text.Trim();
tblStudentRecord.IsActive = true;
tblStudentRecord.Phone = txt_phone.Text.Trim();
tblStudentRecord.State = txt_state.Text.Trim();
tblStudentRecord.LastUpdatedDate = DateTime.UtcNow;
tblStudentRecord.ClassId = Convert.ToInt32(ddl_class.SelectedValue);
if (btn_save.CommandName == "add")
{
tblStudentRecord.CreatedDate = DateTime.UtcNow;
int id = mm.SaveStudentRecords(tblStudentRecord);
if (id > 0)
{
Clear();
pnl_saveData.Visible = false;
pnl_showGrid.Visible = true;
Page.Response.Redirect(Page.Request.Url.ToString(), true);
// bind_showStudentRecords();
}
else if (id == -1)
{
lbl_result.Text = "Student Detail Already Exist";
lbl_result.ForeColor = System.Drawing.Color.Red;
lbl_result.Focus();
}
else
{
lbl_result.Text = "Error in adding student detail";
lbl_result.ForeColor = System.Drawing.Color.Red;
lbl_result.Focus();
}
}
// Create the ClickEvent of Update Button to Update the Existing Records.
else if (btn_save.CommandName == "update")
{
tblStudentRecord.ID = Convert.ToInt32(btn_save.CommandArgument);
string result = mm.UpdateStudentRecord(tblStudentRecord);
if (result == "1")
{
Clear();
pnl_saveData.Visible = false;
pnl_showGrid.Visible = true;
bind_showStudentRecords();
}
else if (result == "-1")
{
lbl_result.Text = "This Roll No is already exist";
lbl_result.ForeColor = System.Drawing.Color.Red;
lbl_result.Focus();
}
}
}
