public Department GetDepartmentByCode(string code)
{
try
{
string query = "SELECT * FROM t_Departments WHERE Code=@code";
CommandObj.CommandText = query;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@code", code);
Department department = null;
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
if (reader.Read())
{
department = new Department
{
Id = Convert.ToInt32(reader["Id"].ToString()),
Name = reader["Name"].ToString(),
Code = reader["Code"].ToString()
};
}
reader.Close();
return department;
}
catch (Exception exception)
{
throw new Exception("Unable to connect department", exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
public IEnumerable<Department> GetAll()
{
try
{
string query = "SELECT * FROM t_Departments";
CommandObj.CommandText = query;
List<Department> departments=new List<Department>();
ConnectionObj.Open();
SqlDataReader reader = CommandObj.ExecuteReader();
while (reader.Read())
{
Department department = new Department
{
Id = Convert.ToInt32(reader["Id"].ToString()),
Name = reader["Name"].ToString(),
Code = reader["Code"].ToString()
};
departments.Add(department);
}
reader.Close();
return departments;
}
catch (Exception exception)
{
throw new Exception("Unable to connect department",exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
private bool IsDepartmentCodeValid(Department
aDepartment)
{
if (aDepartment.Code.Length >= 2 || aDepartment.Code.Length <= 7)
{
return true;
}
return false;
}
private bool IsDepartmentNameExits(Department aDepartment)
{
Department dept = departmentGateway.GetDepartmentByName(aDepartment.Name);
if (dept != null)
{
return true;
}
return false;
}
private bool IsDepartmentCodeExits(Department aDepartment)
{
Department dept = departmentGateway.GetDepartmentByCode(aDepartment.Code.ToUpper());
if (dept!=null)
{
return true;
}
return false;
}
public ActionResult Save(Department aDepartment)
{
try
{
string message=departmentManager.Save(aDepartment);
ViewBag.Mgs = message;
return View();
//return RedirectToAction("Index");
}
catch(Exception exception)
{
ViewBag.Mgs = exception.InnerException.Message;
return View();
}
}
public string Save(Department aDepartment)
{
if (!(IsDepartmentCodeValid(aDepartment)))
{
return "Department code must be between 2 to 7 character length";
}
if (IsDepartmentCodeExits(aDepartment))
{
return "Department Code must be unique";
}
if (IsDepartmentNameExits(aDepartment))
{
return "Department Name must be Uinque";
}
if (departmentGateway.Insert(aDepartment) > 0)
{
return "Saved Sucessfully";
}
return "Failed to save";
}
public int Insert(Department aDepartment)
{
try
{
string query = "INSERT INTO t_Departments VALUES(@code,@name)";
CommandObj.CommandText = query;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@code", aDepartment.Code.ToUpper());
CommandObj.Parameters.AddWithValue("@name", aDepartment.Name);
ConnectionObj.Open();
return CommandObj.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception("Unable to save department", exception);
}
finally
{
ConnectionObj.Close();
CommandObj.Dispose();
}
}
