public string Save_Department(Department department) { if (!departmentGatway.IsDepartmentCodeExists(department.Code)) { if (!departmentGatway.IsDepartmentNameExists(department.Name)) { if (departmentGatway.Save_Department(department)>0) { return department.Name+" Department Save Successfully ."; } else { return department.Name + " Department Failed to Save !"; } } else { return "Sorry this "+department.Name + " Name Is Duplicate Department Name !"; } } else { return "Sorry this " + department.Code + " Code Is Duplicate Department Code !"; } }
public List<Department> VieDepartments() { connection.ConnectionString = connectionString; string sqlQuery = "SELECT * FROM Department"; SqlCommand command = new SqlCommand(sqlQuery, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<Department> departmentsList=new List<Department>(); while (reader.Read()) { Department departments = new Department { Id = Convert.ToInt32(reader["id"]), Code = reader["code"].ToString(), Name = reader["name"].ToString() }; departmentsList.Add(departments); } reader.Close(); connection.Close(); return departmentsList; }
public int Save_Department(Department department) { connection.ConnectionString = connectionString; string sqlQuery="INSERT INTO Department(code,name) VALUES('"+department.Code+"','"+department.Name+"')"; SqlCommand command=new SqlCommand(sqlQuery,connection); connection.Open(); int isInserted = command.ExecuteNonQuery(); connection.Close(); return isInserted; }
public ActionResult Save_Department(Department department) { ViewBag.Message = departmentManager.Save_Department(department); return View(); }