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