public ActionResult SaveDepartment(DepartmentHira department)
{
if (ModelState != null)
{
ViewBag.department = _aDepartmentHiraManager.SaveDepartment(department);
return(View());
}
//ViewBag.department = aDepartmentManager.SaveDepartment(department);
return(View());
}
public int SaveDepartment(DepartmentHira department)
{
Query = "INSERT INTO Department VALUES(@code,@name)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("code", SqlDbType.VarChar);
Command.Parameters["code"].Value = department.Code;
Command.Parameters.Add("name", SqlDbType.VarChar);
Command.Parameters["name"].Value = department.Name;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public List <DepartmentHira> GetAllDepartments()
{
Query = "SELECT * From Department";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <DepartmentHira> departments = new List <DepartmentHira>();
while (Reader.Read())
{
DepartmentHira aDepartment = new DepartmentHira();
aDepartment.Id = (int)Reader["id"];
aDepartment.Name = Reader["Name"].ToString();
departments.Add(aDepartment);
}
Connection.Close();
return(departments);
}
public string SaveDepartment(DepartmentHira department)
{
// int rowAffected = aDepartmentGateway.SaveDepartment(department);
if (_aDepartmentHiraGateway.IsCodeExist(department.Code) == false)
{
if (_aDepartmentHiraGateway.IsDepartmentExist(department.Name) == false)
{
int rowAffected = _aDepartmentHiraGateway.SaveDepartment(department);
if (rowAffected > 0)
{
return("Saved Succesfully");
}
{
return("Saved Failed");
}
}
return("Department Name already exist");
}
return("Code Already Exist");
}
