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