public static int Update(PersonConfiguration o) { try { string query = @"UPDATE ""PERSON_CONFIGURATION"" SET ""ID"" = @Id, ""COLUMN_NAME"" = @ColumnName, ""IS_VISIBLE"" = @IsVisible, ""IS_MANDATORY"" = @IsMandatory WHERE ""ID"" = @Id "; List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>() { new NpgsqlParameter("@ColumnName", DbType.String) { Value = o.ColumnName }, new NpgsqlParameter("@IsVisible", DbType.Boolean) { Value = o.IsVisible }, new NpgsqlParameter("@IsMandatory", DbType.Boolean) { Value = o.IsMandatory }, new NpgsqlParameter("@Id", DbType.Int32) { Value = o.Id } }; int rowAffected = DBManager.ExecuteNonQueryCommand(query, CommandType.Text, parameters); AuditTable.InsertEntity("PersonConfiguration", o.Id.ToString(), 2, DateTime.Now, 1); return(rowAffected); } catch (Exception ex) { Log.InsertEntity("PersonConfiguration", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", "")); } return(-1); }
public static int Insert(PersonConfiguration o) { try { string query = @"INSERT INTO ""PERSON_CONFIGURATION"" (""COLUMN_NAME"", ""IS_VISIBLE"", ""IS_MANDATORY"") VALUES (@ColumnName, @IsVisible, @IsMandatory) returning ""ID"" "; List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>() { new NpgsqlParameter("@ColumnName", DbType.String) { Value = o.ColumnName }, new NpgsqlParameter("@IsVisible", DbType.Boolean) { Value = o.IsVisible }, new NpgsqlParameter("@IsMandatory", DbType.Boolean) { Value = o.IsMandatory } }; object id = DBManager.ExecuteScalarCommand(query, CommandType.Text, parameters); AuditTable.InsertEntity("PersonConfiguration", id.ToString(), 1, DateTime.Now, 1); return(int.Parse(id.ToString())); } catch (Exception ex) { Log.InsertEntity("PersonConfiguration", "Insert", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", "")); } return(-1); }
public static PersonConfiguration GetPersonConfigurationAsObject(DataTable dt) { foreach (DataRow row in dt.Rows) { try { PersonConfiguration o = new PersonConfiguration(); o.Id = Helper.ConvertToInt(row["ID"]); o.ColumnName = row["COLUMN_NAME"].ToString(); o.IsVisible = Helper.ConvertToBoolean(row["IS_VISIBLE"]); o.IsMandatory = Helper.ConvertToBoolean(row["IS_MANDATORY"]); return(o); } catch (Exception ex) { Log.InsertEntity("PersonConfiguration", "GetPersonConfigurationAsObject", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", "")); throw ex; } } return(null); }