public bool UpdateUSER_Operation(USER_Operation uSER_Operation) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateUSER_Operation", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@OperationID", SqlDbType.Int).Value = uSER_Operation.OperationID; cmd.Parameters.Add("@OperationName", SqlDbType.NVarChar).Value = uSER_Operation.OperationName; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = uSER_Operation.Description; cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = uSER_Operation.UpdatedBy; cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = uSER_Operation.UpdatedDate; cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = uSER_Operation.RowStatusID; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public USER_Operation GetUSER_OperationFromReader(IDataReader reader) { try { USER_Operation uSER_Operation = new USER_Operation ( DataAccessObject.IsNULL<int>(reader["OperationID"]), DataAccessObject.IsNULL<string>(reader["OperationName"]), DataAccessObject.IsNULL<string>(reader["Description"]), DataAccessObject.IsNULL<string>(reader["AddedBy"]), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["UpdatedBy"]), DataAccessObject.IsNULL<DateTime>(reader["UpdatedDate"]), DataAccessObject.IsNULL<int>(reader["RowStatusID"]) ); return uSER_Operation; } catch(Exception ex) { return null; } }