public Organizations GetByID(int _organizationId) { OrganizationsDAC _organizationsComponent = new OrganizationsDAC(); IDataReader reader = _organizationsComponent.GetByIDOrganizations(_organizationId); Organizations _organizations = null; while(reader.Read()) { _organizations = new Organizations(); if(reader["OrganizationId"] != DBNull.Value) _organizations.OrganizationId = Convert.ToInt32(reader["OrganizationId"]); if(reader["OrganizationName"] != DBNull.Value) _organizations.OrganizationName = Convert.ToString(reader["OrganizationName"]); if(reader["OrganizationDescription"] != DBNull.Value) _organizations.OrganizationDescription = Convert.ToString(reader["OrganizationDescription"]); if(reader["Phone1"] != DBNull.Value) _organizations.Phone1 = Convert.ToString(reader["Phone1"]); if(reader["Phone2"] != DBNull.Value) _organizations.Phone2 = Convert.ToString(reader["Phone2"]); if(reader["Phone3"] != DBNull.Value) _organizations.Phone3 = Convert.ToString(reader["Phone3"]); if(reader["Fax1"] != DBNull.Value) _organizations.Fax1 = Convert.ToString(reader["Fax1"]); if(reader["Fax2"] != DBNull.Value) _organizations.Fax2 = Convert.ToString(reader["Fax2"]); if(reader["AddressLine1"] != DBNull.Value) _organizations.AddressLine1 = Convert.ToString(reader["AddressLine1"]); if(reader["AddressLine2"] != DBNull.Value) _organizations.AddressLine2 = Convert.ToString(reader["AddressLine2"]); _organizations.NewRecord = false; } reader.Close(); return _organizations; }
public List<Organizations> GetAll() { OrganizationsDAC _organizationsComponent = new OrganizationsDAC(); IDataReader reader = _organizationsComponent.GetAllOrganizations().CreateDataReader(); List<Organizations> _organizationsList = new List<Organizations>(); while(reader.Read()) { if(_organizationsList == null) _organizationsList = new List<Organizations>(); Organizations _organizations = new Organizations(); if(reader["OrganizationId"] != DBNull.Value) _organizations.OrganizationId = Convert.ToInt32(reader["OrganizationId"]); if(reader["OrganizationName"] != DBNull.Value) _organizations.OrganizationName = Convert.ToString(reader["OrganizationName"]); if(reader["OrganizationDescription"] != DBNull.Value) _organizations.OrganizationDescription = Convert.ToString(reader["OrganizationDescription"]); if(reader["Phone1"] != DBNull.Value) _organizations.Phone1 = Convert.ToString(reader["Phone1"]); if(reader["Phone2"] != DBNull.Value) _organizations.Phone2 = Convert.ToString(reader["Phone2"]); if(reader["Phone3"] != DBNull.Value) _organizations.Phone3 = Convert.ToString(reader["Phone3"]); if(reader["Fax1"] != DBNull.Value) _organizations.Fax1 = Convert.ToString(reader["Fax1"]); if(reader["Fax2"] != DBNull.Value) _organizations.Fax2 = Convert.ToString(reader["Fax2"]); if(reader["AddressLine1"] != DBNull.Value) _organizations.AddressLine1 = Convert.ToString(reader["AddressLine1"]); if(reader["AddressLine2"] != DBNull.Value) _organizations.AddressLine2 = Convert.ToString(reader["AddressLine2"]); _organizations.NewRecord = false; _organizationsList.Add(_organizations); } reader.Close(); return _organizationsList; }
public void Delete(int Original_OrganizationId) { OrganizationsDAC organizationsComponent = new OrganizationsDAC(); organizationsComponent.DeleteOrganizations(Original_OrganizationId); }
public int UpdateDataset(System.Data.DataSet dataset) { OrganizationsDAC organizationscomponent = new OrganizationsDAC(); return organizationscomponent.UpdateDataset(dataset); }
public bool Update( string OrganizationName, string OrganizationDescription, string Phone1, string Phone2, string Phone3, string Fax1, string Fax2, string AddressLine1, string AddressLine2, int Original_OrganizationId) { OrganizationsDAC organizationsComponent = new OrganizationsDAC(); return organizationsComponent.UpdateOrganizations( OrganizationName, OrganizationDescription, Phone1, Phone2, Phone3, Fax1, Fax2, AddressLine1, AddressLine2, Original_OrganizationId); }
public bool Update(Organizations organizations ,int old_organizationId) { OrganizationsDAC organizationsComponent = new OrganizationsDAC(); return organizationsComponent.UpdateOrganizations( organizations.OrganizationName, organizations.OrganizationDescription, organizations.Phone1, organizations.Phone2, organizations.Phone3, organizations.Fax1, organizations.Fax2, organizations.AddressLine1, organizations.AddressLine2, old_organizationId); }
public bool Insert( string OrganizationName, string OrganizationDescription, string Phone1, string Phone2, string Phone3, string Fax1, string Fax2, string AddressLine1, string AddressLine2) { OrganizationsDAC organizationsComponent = new OrganizationsDAC(); int OrganizationId = 0; return organizationsComponent.InsertNewOrganizations( ref OrganizationId, OrganizationName, OrganizationDescription, Phone1, Phone2, Phone3, Fax1, Fax2, AddressLine1, AddressLine2); }
public bool Insert(Organizations organizations) { int autonumber = 0; OrganizationsDAC organizationsComponent = new OrganizationsDAC(); bool endedSuccessfuly = organizationsComponent.InsertNewOrganizations( ref autonumber, organizations.OrganizationName, organizations.OrganizationDescription, organizations.Phone1, organizations.Phone2, organizations.Phone3, organizations.Fax1, organizations.Fax2, organizations.AddressLine1, organizations.AddressLine2); if(endedSuccessfuly) { organizations.OrganizationId = autonumber; } return endedSuccessfuly; }