public Message Save(Student newStudent)
{
Message message = new Message();
bool isStudentExists = IsStudentExists(newStudent);
if (isStudentExists)
{
message.Status = "warning";
message.Details = "Registration Number is already exists.";
return message;
}
int totalRowsAffected = aStudentGateway.AddStudent(newStudent);
if (totalRowsAffected > 0)
{
message.Status = "success";
message.Details = "Data Saved Successfully";
}
else
{
message.Status = "error";
message.Details = "Operation Failed.";
}
return message;
}
protected void saveButton_Click(object sender, EventArgs e)
{
string name = nameTextBox.Text;
string regNo = regNoTextBox.Text;
string phone = phoneTextBox.Text;
string address = addressTextBox.Text;
Student aStudent = new Student(name, regNo, phone, address);
bool isStudentExists = IsStudentExists(aStudent);
if (isStudentExists)
{
messageLabel.Text = "Registration Number already exist";
return;
}
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string query = "INSERT INTO Students(RegNo, Name, Address, Phone) VALUES('" + aStudent.RegNo + "', '" + aStudent.Name + "', '" + aStudent.Address + "', '" + aStudent.Phone + "')";
SqlCommand command = new SqlCommand(query, connection);
int totalAffectedRow = command.ExecuteNonQuery();
connection.Close();
if (totalAffectedRow > 0)
{
messageLabel.Text = "Information Saved";
}
else
{
messageLabel.Text = "Operation Failed";
}
}
public void Save(Student aStudent)
{
string query = "INSERT INTO Students (RegNo, StudentName, StudentEmail, StudentContactNo, StudentAddress, DepartmentId, RegDate) VALUES (@regNo, @name, @email, @contactNo, @address, @deptId, @regDate)";
using (connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.Clear();
command.Parameters.Add("regNo", sqlDbType: SqlDbType.NVarChar);
command.Parameters["regNo"].Value = aStudent.RegNo;
command.Parameters.Add("name", sqlDbType: SqlDbType.NVarChar);
command.Parameters["name"].Value = aStudent.StudentName;
command.Parameters.Add("email", sqlDbType: SqlDbType.NVarChar);
command.Parameters["email"].Value = aStudent.StudentEmail;
command.Parameters.Add("contactNo", sqlDbType: SqlDbType.NVarChar);
command.Parameters["contactNo"].Value = aStudent.StudentContactNo;
command.Parameters.Add("address", sqlDbType: SqlDbType.NVarChar);
command.Parameters["address"].Value = aStudent.StudentAddress;
command.Parameters.Add("deptId", sqlDbType: SqlDbType.Int);
command.Parameters["deptId"].Value = aStudent.DepartmentId;
command.Parameters.Add("regDate", sqlDbType: SqlDbType.Date);
command.Parameters["regDate"].Value = aStudent.RegDate.Date;
connection.Open();
command.ExecuteNonQuery();
}
}
public ActionResponse Save(Student aStudent)
{
ActionResponse response = new ActionResponse();
try
{
bool isEmailExists = aStudentGateway.IsEmailExists(aStudent.StudentEmail);
if (isEmailExists)
{
response.Class = "danger";
response.Message = "Email [" + aStudent.StudentEmail + "] is already exists.";
return response;
}
//EEE-2016-001
string deptCode = aDepartmentGateway.GetDepartmentCodeById(aStudent.DepartmentId);
//int stdId = aStudentGateway.GetMaxStudentId();
//string regNo = deptCode + "-" + aStudent.RegDate.Year + "-" + stdId.ToString("D3");
int nextId = aStudentGateway.GetRegSl(aStudent.DepartmentId, aStudent.RegDate.Year);
string regNo = deptCode + "-" + aStudent.RegDate.Year + "-" + nextId.ToString("D3");
aStudent.RegNo = regNo;
aStudentGateway.Save(aStudent);
response.Class = "success";
response.Message = regNo;
}
catch (SqlException ex)
{
response.Class = "warning";
response.Message = ex.Message;
}
return response;
}
private bool IsStudentExists(Student student)
{
if (GetStudentByRegNo(student.RegNo) != null)
{
return true;
}
return false;
}
public int AddStudent(Student newStudent)
{
SqlConnection connection = new SqlConnection(connectionString);
string sql = "INSERT INTO Students (RegNo, Name, Phone, Address) VALUES ('" + newStudent.RegNo + "', '" + newStudent.Name + "', '" + newStudent.Phone + "', '" + newStudent.Address + "')";
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
int totalRowsAffected = command.ExecuteNonQuery();
connection.Close();
return totalRowsAffected;
}
private bool IsStudentExists(Student newStudent)
{
StudentGateway aStudentGateway = new StudentGateway();
Student aStudent = aStudentGateway.GetStudentByRegNo(newStudent.RegNo);
if (aStudent != null)
{
return true;
}
return false;
}
protected void saveButton_Click(object sender, EventArgs e)
{
string regNo = regNoTextBox.Text;
string name = nameTextBox.Text;
string phone = phoneTextBox.Text;
string address = addressTextBox.Text;
Student aStudent = new Student(regNo, name, phone, address);
Message message = studentManager.Save(aStudent);
messageLabel.Text = message.Details;
LoadStudentList();
}
public Message Update(Student aStudent)
{
Message message = new Message();
int totalRowsAffected = aStudentGateway.UpdateStudent(aStudent);
if (totalRowsAffected > 0)
{
message.Status = "success";
message.Details = "Data Successfully Updated";
}
else
{
message.Status = "error";
message.Details = "Operation Failed.";
}
return message;
}
protected void saveButton_Click(object sender, EventArgs e)
{
string regNo = regNoTextBox.Text;
string name = nameTextBox.Text;
string phone = phoneTextBox.Text;
string address = addressTextBox.Text;
int departmentId = Convert.ToInt32(departmentDropDown.SelectedValue);
Message message = new Message();
if (saveButton.Text == "Save")
{
Student aStudent = new Student(regNo, name, phone, address);
aStudent.DepartmentId = departmentId;
message = studentManager.Save(aStudent);
}
else if (saveButton.Text == "Update")
{
int id = Convert.ToInt32(pkHiddenField.Value);
Student aStudent = new Student(id, regNo, name, phone, address);
aStudent.DepartmentId = departmentId;
message = studentManager.Update(aStudent);
saveButton.Text = "Save";
regNoTextBox.Enabled = true;
}
else if (saveButton.Text == "Delete")
{
int id = Convert.ToInt32(pkHiddenField.Value);
message = studentManager.Delete(id);
regNoTextBox.Enabled = true;
nameTextBox.Enabled = true;
phoneTextBox.Enabled = true;
addressTextBox.Enabled = true;
saveButton.Text = "Save";
}
messageLabel.Text = message.Details;
ClearTextFields();
LoadStudentList();
}
private Student GetStudentByRegNo(string regNo)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
string query = "SELECT * FROM Students WHERE RegNo ='" + regNo + "'";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
Student aStudent = null;
if (reader.Read())
{
aStudent = new Student();
aStudent.Name = reader["Name"].ToString();
aStudent.RegNo = reader["RegNo"].ToString();
aStudent.Address = reader["Address"].ToString();
aStudent.Phone = reader["Phone"].ToString();
aStudent.Id = Convert.ToInt32(reader["Id"].ToString());
}
return aStudent;
}
public Student GetStudentById(int id)
{
Student aStudent = null;
SqlConnection connection = new SqlConnection(connectionString);
string sql = "SELECT * FROM Students WHERE Id=" + id;
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
aStudent = new Student();
aStudent.Id = Convert.ToInt32(reader["Id"].ToString());
aStudent.RegNo = reader["RegNo"].ToString();
aStudent.Name = reader["Name"].ToString();
aStudent.Phone = reader["Phone"].ToString();
aStudent.Address = reader["Address"].ToString();
}
connection.Close();
return aStudent;
}
public List<Student> GetAll()
{
List<Student> students = new List<Student>();
SqlConnection connection = new SqlConnection(connectionString);
string sql = "SELECT * FROM Students";
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Student aStudent = new Student();
aStudent.Id = Convert.ToInt32(reader["Id"].ToString());
aStudent.RegNo = reader["RegNo"].ToString();
aStudent.Name = reader["Name"].ToString();
aStudent.Phone = reader["Phone"].ToString();
aStudent.Address = reader["Address"].ToString();
students.Add(aStudent);
}
connection.Close();
return students;
}
public JsonResult Save(Student aStudent)
{
ActionResponse response = aStudentManager.Save(aStudent);
return Json(response, JsonRequestBehavior.AllowGet);
}
public int UpdateStudent(Student aStudent)
{
SqlConnection connection = new SqlConnection(connectionString);
string sql = "UPDATE Students SET RegNo='" + aStudent.RegNo + "', Name='" + aStudent.Name + "', Phone='" + aStudent.Phone + "', Address='" + aStudent.Address + "' WHERE Id=" + aStudent.Id;
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
int totalRowsAffected = command.ExecuteNonQuery();
connection.Close();
return totalRowsAffected;
}
private void LoadFieldsBySutdent(Student student)
{
pkHiddenField.Value = student.Id.ToString();
regNoTextBox.Text = student.RegNo;
nameTextBox.Text = student.Name;
phoneTextBox.Text = student.Phone;
addressTextBox.Text = student.Address;
departmentDropDown.SelectedValue = student.DepartmentId.ToString();
}