public static string getQuerySaveManufacturer(Manufacturer manufacturer)
{
return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", ID_TABLE_MANUFACTURER,
manufacturer.Id,
manufacturer.Make,
manufacturer.Model,
manufacturer.Firmware,
manufacturer.Description,
manufacturer.LocalInsertTime.ToString(DATETIMEFORMATINSERT_MANUFACTURER),
manufacturer.InsertUser,
manufacturer.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_MANUFACTURER),
manufacturer.UpdateUser);
}
public static string getQueryUpdateManufacturer(Manufacturer manufacturer)
{
return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}',{7}='{8}',{9}='{10}',{11}='{12}' WHERE {13}='{14}'",
ID_TABLE_MANUFACTURER,
ID_MAKE_MANUFACTURER,manufacturer.Make,
ID_MODEL_MANUFACTURER,manufacturer.Model,
ID_FIRMWARE_MANUFACTURER,manufacturer.Firmware,
ID_DESCRIPTION_MANUFACTURER, manufacturer.Description,
ID_UPDATETIME_MANUFACTURER, manufacturer.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_MANUFACTURER),
ID_UPDATEUSER_MANUFACTURER, manufacturer.UpdateUser,
ID_ID_MANUFACTURER, manufacturer.Id
);
}
public static IList<Manufacturer> ParseDataSetToManufacturer(DataTable dataTable)
{
IList<Manufacturer> manufacturerList = new List<Manufacturer>();
foreach (DataRow row in dataTable.Rows)
{
Manufacturer manufacturer = new Manufacturer()
{
Id = row[POSITION_ID_MANUFACTURER].ToString(),
Make = row[POSITION_MAKE_MANUFACTURER].ToString(),
Model = row[POSITION_MODEL_MANUFACTURER].ToString(),
Firmware = row[POSITION_FIRMWARE_MANUFACTURER].ToString(),
Description = row[POSITION_DESCRIPTION_MANUFACTURER].ToString(),
LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_MANUFACTURER].ToString(), DATETIMEFORMATINSERT_MANUFACTURER),
InsertUser = row[POSITION_INSERTUSER_MANUFACTURER].ToString(),
UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_MANUFACTURER].ToString(), DATETIMEFORMATINSERT_MANUFACTURER),
UpdateUser = row[POSITION_UPDATEUSER_MANUFACTURER].ToString()
};
manufacturerList.Add(manufacturer);
}
return manufacturerList;
}
internal void UpdateManufacturer(Manufacturer manufacturer)
{
string query = ManufacturerQuery.getQueryUpdateManufacturer(manufacturer);
ManufacturerQuery.ParseDataSetToManufacturer(_provider.queryExecute(query,UPDATE_TYPE));
}
internal void SaveManufacturer(Manufacturer manufacturer)
{
string query = ManufacturerQuery.getQuerySaveManufacturer(manufacturer);
ManufacturerQuery.ParseDataSetToManufacturer(_provider.queryExecute(query,INSERT_TYPE));
}
public void Update(Manufacturer manufacturer)
{
_repositoryHelper.UpdateManufacturer(manufacturer);
}
public void Save(Manufacturer manufacturer)
{
_repositoryHelper.SaveManufacturer(manufacturer);
}
public bool Exists(Manufacturer manufacturer)
{
return Get(manufacturer.Id) != null;
}
