public List <AcademicDetails> GetAcademicDetails(string studentId) { List <AcademicDetails> academicDetailsLst = new List <AcademicDetails>(); string connectionString = System.Configuration.ConfigurationManager. ConnectionStrings["DBConnectionString"].ConnectionString; string query = "select * FROM AcademeicDetails WHERE studentId=@studentId"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Parameters.AddWithValue("@studentId", studentId); cmd.Connection = con; con.Open(); DbDataReader dbDataReader = cmd.ExecuteReader(); while (dbDataReader.Read()) { AcademicDetails academicDetails = new AcademicDetails(); if (dbDataReader["AcademicDetailsId"] != null && !string.IsNullOrEmpty(dbDataReader["AcademicDetailsId"].ToString())) { academicDetails.AcademicDetailsId = dbDataReader["AcademicDetailsId"].ToString(); } if (dbDataReader["Course"] != null && !string.IsNullOrEmpty(dbDataReader["Course"].ToString())) { academicDetails.Course = dbDataReader["Course"].ToString(); } if (dbDataReader["Semester"] != null && !string.IsNullOrEmpty(dbDataReader["Semester"].ToString())) { academicDetails.Semester = dbDataReader["Semester"].ToString(); } if (dbDataReader["Year"] != null && !string.IsNullOrEmpty(dbDataReader["Year"].ToString())) { academicDetails.Year = dbDataReader["Year"].ToString(); } if (dbDataReader["CollegeName"] != null && !string.IsNullOrEmpty(dbDataReader["CollegeName"].ToString())) { academicDetails.CollegeName = dbDataReader["CollegeName"].ToString(); } if (dbDataReader["MarksScored"] != null && !string.IsNullOrEmpty(dbDataReader["MarksScored"].ToString())) { academicDetails.MarksScored = Convert.ToDecimal(dbDataReader["MarksScored"].ToString()); } if (dbDataReader["MaxMark"] != null && !string.IsNullOrEmpty(dbDataReader["MaxMark"].ToString())) { academicDetails.MaxMark = Convert.ToDecimal(dbDataReader["MaxMark"].ToString()); } academicDetailsLst.Add(academicDetails); } con.Close(); } return(academicDetailsLst); } }
public ActionResult UpdateAcademicDetails(AcademicDetails academicDetails) { if (string.IsNullOrEmpty(academicDetails.Course) || string.IsNullOrEmpty(academicDetails.Semester) || string.IsNullOrEmpty(academicDetails.Year) || string.IsNullOrEmpty(academicDetails.CollegeName) || academicDetails.MaxMark == 0) { return(Json(new { result = "Please fill all the details" })); } StudentDetailsDal studentDetailsDal = new StudentDetailsDal(); if (string.IsNullOrEmpty(academicDetails.AcademicDetailsId)) { academicDetails.AcademicDetailsId = studentDetailsDal.AddAcademicDetails(academicDetails); } else { studentDetailsDal.UpdateAcademicDetails(academicDetails); } return(new EmptyResult()); }
public string AddAcademicDetails(AcademicDetails academicDetails) { string AcademicDetailsId = Guid.NewGuid().ToString(); string connectionString = System.Configuration.ConfigurationManager. ConnectionStrings["DBConnectionString"].ConnectionString; string query = "INSERT INTO AcademicDetails VALUES(@AcademicDetailsId,@StudentId, @Course, @Semester, @Year, @CollegeName, @MarksScored, @MaxMark,@UploadFileId,@status)"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Parameters.AddWithValue("@AcademicDetailsId", AcademicDetailsId); if (string.IsNullOrEmpty(academicDetails.StudentId)) { cmd.Parameters.AddWithValue("@StudentId", DBNull.Value); } else { cmd.Parameters.Add("@StudentId", System.Data.SqlDbType.NVarChar).Value = academicDetails.StudentId; } if (string.IsNullOrEmpty(academicDetails.UploadFileId)) { cmd.Parameters.AddWithValue("@UploadFileId", DBNull.Value); } else { cmd.Parameters.Add("@UploadFileId", System.Data.SqlDbType.NVarChar).Value = academicDetails.UploadFileId; } cmd.Parameters.AddWithValue("@Course", academicDetails.Course); cmd.Parameters.AddWithValue("@Semester", academicDetails.Semester); cmd.Parameters.AddWithValue("@Year", academicDetails.Year); cmd.Parameters.AddWithValue("@CollegeName", academicDetails.CollegeName); cmd.Parameters.AddWithValue("@MarksScored", academicDetails.MarksScored); cmd.Parameters.AddWithValue("@MaxMark", academicDetails.MaxMark); cmd.Parameters.AddWithValue("@status", true); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } return(AcademicDetailsId); }
public void UpdateAcademicDetails(AcademicDetails academicDetails) { string connectionString = System.Configuration.ConfigurationManager. ConnectionStrings["DBConnectionString"].ConnectionString; string query = "UPDATE AcademeicDetails SET Course=@Course, Semester=@Semester, Year=@Year, CollegeName=@CollegeName, MarksScored=@MarksScored, MaxMark=@MaxMark WHERE AcademicDetailsId=@AcademicDetailsId"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand(query)) { cmd.Parameters.AddWithValue("@AcademicDetailsId", academicDetails.AcademicDetailsId); cmd.Parameters.AddWithValue("@Course", academicDetails.Course); cmd.Parameters.AddWithValue("@Semester", academicDetails.Semester); cmd.Parameters.AddWithValue("@Year", academicDetails.Year); cmd.Parameters.AddWithValue("@CollegeName", academicDetails.CollegeName); cmd.Parameters.AddWithValue("@MarksScored", academicDetails.MarksScored); cmd.Parameters.AddWithValue("@MaxMark", academicDetails.MaxMark); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } }
protected void btnEduSave_Click(object sender, EventArgs e) { if (!validateEducation()) { upEducational.Update(); return; } AcademicDetails ad = new AcademicDetails(); ad.AcademicLevel = cmbEduLevel.Value.ToString(); ad.Comment = txtEduComment.Text; ad.DateAttended = dtEduSDate.Date; ad.DateCompleted = dtEduCDate.Date; ad.DateCreated = DateTime.Now; ad.Institution = txtEduInstitution.Text; ad.LastModified = DateTime.Now; ad.Qualification = txtEduQuali.Text; ad.UserId = txtStudUserID.Text; if (FileUpload1.HasFile) { string newName = txtEduQuali.Text + "_" + txtStudUserID.Text; string ext = Path.GetExtension(FileUpload1.PostedFile.FileName); string savePath = Path.Combine(Server.MapPath(UPEDU_DIR), newName + ext); FileUpload1.SaveAs(savePath); ad.Documment = newName + ext; } else { ad.Documment = "No Document"; } if (txtEduID.Text == "0") { if (new AcademicDetailsService().AddAcademicDetails(ad, new SessionManager().GetUserId(this.Session))) { ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.success('Saved Successfully','Message')", true); div_education.Visible = false; clearEdu(); } else { ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.error('Saving Failed','Message')", true); } } else { ad.Id = int.Parse(txtEduID.Text); if (new AcademicDetailsService().UpdateAcademicDetails(ad, new SessionManager().GetUserId(this.Session))) { ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.success('Updated Successfully','Message')", true); div_education.Visible = false; clearEdu(); } else { ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.error('Updating Failed','Message')", true); } } LoadEducation(ad.UserId); upEducational.Update(); uPanel.Update(); }