public bool UpdateDepartment(ModelDepartment department)
{
bool isSuccessful = false;
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"update Department
set Name=@Name,Code=@Code,DepartmentType=@DepartmentType,
SuperiorDepartmentId=@SuperiorDepartmentId, ManagerEmployeeId=@ManagerEmpoyeeId
where Id=@Id";
command.Parameters.Add("@SuperiorDepartmentId", SqlDbType.Int).Value = department.SuperiorDepartmentId ?? (Object)DBNull.Value;
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = department.Name;
command.Parameters.Add("@Code", SqlDbType.NVarChar).Value = department.Code;
command.Parameters.Add("@DepartmentType", SqlDbType.NVarChar).Value = department.DepartmentType.ToString();
command.Parameters.Add("@ManagerEmpoyeeId", SqlDbType.Int).Value = department.ManagerEmployeeId ?? (Object)DBNull.Value;
command.Parameters.Add("@Id", SqlDbType.Int).Value = department.Id;
if (command.ExecuteNonQuery() > 0)
{
isSuccessful = true;
}
});
return(isSuccessful);
}
public List <ModelDepartment> GetListOfDepartments(EnumDepartmentsType.DepartmentType departmentType)
{
List <ModelDepartment> myListOfCompanies = new List <ModelDepartment>();
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"select * from [dbo].[Department]
where DepartmentType=@DepartmentType";
command.Parameters.Add("@DepartmentType", SqlDbType.NVarChar).Value = departmentType.ToString();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ModelDepartment company = new ModelDepartment
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Code = reader.GetString(2),
DepartmentType = departmentType,
SuperiorDepartmentId = reader.IsDBNull(4) ? null : (int?)reader.GetInt32(4),
ManagerEmployeeId = reader.IsDBNull(5) ? null : (int?)reader.GetInt32(5)
};
myListOfCompanies.Add(company);
}
}
});
return(myListOfCompanies);
}
//To View all department details
public IEnumerable <Models.ModelDepartment> GetAllDepartment()
{
try
{
List <ModelDepartment> lstdepartment = new List <ModelDepartment>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spGetAllDepartment", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ModelDepartment department = new ModelDepartment();
department.ID = Convert.ToInt32(rdr["DEPARTMENT_ID"]);
department.DeptName = rdr["DEPARTMENT_NAME"].ToString();
lstdepartment.Add(department);
}
con.Close();
}
return(lstdepartment);
}
catch
{
throw;
}
}
private void BtnConfirm_Click(object sender, EventArgs e)
{
ModelDepartment department = (ModelDepartment)cmbCompanies.SelectedItem;
FrmDivisionOverview frmDivision = new FrmDivisionOverview(department.Id);
frmDivision.ShowDialog();
}
public ModelDepartment MakeDepartment(int id, string name, string code,
int?superiorDepartmentId, int?managerEmployeeId)
{
ModelDepartment model = new ModelDepartment
{
Id = id,
Name = name,
Code = code,
DepartmentType = EnumDepartmentsType.DepartmentType.Department,
SuperiorDepartmentId = superiorDepartmentId,
ManagerEmployeeId = managerEmployeeId
};
return(model);
}
public bool UpdateDepartment(string name, string code, int?managerId, EnumDepartmentsType.DepartmentType departmentType,
int?superiorDepartmentId, int id)
{
ModelDepartment department = new ModelDepartment
{
Id = id,
Name = name,
Code = code,
SuperiorDepartmentId = superiorDepartmentId,
ManagerEmployeeId = managerId,
DepartmentType = departmentType
};
return(RepositoryManager.RepositoryDepartment.UpdateDepartment(department));
}
public bool DeleteHigherDepartment(ModelDepartment department)
{
if (RepositoryManager.RepositoryDepartment.GetNumberOfInferiorDepartments(department.Id) != 0)
{
return(false);
}
else
{
RepositoryManager.RepositoryEmployee.SetDepartmentForEmployee((int)department.ManagerEmployeeId, null);
if (RepositoryManager.RepositoryDepartment.DeleteDepartment(department.Id))
{
return(true);
}
}
return(false);
}
// 传入DataRow,将其转换为ModelDepartment
private ModelDepartment toModel(DataRow dr)
{
ModelDepartment model = new ModelDepartment();
//通过循环为ModelDepartment赋值，其中为数据值为空时，DateTime类型的空值为：0001/1/1 0:00:00 int类型得空值为： 0，其余的还没试验
foreach (PropertyInfo propertyInfo in typeof(ModelDepartment).GetProperties())
{
//如果数据库的字段为空，跳过其赋值
if (dr[propertyInfo.Name].ToString() == "")
{
continue;
}
//赋值
model.GetType().GetProperty(propertyInfo.Name).SetValue(model, dr[propertyInfo.Name], null);
}
return(model);
}
public bool CreateDepartment(ModelDepartment department)
{
bool isSuccessful = false;
RepositoryManager.ExecuteSqlCommand((command) =>
{
command.CommandText = @"insert into [dbo].[Department]
values (@Name,@Code,@DepartmentType,@SuperiorDepartmentId,@ManagerId)";
command.Parameters.Add("@SuperiorDepartmentId", SqlDbType.Int).Value = department.SuperiorDepartmentId ?? (Object)DBNull.Value;
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = department.Name;
command.Parameters.Add("@Code", SqlDbType.NVarChar).Value = department.Code;
command.Parameters.Add("@DepartmentType", SqlDbType.NVarChar).Value = department.DepartmentType.ToString();
command.Parameters.Add("@ManagerId", SqlDbType.Int).Value = department.ManagerEmployeeId ?? (Object)DBNull.Value;
if (command.ExecuteNonQuery() > 0)
{
isSuccessful = true;
}
});
return(isSuccessful);
}
public FrmCreateEditDepartment(ModelDepartment department)
{
InitializeComponent();
_department = department;
FillTxtBoxes();
}
public bool DeleteHigherDepartment(ModelDepartment department)
{
return(_logic.DeleteHigherDepartment(department));
}
