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