public Student GetStudent(string regNo)
{
try
{
SqlConnectionObj.Open();
string query = string.Format("select * from tbl_Student where RegNo={0}", regNo);
SqlCommandObj.CommandText = query;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
Student aStudent=new Student();
while (reader.Read())
{
aStudent.Name = reader[1].ToString();
aStudent.RegNo = reader[3].ToString();
aStudent.Email = reader[2].ToString();
aStudent.ContactNo = Convert.ToInt32(reader[4]);
}
return aStudent;
}
catch (Exception exception)
{
throw new Exception("Error occurred during student management system.", exception);
}
finally
{
SqlConnectionObj.Close();
}
}
public string GetBook(List<Book> books, DateTime toShortDateString, Student aStudent)
{
SqlConnectionObj.Open();
foreach (Book book in books)
{
string query = string.Format("Insert into tbl_Issueed(Book_id,Lend_copy,Issue_date,student_Reg) values({0},{1},'{2}', '{3}')", book.Id, book.OutsideCopy, toShortDateString, aStudent.RegNo);
SqlCommandObj.CommandText = query;
SqlCommandObj.ExecuteNonQuery();
}
return "Book Lend Successfully";
}
public string Save(Student aStudent)
{
if (studentGateway.HasEmail(aStudent.Email))
{
throw new Exception("Email address already used.");
}
else if (studentGateway.HasRegNo(aStudent.RegNo))
{
throw new Exception("Reg no already used.");
}
else
{
return studentGateway.Save(aStudent);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
Student aStudent=new Student();
aStudent.Id = id;
aStudent.Name = nameTextBox.Text;
aStudent.Email = emailTextBox.Text;
aStudent.RegNo = regNoTextBox.Text;
aStudent.ContactNo = Convert.ToInt32(contactNoTextBox.Text);
if (nameTextBox.Text==string.Empty)
{
MessageBox.Show("Please entre name.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (emailTextBox.Text==string.Empty)
{
MessageBox.Show("Please entre email address.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else if (regNoTextBox.Text==string.Empty)
{
MessageBox.Show("Please entre registration No.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else if(contactNoTextBox.Text==string.Empty)
{
MessageBox.Show("Please entre contact No.", "Information", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
else
{
string message = null;
try
{
message = studentManager.Save(aStudent);
MessageBox.Show(message, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message,"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
ClearAll();
}
public string GetBook(List<Book> books, DateTime toShortDateString, Student aStudent)
{
return issueGateway.GetBook(books,toShortDateString,aStudent);
}
public string Save(Student aStudent)
{
try
{
SqlConnectionObj.Open();
string query = string.Format("insert into tbl_Student values('{0}','{1}','{2}','{3}')",
aStudent.Name, aStudent.Email, aStudent.RegNo,
aStudent.ContactNo);
SqlCommandObj.CommandText = query;
SqlCommandObj.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception("Student does not load this student.",exception);
}
finally
{
SqlConnectionObj.Close();
}
return aStudent.Name+" hase been saved.";
}
public Student SearchStudent(string studentId)
{
Student aStudent=new Student();
try
{
SqlConnectionObj.Open();
string query = string.Format("select * from tbl_Student where regNo='{0}'", studentId);
SqlCommandObj.CommandText = query;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
while (reader.Read())
{
aStudent.Id = Convert.ToInt32(reader["Id"]);
aStudent.Name = reader["Name"].ToString();
aStudent.Email = reader["Email"].ToString();
aStudent.RegNo = reader["RegNo"].ToString();
aStudent.ContactNo = Convert.ToInt32(reader["ContactNo"]);
}
}
catch (Exception exception)
{
throw new Exception("System doesnot load this student reg no.",exception);
}
finally
{
SqlConnectionObj.Close();
}
return aStudent;
}
private void studentSearchButton_Click(object sender, EventArgs e)
{
studentId = (regNoTextBox.Text);
if (regNoTextBox.Text!="")
{
try
{
Student aStudent=new Student();
aStudent=studentManager.SearchStudent(studentId);
nameTextBox.Text = aStudent.Name;
emailTextBox.Text = aStudent.Email;
contactNoTextBox.Text = aStudent.ContactNo.ToString();
if (nameTextBox.Text!="")
{
saveButton.Enabled = true;
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void saveButton_Click(object sender, EventArgs e)
{
Student aStudent=new Student();
string regNo = regNoTextBox.Text;
aStudent = studentManager.SearchStudent(regNo);
string message = "";
if (aStudent!=null)
{
foreach (Book aBook in books)
{
bookManager.UpdateBook(aBook.Id,aBook.OutsideCopy,1);
}
string dateTime = dtpIssueDate.Text;
message = issueManager.GetBook(books, DateTime.ParseExact(dateTime, "dd-MM-yyyy hh:mm:ss",CultureInfo.InvariantCulture), aStudent);
ClearAll();
MessageBox.Show(message);
}
}