public List<Divisions> GetAll() { DivisionsDAC _divisionsComponent = new DivisionsDAC(); IDataReader reader = _divisionsComponent.GetAllDivisions().CreateDataReader(); List<Divisions> _divisionsList = new List<Divisions>(); while(reader.Read()) { if(_divisionsList == null) _divisionsList = new List<Divisions>(); Divisions _divisions = new Divisions(); if(reader["DivisionId"] != DBNull.Value) _divisions.DivisionId = Convert.ToInt32(reader["DivisionId"]); if(reader["DepartmentId"] != DBNull.Value) _divisions.DepartmentId = Convert.ToInt32(reader["DepartmentId"]); if(reader["DivisionName"] != DBNull.Value) _divisions.DivisionName = Convert.ToString(reader["DivisionName"]); if(reader["DivisionDescription"] != DBNull.Value) _divisions.DivisionDescription = Convert.ToString(reader["DivisionDescription"]); if(reader["Phone1"] != DBNull.Value) _divisions.Phone1 = Convert.ToString(reader["Phone1"]); if(reader["Phone2"] != DBNull.Value) _divisions.Phone2 = Convert.ToString(reader["Phone2"]); if(reader["Fax1"] != DBNull.Value) _divisions.Fax1 = Convert.ToString(reader["Fax1"]); if(reader["Fax2"] != DBNull.Value) _divisions.Fax2 = Convert.ToString(reader["Fax2"]); _divisions.NewRecord = false; _divisionsList.Add(_divisions); } reader.Close(); return _divisionsList; }
public Divisions GetByID(int _divisionId) { DivisionsDAC _divisionsComponent = new DivisionsDAC(); IDataReader reader = _divisionsComponent.GetByIDDivisions(_divisionId); Divisions _divisions = null; while(reader.Read()) { _divisions = new Divisions(); if(reader["DivisionId"] != DBNull.Value) _divisions.DivisionId = Convert.ToInt32(reader["DivisionId"]); if(reader["DepartmentId"] != DBNull.Value) _divisions.DepartmentId = Convert.ToInt32(reader["DepartmentId"]); if(reader["DivisionName"] != DBNull.Value) _divisions.DivisionName = Convert.ToString(reader["DivisionName"]); if(reader["DivisionDescription"] != DBNull.Value) _divisions.DivisionDescription = Convert.ToString(reader["DivisionDescription"]); if(reader["Phone1"] != DBNull.Value) _divisions.Phone1 = Convert.ToString(reader["Phone1"]); if(reader["Phone2"] != DBNull.Value) _divisions.Phone2 = Convert.ToString(reader["Phone2"]); if(reader["Fax1"] != DBNull.Value) _divisions.Fax1 = Convert.ToString(reader["Fax1"]); if(reader["Fax2"] != DBNull.Value) _divisions.Fax2 = Convert.ToString(reader["Fax2"]); _divisions.NewRecord = false; } reader.Close(); return _divisions; }
public bool Insert(Divisions divisions) { int autonumber = 0; DivisionsDAC divisionsComponent = new DivisionsDAC(); bool endedSuccessfuly = divisionsComponent.InsertNewDivisions( ref autonumber, divisions.DepartmentId, divisions.DivisionName, divisions.DivisionDescription, divisions.Phone1, divisions.Phone2, divisions.Fax1, divisions.Fax2); if(endedSuccessfuly) { divisions.DivisionId = autonumber; } return endedSuccessfuly; }
public void Delete(int Original_DivisionId) { DivisionsDAC divisionsComponent = new DivisionsDAC(); divisionsComponent.DeleteDivisions(Original_DivisionId); }
public int UpdateDataset(System.Data.DataSet dataset) { DivisionsDAC divisionscomponent = new DivisionsDAC(); return divisionscomponent.UpdateDataset(dataset); }
public bool Update( int DepartmentId, string DivisionName, string DivisionDescription, string Phone1, string Phone2, string Fax1, string Fax2, int Original_DivisionId) { DivisionsDAC divisionsComponent = new DivisionsDAC(); return divisionsComponent.UpdateDivisions( DepartmentId, DivisionName, DivisionDescription, Phone1, Phone2, Fax1, Fax2, Original_DivisionId); }
public bool Update(Divisions divisions ,int old_divisionId) { DivisionsDAC divisionsComponent = new DivisionsDAC(); return divisionsComponent.UpdateDivisions( divisions.DepartmentId, divisions.DivisionName, divisions.DivisionDescription, divisions.Phone1, divisions.Phone2, divisions.Fax1, divisions.Fax2, old_divisionId); }
public bool Insert( int DepartmentId, string DivisionName, string DivisionDescription, string Phone1, string Phone2, string Fax1, string Fax2) { DivisionsDAC divisionsComponent = new DivisionsDAC(); int DivisionId = 0; return divisionsComponent.InsertNewDivisions( ref DivisionId, DepartmentId, DivisionName, DivisionDescription, Phone1, Phone2, Fax1, Fax2); }