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; }