public static string getQueryUpdateCell(Cell cell) { 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_CELL, ID_MACROCELL_CELL,cell.Macrocell.Id, ID_LATITUDE_CELL, cell.Latitude, ID_LONGITUDE_CELL,cell.Longitude, ID_SURFACE_CELL,cell.Surface, ID_VOLUMEN_CELL,cell.Volumen, ID_BUILDING_SHADE_COEFICIENT_CELL,cell.BuildingShadeCoefficient, ID_WALL_INSULATION_THICKNESS_CELL,cell.WallInsulationThickness, ID_DESCRIPTION_CELL,cell.Description, ID_UPDATETIME_DEVICE,cell.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_CELL), ID_UPDATEUSER_DEVICE,cell.UpdateUser, ID_CELLID_CELL,cell.Id ); }
public static string getQuerySaveCell(Cell cell) { return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}')", ID_TABLE_CELL, cell.Id, cell.Macrocell.Id, cell.Latitude, cell.Longitude, cell.Surface, cell.Volumen, cell.BuildingShadeCoefficient, cell.WallInsulationThickness, cell.Description, cell.LocalInsertTime.ToString(DATETIMEFORMATINSERT_CELL), cell.InsertUser, cell.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_CELL), cell.UpdateUser); }
internal void UpdateCell(Cell cell) { string query = CellQuery.getQueryUpdateCell(cell); CellQuery.ParseDataSetToCell(_provider.queryExecute(query,UPDATE_TYPE)); }
internal void SaveCell(Cell cell) { string query = CellQuery.getQuerySaveCell(cell); CellQuery.ParseDataSetToCell(_provider.queryExecute(query,INSERT_TYPE)); }
public void Update(Cell cell) { _repositoryHelper.UpdateCell(cell); }
public void Save(Cell cell) { _repositoryHelper.SaveCell(cell); }
public bool Exists(Cell cell) { return Get(cell.Id) != null; }
public static IList<Cell> ParseDataSetToCell(DataTable dataTable) { IList<Cell> cellList = new List<Cell>(); foreach (DataRow row in dataTable.Rows) { Cell cell = new Cell() { Id = row[POSITION_CELLID_CELL].ToString(), Macrocell=new MacroCell(row[POSITION_MACROCELL_CELL].ToString()), Latitude = Double.Parse(row[POSITION_LATITUDE_CELL].ToString()), Longitude = Double.Parse(row[POSITION_LONGITUDE_CELL].ToString()), Surface=Double.Parse(row[POSITION_SURFACE_CELL].ToString()), Volumen = Double.Parse(row[POSITION_VOLUMEN_CELL].ToString()), BuildingShadeCoefficient = int.Parse(row[POSITION_BUILDING_SHADE_COEFICIENT_CELL].ToString()), WallInsulationThickness = int.Parse(row[POSITION_WALL_INSULATION_THICKNESS_CELL].ToString()), Description = row[POSITION_DESCRIPTION_CELL].ToString(), LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_MACROCELL].ToString(), DATETIMEFORMATINSERT_CELL), InsertUser = row[POSITION_INSERTUSER_MACROCELL].ToString(), UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_MACROCELL].ToString(), DATETIMEFORMATINSERT_CELL), UpdateUser = row[POSITION_UPDATEUSER_MACROCELL].ToString() }; cellList.Add(cell); } return cellList; }