public static int Update(ChildMerges o)
{
try
{
string query = @"UPDATE ""CHILD_MERGES"" SET ""ID"" = @Id, ""EFFECTIVE_DATE"" = @EffectiveDate, ""CHILD_ID"" = @ChildId, ""SUBSUMED_ID"" = @SubsumedId WHERE ""ID"" = @Id ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@EffectiveDate", DbType.Date)
{
Value = o.EffectiveDate
},
new NpgsqlParameter("@ChildId", DbType.Int32)
{
Value = o.ChildId
},
new NpgsqlParameter("@SubsumedId", DbType.Int32)
{
Value = o.SubsumedId
},
new NpgsqlParameter("@Id", DbType.Int32)
{
Value = o.Id
}
};
int rowAffected = DBManager.ExecuteNonQueryCommand(query, CommandType.Text, parameters);
AuditTable.InsertEntity("ChildMerges", o.Id.ToString(), 2, DateTime.Now, 1);
return(rowAffected);
}
catch (Exception ex)
{
Log.InsertEntity("ChildMerges", "Update", 2, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}
public static int Insert(ChildMerges o)
{
try
{
string query = @"INSERT INTO ""CHILD_MERGES"" (""EFFECTIVE_DATE"", ""CHILD_ID"", ""SUBSUMED_ID"") VALUES (@EffectiveDate, @ChildId, @SubsumedId) returning ""ID"" ";
List <Npgsql.NpgsqlParameter> parameters = new List <NpgsqlParameter>()
{
new NpgsqlParameter("@EffectiveDate", DbType.Date)
{
Value = o.EffectiveDate
},
new NpgsqlParameter("@ChildId", DbType.Int32)
{
Value = o.ChildId
},
new NpgsqlParameter("@SubsumedId", DbType.Int32)
{
Value = o.SubsumedId
}
};
object id = DBManager.ExecuteScalarCommand(query, CommandType.Text, parameters);
AuditTable.InsertEntity("ChildMerges", id.ToString(), 1, DateTime.Now, 1);
return(int.Parse(id.ToString()));
}
catch (Exception ex)
{
Log.InsertEntity("ChildMerges", "Insert", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
}
return(-1);
}
public static ChildMerges GetChildMergesAsObject(DataTable dt)
{
foreach (DataRow row in dt.Rows)
{
try
{
ChildMerges o = new ChildMerges();
o.Id = Helper.ConvertToInt(row["ID"]);
o.EffectiveDate = Helper.ConvertToDate(row["EFFECTIVE_DATE"]);
o.ChildId = Helper.ConvertToInt(row["CHILD_ID"]);
o.SubsumedId = Helper.ConvertToInt(row["SUBSUMED_ID"]);
return(o);
}
catch (Exception ex)
{
Log.InsertEntity("ChildMerges", "GetChildMergesAsObject", 1, ex.StackTrace.Replace("'", ""), ex.Message.Replace("'", ""));
throw ex;
}
}
return(null);
}
