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)); }