public static string getQueryUpdateAppliance(Appliance appliance) { return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}',{7}='{8}',{9}='{10}',{11}='{12}',{13}='{14}',{15}='{16}',{17}='{18}',{19}='{20}'WHERE {21}='{22}'", ID_TABLE_APPLIANCE, ID_POWER_APPLIANCE,appliance.Power, ID_SUBCATEGORY_APPLIANCE,appliance.Subcategory.Id, ID_DESCRIPTION_APPLIANCE,appliance.Description, ID_INVESTMENT_APPLIANCE,appliance.Investment, ID_ROOM_APPLIANCE,appliance.Room.Id, ID_ACTIVEDATETIME_APPLIANCE, appliance.ActivacionDateTime.ToString(DATETIMEFORMAT_APPLIANCE), ID_LEAVINGDATETIME_APPLIANCE, appliance.LeavingDateTime.ToString(DATETIMEFORMAT_APPLIANCE), ID_UPDATETIME_APPLIANCE, appliance.UpdateLocalDateTime.ToString(DATETIMEFORMAT_APPLIANCE), ID_UPDATEUSER_APPLIANCE, appliance.UpdateUser, ID_LOADTYPE_APPLIANCE,appliance.Loadtype.Id, ID_ID_APPLIANCE, appliance.Id ); }
public static string getQuerySaveAppliance(Appliance appliance) { return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')", ID_TABLE_APPLIANCE, appliance.Id, appliance.Power, appliance.Subcategory.Id, appliance.Description, appliance.Investment, appliance.Room.Id, appliance.ActivacionDateTime.ToString(DATETIMEFORMAT_APPLIANCE), appliance.LeavingDateTime.ToString(DATETIMEFORMAT_APPLIANCE), appliance.LocalInsertTime.ToString(DATETIMEFORMAT_APPLIANCE), appliance.InsertUser, appliance.UpdateLocalDateTime.ToString(DATETIMEFORMAT_APPLIANCE), appliance.UpdateUser, appliance.Loadtype.Id); }
public void Update(Appliance appliance) { _repositoryHelper.UpdateAppliance(appliance); }
public void Save(Appliance appliance) { _repositoryHelper.SaveAppliance(appliance); }
public bool Exists(Appliance appliance) { return Get(appliance.Id) != null; }
internal void UpdateAppliance(Appliance appliance) { string query = ApplianceQuery.getQueryUpdateAppliance(appliance); ApplianceQuery.ParseDataSetToAppliance(_provider.queryExecute(query,UPDATE_TYPE)); }
internal void SaveAppliance(Appliance appliance) { string query = ApplianceQuery.getQuerySaveAppliance(appliance); ApplianceQuery.ParseDataSetToAppliance(_provider.queryExecute(query,INSERT_TYPE)); }
public static IList<Appliance> ParseDataSetToAppliance(DataTable dataTable) { IList<Appliance> applianceList = new List<Appliance>(); foreach (DataRow row in dataTable.Rows) { Appliance appliance = new Appliance() { Id = row[POSITION_ID_APPLIANCE].ToString(), Power = TryParseDouble(row[POSITION_POWER_APPLIANCE].ToString()), Subcategory = new SubCategory(row[POSITION_SUBCATEGORY_APPLIANCE].ToString()), Description = row[POSITION_DESCRIPTION_APPLIANCE].ToString(), Investment = TryParseDouble(row[POSITION_INVESTMENT_APPLIANCE].ToString()), Room = new Room(row[POSITION_ROOM_APPLIANCE].ToString()), ActivacionDateTime = getDateTime(row[POSITION_ACTIVATEDATETIME_APPLIANCE].ToString(), DATETIMEFORMAT_APPLIANCE), LeavingDateTime=getDateTime(row[POSITION_LEAVINGDATETIME_APPLIANCE].ToString(), DATETIMEFORMAT_APPLIANCE), LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_APPLIANCE].ToString(),DATETIMEFORMATINSERT_APPLIANCE), InsertUser = row[POSITION_INSERTUSER_APPLIANCE].ToString(), UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_APPLIANCE].ToString(),DATETIMEFORMATINSERT_APPLIANCE), UpdateUser = row[POSITION_UPDATEUSER_APPLIANCE].ToString(), Loadtype = new LoadType(row[POSITION_LOADTYPE_APPLIANCE].ToString()) }; applianceList.Add(appliance); } return applianceList; }