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