public bool Insert(int DepartmentId, int LanguageId, string DepartmentName, string DepartmentDescription, string AddressLine1, string AddressLine2)
{
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
int DepartmentLanguagesId = 0;
return(departmentlanguagesComponent.InsertNewDepartmentLanguages(ref DepartmentLanguagesId, DepartmentId, LanguageId, DepartmentName, DepartmentDescription, AddressLine1, AddressLine2));
}
public bool Insert(DepartmentLanguages departmentlanguages)
{
int autonumber = 0;
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
bool endedSuccessfuly = departmentlanguagesComponent.InsertNewDepartmentLanguages(ref autonumber, departmentlanguages.DepartmentId, departmentlanguages.LanguageId, departmentlanguages.DepartmentName, departmentlanguages.DepartmentDescription, departmentlanguages.AddressLine1, departmentlanguages.AddressLine2);
if (endedSuccessfuly)
{
departmentlanguages.DepartmentLanguagesId = autonumber;
}
return(endedSuccessfuly);
}
public List <DepartmentLanguages> GetAll()
{
DepartmentLanguagesDAC _departmentLanguagesComponent = new DepartmentLanguagesDAC();
IDataReader reader = _departmentLanguagesComponent.GetAllDepartmentLanguages().CreateDataReader();
List <DepartmentLanguages> _departmentLanguagesList = new List <DepartmentLanguages>();
while (reader.Read())
{
if (_departmentLanguagesList == null)
{
_departmentLanguagesList = new List <DepartmentLanguages>();
}
DepartmentLanguages _departmentLanguages = new DepartmentLanguages();
if (reader["DepartmentLanguagesId"] != DBNull.Value)
{
_departmentLanguages.DepartmentLanguagesId = Convert.ToInt32(reader["DepartmentLanguagesId"]);
}
if (reader["DepartmentId"] != DBNull.Value)
{
_departmentLanguages.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
}
if (reader["LanguageId"] != DBNull.Value)
{
_departmentLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["DepartmentName"] != DBNull.Value)
{
_departmentLanguages.DepartmentName = Convert.ToString(reader["DepartmentName"]);
}
if (reader["DepartmentDescription"] != DBNull.Value)
{
_departmentLanguages.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
}
if (reader["AddressLine1"] != DBNull.Value)
{
_departmentLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
}
if (reader["AddressLine2"] != DBNull.Value)
{
_departmentLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
}
_departmentLanguages.NewRecord = false;
_departmentLanguagesList.Add(_departmentLanguages);
}
reader.Close();
return(_departmentLanguagesList);
}
public DepartmentLanguages GetByID(int _departmentLanguagesId)
{
DepartmentLanguagesDAC _departmentLanguagesComponent = new DepartmentLanguagesDAC();
IDataReader reader = _departmentLanguagesComponent.GetByIDDepartmentLanguages(_departmentLanguagesId);
DepartmentLanguages _departmentLanguages = null;
while (reader.Read())
{
_departmentLanguages = new DepartmentLanguages();
if (reader["DepartmentLanguagesId"] != DBNull.Value)
{
_departmentLanguages.DepartmentLanguagesId = Convert.ToInt32(reader["DepartmentLanguagesId"]);
}
if (reader["DepartmentId"] != DBNull.Value)
{
_departmentLanguages.DepartmentId = Convert.ToInt32(reader["DepartmentId"]);
}
if (reader["LanguageId"] != DBNull.Value)
{
_departmentLanguages.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["DepartmentName"] != DBNull.Value)
{
_departmentLanguages.DepartmentName = Convert.ToString(reader["DepartmentName"]);
}
if (reader["DepartmentDescription"] != DBNull.Value)
{
_departmentLanguages.DepartmentDescription = Convert.ToString(reader["DepartmentDescription"]);
}
if (reader["AddressLine1"] != DBNull.Value)
{
_departmentLanguages.AddressLine1 = Convert.ToString(reader["AddressLine1"]);
}
if (reader["AddressLine2"] != DBNull.Value)
{
_departmentLanguages.AddressLine2 = Convert.ToString(reader["AddressLine2"]);
}
_departmentLanguages.NewRecord = false;
}
reader.Close();
return(_departmentLanguages);
}
public bool Update(DepartmentLanguages departmentlanguages, int old_departmentLanguagesId)
{
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
return(departmentlanguagesComponent.UpdateDepartmentLanguages(departmentlanguages.DepartmentId, departmentlanguages.LanguageId, departmentlanguages.DepartmentName, departmentlanguages.DepartmentDescription, departmentlanguages.AddressLine1, departmentlanguages.AddressLine2, old_departmentLanguagesId));
}
public int UpdateDataset(System.Data.DataSet dataset)
{
DepartmentLanguagesDAC departmentlanguagescomponent = new DepartmentLanguagesDAC();
return(departmentlanguagescomponent.UpdateDataset(dataset));
}
public void Delete(int Original_DepartmentLanguagesId)
{
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
departmentlanguagesComponent.DeleteDepartmentLanguages(Original_DepartmentLanguagesId);
}
public bool Update(int DepartmentId, int LanguageId, string DepartmentName, string DepartmentDescription, string AddressLine1, string AddressLine2, int Original_DepartmentLanguagesId)
{
DepartmentLanguagesDAC departmentlanguagesComponent = new DepartmentLanguagesDAC();
return(departmentlanguagesComponent.UpdateDepartmentLanguages(DepartmentId, LanguageId, DepartmentName, DepartmentDescription, AddressLine1, AddressLine2, Original_DepartmentLanguagesId));
}
