public static string getQuerySaveMacroCell(MacroCell macrocell) { return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", ID_TABLE_MACROCELL, macrocell.Id, macrocell.Description, macrocell.Region, macrocell.Currency.Id, macrocell.LocalInsertTime.ToString(DATETIMEFORMATINSERT_MACROCELL), macrocell.InsertUser, macrocell.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_MACROCELL), macrocell.UpdateUser); }
public static string getQueryUpdateMacroCell(MacroCell macrocell) { return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}',{7}='{8}',{9}='{10}' WHERE {11}='{12}'", ID_TABLE_MACROCELL, ID_DESCRIPTION_MACROCELL, macrocell.Description, ID_REGION_MACROCELL,macrocell.Region, ID_CURRENCY_MACROCELL,macrocell.Currency.Id, ID_UPDATETIME_DEVICE, macrocell.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_MACROCELL), ID_UPDATEUSER_DEVICE,macrocell.UpdateUser, ID_MACROCELID_MACROCELL,macrocell.Id ); }
public static IList<MacroCell> ParseDataSetToMacroCell(DataTable dataTable) { IList<MacroCell> macroCellList = new List<MacroCell>(); foreach (DataRow row in dataTable.Rows) { MacroCell macroCell = new MacroCell() { Id = row[POSITION_MACROCELLID_MACROCELL].ToString(), Description = row[POSITION_DESCRIPTION_MACROCELL].ToString(), Region = row[POSITION_REGION_MACROCELL].ToString(), Currency=new Currency(row[POSITION_CURRENCY_MACROCELL].ToString()), LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_MACROCELL].ToString(), DATETIMEFORMATINSERT_MACROCELL), InsertUser = row[POSITION_INSERTUSER_MACROCELL].ToString(), UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_MACROCELL].ToString(), DATETIMEFORMATINSERT_MACROCELL), UpdateUser = row[POSITION_UPDATEUSER_MACROCELL].ToString() }; macroCellList.Add(macroCell); } return macroCellList; }
public void Update(MacroCell macrocell) { _repositoryHelper.UpdateMacroCell(macrocell); }
public void Save(MacroCell macrocell) { _repositoryHelper.SaveMacroCell(macrocell); }
public bool Exists(MacroCell macrocell) { return Get(macrocell.Id) != null; }
internal void UpdateMacroCell(MacroCell macrocell) { string query = MacroCellQuery.getQueryUpdateMacroCell(macrocell); MacroCellQuery.ParseDataSetToMacroCell(_provider.queryExecute(query,UPDATE_TYPE)); }
internal void SaveMacroCell(MacroCell macrocell) { string query = MacroCellQuery.getQuerySaveMacroCell(macrocell); MacroCellQuery.ParseDataSetToMacroCell(_provider.queryExecute(query,INSERT_TYPE)); }