public Int32 UpdateFlag(InboundDocUserFlagDto pUserFlagData)
{
string updateSql = DBUtils.SCHEMA_NAME + "PKG_INBOUND_EXT$p_update_user_flag";
Int32 rowsUpdated = 0;
using (SqlConnection conn = new SqlConnection(sqlConnStr))
{
using (SqlCommand cmd = new SqlCommand(updateSql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@p_inbound_doc_id", System.Data.SqlDbType.Int).Value = pUserFlagData.InboundDocId;
cmd.Parameters.Add("@p_inbound_user", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.InboundUser);
cmd.Parameters.Add("@p_flag_type", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.FlagType);
cmd.Parameters.Add("@p_comment", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.Comments);
cmd.Parameters.Add("@p_update_delete_ind", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.UpdateDeleteInd);
conn.Open();
rowsUpdated = cmd.ExecuteNonQuery();
}
}
return rowsUpdated;
}
public Int32 UpdateFlag(InboundDocUserFlagDto pUserFlagData)
{
string updateSql = DBUtils.SCHEMA_NAME + "PKG_INBOUND_EXT$p_update_user_flag";
Int32 rowsUpdated = 0;
using (SqlConnection conn = new SqlConnection(sqlConnStr))
{
using (SqlCommand cmd = new SqlCommand(updateSql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@p_inbound_doc_id", System.Data.SqlDbType.Int).Value = pUserFlagData.InboundDocId;
cmd.Parameters.Add("@p_inbound_user", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.InboundUser);
cmd.Parameters.Add("@p_flag_type", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.FlagType);
cmd.Parameters.Add("@p_comment", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.Comments);
cmd.Parameters.Add("@p_update_delete_ind", System.Data.SqlDbType.VarChar).Value = DBUtils.ValueStringOrDBNull(pUserFlagData.UpdateDeleteInd);
conn.Open();
rowsUpdated = cmd.ExecuteNonQuery();
}
}
return(rowsUpdated);
}
