public string SaveDepartment(Department departmentObj) { bool checkName = IsDepartmentNameExist(departmentObj.DepartmentName); bool checkCode = IsDepartmentCodeExist(departmentObj.DepartmentCode); if (checkName && checkCode) return "Department Name and Code Already Exists"; else if (checkName) return "Department Name Already Exists"; else if (checkCode) return "Department Code Already Exists"; else { string message = gateWay.SaveDepartment(departmentObj); return message; } }
public string SaveDepartment(Department departmentObj) { string query = "INSERT INTO Department VALUES(@departmentCode, @departmentName)"; SqlCommand insertCommand = new SqlCommand(query, connection); insertCommand.Parameters.Clear(); insertCommand.Parameters.Add("departmentCode", SqlDbType.VarChar); insertCommand.Parameters["departmentCode"].Value = departmentObj.DepartmentCode; insertCommand.Parameters.Add("departmentName", SqlDbType.VarChar); insertCommand.Parameters["departmentName"].Value = departmentObj.DepartmentName; connection.Open(); try { int rowAffected = insertCommand.ExecuteNonQuery(); connection.Close(); if (rowAffected > 0) return "Saved Successfully"; return "Saved Failed"; } catch (Exception e) { throw e; } }
public List<Department> GetAllDepartmentInfo() { string query = "SELECT * FROM Department"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); List<Department> departmetList = new List<Department>(); try { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Department departmentObj = new Department(); departmentObj.DepartmentCode = reader["DepartmentCode"].ToString(); departmentObj.DepartmentName = reader["DepartmentName"].ToString(); departmetList.Add(departmentObj); } reader.Close(); } catch (Exception e) { connection.Close(); throw e; } connection.Close(); return departmetList; }
public ActionResult SaveDepartment(Department departmentObj) { ViewBag.SaveDepartment = manage.SaveDepartment(departmentObj); return View(); }