public async Task <bool> Create(TravelCompanyServiceModel travelCompanyServiceModel)
{
TravelCompany travelCompany = travelCompanyServiceModel.To <TravelCompany>();
this.context.TravelCompanies.Add(travelCompany);
int result = await this.context.SaveChangesAsync();
return(result > 0);
}
public long Insert(TravelCompany tc)
{
try
{
string sql = "INSERT INTO TravelCompany(FirstName, LastName, BirthDate) VALUES (@FirstName, @LastName, @BirthDate)";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("@FirstName", tc.FirstName),
new KeyValuePair <string, string>("@LastName", tc.LastName),
new KeyValuePair <string, string>("@BirthDate", tc.BirthDate.ToString())
};
long results = ExecuteInsert(sql, parameters);
return(results);
}
catch
{
throw;
}
}
public TravelCompany GetById(int id)
{
try
{
string sql = "SELECT FirstName, LastName, BirthDate FROM TravelCompany WHERE TravelCompanyId = @TravelCompanyId ";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("@TravelCompanyId", id.ToString())
};
DataSet results = ExecuteSql(sql, parameters);
TravelCompany tc = DataSetParser.DataSetToTravelCompany(results, 0);
return(tc);
}
catch
{
return(null);
}
}
public List <TravelCompany> GetAll()
{
List <TravelCompany> tcList = new List <TravelCompany>();
try
{
string sql = "SELECT TravelCompanyId, FirstName, LastName, BirthDate FROM TravelCompany";
DataSet results = ExecuteSql(sql, new List <KeyValuePair <string, string> >());
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
TravelCompany tc = DataSetParser.DataSetToTravelCompany(results, x);
tcList.Add(tc);
}
return(tcList);
}
catch
{
return(null);
}
}
public long Insert(TravelCompany tc)
{
return(_context.Insert(tc));
}
