private void saveCertificates(Student aStudent)
{
foreach (Certificate aCertificate in aStudent.Certificates)
{
string id = GetExamId(aCertificate.ExaminationType);
if (id != null)
{
try
{
connection.Open();
string queryString = "insert into t_Certificate values(@grade,@cgpa,@certificateLocation,@examinationId,@registationNO)";
command.CommandText = queryString;
command.Parameters.Clear();
command.Parameters.AddWithValue("@grade", aCertificate.GradeLetter);
command.Parameters.AddWithValue("@cgpa", aCertificate.Cgpa);
command.Parameters.AddWithValue("@certificateLocation", aCertificate.CertificateLocation);
command.Parameters.AddWithValue("@examinationId", id);
command.Parameters.AddWithValue("@registationNo", aStudent.RegistationNo);
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
}
}
public Student GetStudentInformation(string regNo, int depeartmentId)
{
try
{
Student aStudent = new Student();
connection.Open();
string departmentQuery = "select * from t_studentInfo where registationNo=@regNo and departmentId=@depeartmentId";
command.CommandText = departmentQuery;
command.Parameters.Clear();
command.Parameters.AddWithValue("@regNo", regNo);
command.Parameters.AddWithValue("@depeartmentId", depeartmentId);
SqlDataReader studentReader = command.ExecuteReader();
while (studentReader.Read())
{
aStudent.RegistationNo = studentReader[0].ToString();
aStudent.Name = studentReader[1].ToString();
aStudent.Email = studentReader[2].ToString();
aStudent.ContactNo = studentReader[3].ToString();
aStudent.Address = studentReader[4].ToString();
aStudent.DepartmentId = studentReader[6].ToString();
}
return aStudent;
}
finally
{
connection.Close();
}
}
public int GetStudentRegistationNO(Student aStudent)
{
try
{
connection.Open();
int id = 1;
string queryString = "select registationDate from t_StudentInfo where departmentId=@id";
command.CommandText = queryString;
command.Parameters.Clear();
command.Parameters.AddWithValue("@id", aStudent.DepartmentId);
SqlDataReader dateReader = command.ExecuteReader();
while (dateReader.Read())
{
if (Convert.ToDateTime(aStudent.RegistationDate.ToString()).ToString("yyyy") == Convert.ToDateTime(dateReader[0].ToString()).ToString("yyyy"))
id++;
}
return id;
}
finally
{
connection.Close();
}
}
public string SaveStudent(Student aStudent)
{
try
{
connection.Open();
string addStudentQuery = "insert into t_StudentInfo values(@regNo,@name,@email,@contactNo,@address,@registationDate,@deptId)";
command.CommandText = addStudentQuery;
command.Parameters.Clear();
command.Parameters.AddWithValue("@regNo", aStudent.RegistationNo);
command.Parameters.AddWithValue("@name", aStudent.Name);
command.Parameters.AddWithValue("@email", aStudent.Email);
command.Parameters.AddWithValue("@contactNo", aStudent.ContactNo);
command.Parameters.AddWithValue("@address", aStudent.Address);
command.Parameters.AddWithValue("@registationDate", aStudent.RegistationDate);
command.Parameters.AddWithValue("@deptId", aStudent.DepartmentId);
command.ExecuteNonQuery();
return "Saved";
}
finally
{
connection.Close();
saveCertificates(aStudent);
}
}
public string GetStudentRegistationNO(Student aStudent)
{
string regNo = "";
int id;
aStudentGateway = new StudentGateway();
id = aStudentGateway.GetStudentRegistationNO(aStudent);
if (id < 10)
regNo = "000" + id;
if (id >= 10 && id < 100)
regNo = "00" + id;
if (id >= 100 && id < 1000)
regNo = "0" + id;
if (id >= 1000)
regNo = id.ToString();
return regNo;
}
protected void searchButton_Click(object sender, EventArgs e)
{
if(!IsValid)
{
return;
}
try
{
string regNo = regNoTextBox.Value;
int depeartmentId = Convert.ToInt16(departmentDropDownList.Text);
StudentManager aStudentManager = new StudentManager();
Student aStudent = new Student();
aStudent = aStudentManager.GetStudentInformation(regNo, depeartmentId);
if (aStudent.RegistationNo == null)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Invalid Registation Number";
}
nameTextBox.Value = aStudent.Name;
emailTextBox.Value = aStudent.Email;
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}
private bool DoesThisEmailExist(Student aStudent)
{
aStudentGateway = new StudentGateway();
List<string> emails = new List<string>();
emails = aStudentGateway.GetStudentEmails();
foreach (string email in emails)
{
if (email == aStudent.Email)
return true;
}
return false;
}
public string SaveStudent(Student aStudent)
{
aStudentGateway = new StudentGateway();
if (!DoesThisEmailExist(aStudent))
return aStudentGateway.SaveStudent(aStudent);
else
return "This Email Already Exist";
}
protected void Page_Load(object sender, EventArgs e)
{
msgLabel.Text = "";
try
{
departmentDropDownList.DataTextField = "DepartmentCode";
departmentDropDownList.DataValueField = "departmentId";
examSelectDropDownList.DataTextField = "ExaminationType";
examSelectDropDownList.DataValueField = "ExaminationId";
if (!IsPostBack)
{
aStudent = new Student();
ViewState["RegistationNo"] = "";
ViewState["Certificates"] = certificates;
Session["aStudent"] = aStudent;
DepartmentManager aDepartmentManager = new DepartmentManager();
departments = aDepartmentManager.GetAllDepartments();
ExaminationManager anExaminationManager = new ExaminationManager();
examinations = anExaminationManager.GetAllExaminations();
examSelectDropDownList.DataSource = examinations;
examSelectDropDownList.DataBind();
departmentDropDownList.DataSource = departments;
departmentDropDownList.DataBind();
}
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}
protected void addIntoListButton_Click(object sender, EventArgs e)
{
try
{
certificateGridView.DataSource = "";
if (ViewState["RegistationNo"].ToString() == "")
{
aStudent = GetStudentInfo();
Session["aStudent"] = aStudent;
ViewState["RegistationNo"] = aStudent.RegistationNo;
}
certificates = (List<Certificate>)ViewState["Certificates"];
Certificate aCertificate = new Certificate();
aCertificate.ExaminationType = examSelectDropDownList.SelectedItem.Text;
aCertificate.GradeLetter = gradeLetterTextBox.Value;
aCertificate.Cgpa = cgpaTextBox.Value;
if (certificateUpload.HasFile)
{
statusLabel.Text = "";
if (!certificateUpload.PostedFile.ContentType.ToLower().StartsWith("image") && certificateUpload.PostedFile.ContentType != "application/pdf")
{
msgLabel.ForeColor = Color.Red;
statusLabel.Text = "Incorrect file type.";
}
if (certificateUpload.PostedFile.ContentLength > 5120000)
{
msgLabel.ForeColor = Color.Red;
statusLabel.Text = "Image size is large.";
}
string newDir = Server.MapPath("~/Certificate/" + ViewState["RegistationNo"].ToString() + "/" + examSelectDropDownList.SelectedItem.Text + "/");
MakeDirectoryIfNotExists(newDir);
if (ViewState["RegistationNo"].ToString() == "")
{
msgLabel.ForeColor = Color.Red;
statusLabel.Text = "Please Enter correct regNo";
}
else
{
string fileName = ViewState["RegistationNo"].ToString() + ".jpg";
string savePath = newDir + "/" + fileName;
certificateUpload.SaveAs(savePath);
aCertificate.CertificateLocation = savePath.ToString();
aCertificate.Status = "yes";
certificates.Add(aCertificate);
ViewState["Certificates"] = certificates;
statusLabel.ForeColor = Color.Green;
statusLabel.Text = "File Uploaded" + certificates.Count.ToString();
certificateGridView.DataSource = certificates;
certificateGridView.DataBind();
}
}
else
{
msgLabel.ForeColor = Color.Red;
statusLabel.Text = "File not selected.";
}
}
finally
{
}
}
private Student GetStudentInfo()
{
try
{
aStudentManager = new StudentManager();
aStudent = new Student();
aStudent.Name = nameText.Value;
aStudent.Email = emailText.Value;
aStudent.ContactNo = contactNoText.Value;
aStudent.DepartmentId = departmentDropDownList.Text;
aStudent.RegistationDate = dateText.Value;
string year = aStudentManager.GetYear(dateText.Value);
aStudent.Address = addressText.Value;
string id = aStudentManager.GetStudentRegistationNO(aStudent);
aStudent.RegistationNo = year + departmentDropDownList.SelectedItem.Text + id;
return aStudent;
}
catch (Exception exception)
{
throw exception;
}
}
