public void UpdateTimeZoneRule(int ruleID, SqlString WrittenName, int offsetmins, int year_start, int year_end, int StartTimeOfDay, int StartDayOfWeek, int StartWeek, int StartMonth, int EndTimeOfDay, int EndDayOfWeek, int EndWeek, int EndMonth, out bool error ) { error = false; SqlParameter prmError = StoredProcedure.CreateOutputParam("@Error", SqlDbType.Bit); prmError.Direction = ParameterDirection.Output; using (StoredProcedure sp = new StoredProcedure("prcTimeZoneRule_update", StoredProcedure.CreateInputParam("@RuleID", SqlDbType.Int, ruleID), StoredProcedure.CreateInputParam("@WrittenName", SqlDbType.NVarChar, 60, WrittenName), StoredProcedure.CreateInputParam("@OffsetDaylight", SqlDbType.Int, offsetmins), StoredProcedure.CreateInputParam("@year_start", SqlDbType.Int, year_start), StoredProcedure.CreateInputParam("@year_end", SqlDbType.Int, year_end), StoredProcedure.CreateInputParam("@StartTimeOfDay", SqlDbType.Int, StartTimeOfDay), StoredProcedure.CreateInputParam("@day_start", SqlDbType.Int, StartDayOfWeek), StoredProcedure.CreateInputParam("@week_start", SqlDbType.Int, StartWeek), StoredProcedure.CreateInputParam("@StartMonth", SqlDbType.Int, StartMonth), StoredProcedure.CreateInputParam("@EndTimeOfDay", SqlDbType.Int, EndTimeOfDay), StoredProcedure.CreateInputParam("@EndDayOfWeek", SqlDbType.Int, EndDayOfWeek), StoredProcedure.CreateInputParam("@EndWeek", SqlDbType.Int, EndWeek), StoredProcedure.CreateInputParam("@EndMonth", SqlDbType.Int, EndMonth), prmError ) ) { sp.ExecuteNonQuery(); error = (bool)prmError.Value; } }
public void purgeAutoEmails() { using (StoredProcedure sp = new StoredProcedure("prcEmail_Purge")) { sp.ExecuteNonQuery(); } }
public int AddUserEvent(Event pro) { int intProfileID = 0; using (StoredProcedure spAddProfile = new StoredProcedure("prcEvent_AddUserEvent", StoredProcedure.CreateInputParam("@EventID", SqlDbType.Int, pro.EventID), StoredProcedure.CreateInputParam("@EventName", SqlDbType.NVarChar, pro.EventName), StoredProcedure.CreateInputParam("@OrganisationID", SqlDbType.Int, pro.OrganisationID), StoredProcedure.CreateInputParam("@ProfileID", SqlDbType.Int, pro.ProfileID), StoredProcedure.CreateInputParam("@DateStart", SqlDbType.DateTime, ((pro.DateStart == DateTime.Parse("1/1/1900")) ? (object)System.DBNull.Value : pro.DateStart)), StoredProcedure.CreateInputParam("@DateEnd", SqlDbType.DateTime, ((pro.DateEnd == DateTime.Parse("1/1/1900")) ? (object)System.DBNull.Value : pro.DateEnd)), StoredProcedure.CreateInputParam("@Points", SqlDbType.Float, ((pro.Points == 0.0 ? (object)System.DBNull.Value : pro.Points))), StoredProcedure.CreateInputParam("@EndOfPeriodAction", SqlDbType.Char, pro.EndOfPeriodAction), StoredProcedure.CreateInputParam("@EventProvider", SqlDbType.NVarChar, pro.EventProvider), StoredProcedure.CreateInputParam("@EventType", SqlDbType.Int, pro.EventType), StoredProcedure.CreateInputParam("@EventLocation", SqlDbType.NVarChar, pro.EventLocation), StoredProcedure.CreateInputParam("@EventItem", SqlDbType.NVarChar, pro.EventItem), StoredProcedure.CreateInputParam("@UserType", SqlDbType.NVarChar, pro.UserType), StoredProcedure.CreateInputParam("@UserId", SqlDbType.Int, pro.UserID))) { spAddProfile.Parameters.Add("@EventPeriodID", SqlDbType.Int); spAddProfile.Parameters["@EventPeriodID"].Direction = ParameterDirection.Output; spAddProfile.ExecuteNonQuery(); intProfileID = Int32.Parse(spAddProfile.Parameters["@EventID"].Value.ToString()); this.EventPeriodID = Int32.Parse(spAddProfile.Parameters["@EventPeriodID"].Value.ToString()); return(intProfileID); } }
public void UpdateBadgeColor(string badgeID, string color) { var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = "[App.Sbo].[Badging.UpdateBadgeColor]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeID", ParameterType.DBInteger, int.Parse(badgeID))); storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeColor", ParameterType.DBInteger, int.Parse(color))); try { storedProcedure.ExecuteNonQuery(); } catch (Exception ex) { StringBuilder sb = new StringBuilder(); sb.AppendLine("UpdateBadgeColor() Exception.Message: " + ex.Message); sb.AppendLine("UpdateBadgeColor() Exception.InnerException: " + ex.InnerException); sb.AppendLine("UpdateBadgeColor() Exception.Source: " + ex.Source); sb.AppendLine("UpdateBadgeColor() Exception.StackTrace: " + ex.StackTrace); log4net.ILog log = log4net.LogManager.GetLogger("AirportIQ.Web.Verbose"); log.Debug(sb.ToString()); throw ex; } }
public void UpdateIWSBadgeInfo(string boaaBadgeID, string iwsCardID) { var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = "[App.Sbo].[IWS.NegateIWSBadgeID]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@BOAA_BadgeID", ParameterType.DBInteger, boaaBadgeID)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@IWS_CardID", ParameterType.DBInteger, iwsCardID)); try { storedProcedure.ExecuteNonQuery(); } catch (Exception ex) { StringBuilder sb = new StringBuilder(); sb.AppendLine("IwsBadgeInversion() Exception.Message: " + ex.Message); sb.AppendLine("IwsBadgeInversion() Exception.InnerException: " + ex.InnerException); sb.AppendLine("IwsBadgeInversion() Exception.Source: " + ex.Source); sb.AppendLine("IwsBadgeInversion() Exception.StackTrace: " + ex.StackTrace); log4net.ILog log = log4net.LogManager.GetLogger("AirportIQ.Web.Verbose"); log.Debug(sb.ToString()); throw ex; } }
public void WhenCreatedWithoutConnectionThenCreatesNewConnection() { SqlConnection connection1; SqlConnection connection2; using (var command = new StoredProcedure(TestStoredProcedureName)) { connection1 = command.Connection; command.Parameters["Parameter1"] = "test"; command.Parameters["Parameter2"] = 11; command.ExecuteNonQuery(); } using (var command = new StoredProcedure(TestStoredProcedureName)) { connection2 = command.Connection; command.Parameters["Parameter1"] = "test"; command.Parameters["Parameter2"] = 11; command.ExecuteNonQuery(); } Assert.NotSame(connection1, connection2); }
public void UpdateEvent(Event pro) { using (StoredProcedure spUpdateProfile = new StoredProcedure("prcEvent_Update", StoredProcedure.CreateInputParam("@EventID", SqlDbType.Int, pro.EventID), StoredProcedure.CreateInputParam("@EventPeriodID", SqlDbType.Int, pro.EventPeriodID), StoredProcedure.CreateInputParam("@EventName", SqlDbType.NVarChar, pro.EventName), StoredProcedure.CreateInputParam("@OrganisationID", SqlDbType.Int, pro.OrganisationID), StoredProcedure.CreateInputParam("@DateStart", SqlDbType.DateTime, ((pro.DateStart == DateTime.Parse("1/1/1900")) ? (object)System.DBNull.Value : pro.DateStart)), StoredProcedure.CreateInputParam("@DateEnd", SqlDbType.DateTime, ((pro.DateEnd == DateTime.Parse("1/1/1900")) ? (object)System.DBNull.Value : pro.DateEnd)), StoredProcedure.CreateInputParam("@Points", SqlDbType.Float, ((pro.Points == 0.0 ? (object)System.DBNull.Value : pro.Points))), StoredProcedure.CreateInputParam("@EndOfPeriodAction", SqlDbType.Char, pro.EndOfPeriodAction), StoredProcedure.CreateInputParam("@MonthIncrement", SqlDbType.Int, ((pro.MonthIncrement == 0 ? (object)System.DBNull.Value : pro.MonthIncrement))), StoredProcedure.CreateInputParam("@FutureDateStart", SqlDbType.DateTime, ((pro.FutureDateStart == DateTime.Parse("1/1/1900")) ? (object)System.DBNull.Value : pro.FutureDateStart)), StoredProcedure.CreateInputParam("@FutureDateEnd", SqlDbType.DateTime, ((pro.FutureDateEnd == DateTime.Parse("1/1/1900")) ? (object)System.DBNull.Value : pro.FutureDateEnd)), StoredProcedure.CreateInputParam("@ProfileID", SqlDbType.Int, pro.ProfileID), StoredProcedure.CreateInputParam("@EventProvider", SqlDbType.NVarChar, pro.EventProvider), StoredProcedure.CreateInputParam("@EventType", SqlDbType.Int, pro.EventType), StoredProcedure.CreateInputParam("@EventLocation", SqlDbType.NVarChar, pro.EventLocation), StoredProcedure.CreateInputParam("@RegisterPoint", SqlDbType.Bit, pro.RegisterPoint), StoredProcedure.CreateInputParam("@AllowUser", SqlDbType.Bit, pro.AllowUser), StoredProcedure.CreateInputParam("@FuturePoints", SqlDbType.Float, ((pro.FuturePoints == 0.0 ? (object)System.DBNull.Value : pro.FuturePoints))))) { spUpdateProfile.ExecuteNonQuery(); } }
public void SaveAuthorizedSigner(string personTypeStatusCode, string signerCode, DateTime whenTrained, DateTime whenExpires, Byte[] signatureImage, DateTime signatureDate, char trainingType, string instructor, string loginName, string password, DateTime passwordExpiresEndOf, bool isActive, int personId, int divisionId, string OASGroupName, int UserID, int securityUserId) { var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = schema + ".[Security.OASCTSaveAuthorizedSigner]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonTypeStatusCode", ParameterType.DBSingle, personTypeStatusCode)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@SignerCode", ParameterType.DBString, signerCode)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@WhenTrained", ParameterType.DBDateTime, whenTrained)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@WhenExpires", ParameterType.DBDateTime, whenExpires)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@SignatureImage", ParameterType.DBVarBinary, signatureImage)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@SignatureDate", ParameterType.DBDateTime, signatureDate)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@TrainingType", ParameterType.DBString, trainingType)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@Instructor", ParameterType.DBString, instructor)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@LoginName", ParameterType.DBString, loginName)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@Password", ParameterType.DBString, password)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@PasswordExpiresEndOf", ParameterType.DBDateTime, passwordExpiresEndOf)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@IsActive", ParameterType.DBBoolean, isActive)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonID", ParameterType.DBInteger, personId)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@DivisionID", ParameterType.DBInteger, divisionId)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@OASGroupName", ParameterType.DBString, OASGroupName)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@SecurityUserID", ParameterType.DBInteger, securityUserId)); storedProcedure.ExecuteNonQuery(); }
public void ResetPolicyUnitAccess(int PolicyID) { using (StoredProcedure spResetPolicyUnitAccess = new StoredProcedure("prcPolicy_ResetUnitAccess", StoredProcedure.CreateInputParam("@PolicyID", SqlDbType.Int, PolicyID))) { spResetPolicyUnitAccess.ExecuteNonQuery(); } }
public void SetPolicyUserAccessByUnit(int PolicyID, int UnitID) { using (StoredProcedure spSetPolicyUserAccessByUnit = new StoredProcedure("prcPolicy_SetUserAccessByUnit", StoredProcedure.CreateInputParam("@PolicyID", SqlDbType.Int, PolicyID), StoredProcedure.CreateInputParam("@UnitID", SqlDbType.Int, UnitID))) { spSetPolicyUserAccessByUnit.ExecuteNonQuery(); } }
public void DeleteEventPeriod(int EventPeriodID) { using (StoredProcedure spDeleteEventPeriod = new StoredProcedure("prcEventPeriod_Delete", StoredProcedure.CreateInputParam("@eventPeriodId", SqlDbType.Int, EventPeriodID) )) { spDeleteEventPeriod.ExecuteNonQuery(); } }
/// <summary> /// Specialized shadow table version of save routine for requirement documents /// </summary> /// <param name="requirementdocumentsToSave"></param> /// <param name="userID"></param> public void ShadowSaveRequirementDocuments(DataTable requirementdocumentsToSave, int userID) { var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = _ShadowSchema + ".[Data.RequirementsDocuments.Save]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@RequirementDocumentsTableTypes", ParameterType.Structured, requirementdocumentsToSave)); storedProcedure.ExecuteNonQuery(); }
public void AcceptFile(int FileID, int UserID) { using (StoredProcedure spCheckFile = new StoredProcedure("prcEventFiles_Accepted", StoredProcedure.CreateInputParam("@FileID", SqlDbType.Int, FileID), StoredProcedure.CreateInputParam("@UserID", SqlDbType.Int, UserID))) { spCheckFile.ExecuteNonQuery(); } }
public void DeleteEbook(int courseID) { using (StoredProcedure sp = new StoredProcedure("prcCourse_EbookDelete", StoredProcedure.CreateInputParam("@courseid", SqlDbType.Int, courseID) )) { sp.ExecuteNonQuery(); } }
public void DeleteReport(int scheduleId) { using (StoredProcedure sp = new StoredProcedure("prcDeleteReport", StoredProcedure.CreateInputParam("@ScheduleId", SqlDbType.Int, scheduleId) )) { sp.ExecuteNonQuery(); } }
public void DeleteFuturePeriod(int EventID) { using (StoredProcedure spInit = new StoredProcedure("prcEventPeriod_DeleteFuturePeriod", StoredProcedure.CreateInputParam("@EventID", SqlDbType.Int, EventID))) { spInit.ExecuteNonQuery(); } }
public void InitialisePolicyAccess(int OrganisationID, int PolicyID, bool granted) { using (StoredProcedure spInit = new StoredProcedure("prcOrganisation_InitialisePolicyAccess", StoredProcedure.CreateInputParam("@OrganisationID", SqlDbType.Int, OrganisationID), StoredProcedure.CreateInputParam("@PolicyID", SqlDbType.Int, PolicyID), StoredProcedure.CreateInputParam("@granted", SqlDbType.Bit, granted))) { spInit.ExecuteNonQuery(); } }
} //UploadToolbookXMLPreview /// <summary> /// This method creates a new quiz audit entry that indicates a person has attempted a quiz. /// </summary> /// <remarks> /// Assumptions: None /// Notes: /// Author: Peter Kneale 3/02/2004 /// Changes: /// </remarks> /// <param name="sessionID">The session id of the Quiz Session</param> /// <param name="toolbookPageID">The toolbook Page ID of the quiz attempted by the person</param> public void CreateQuizQuestionAudit(string sessionID, string toolbookPageID) { using (StoredProcedure sp = new StoredProcedure("prcQuizSession_CreateQuizAudit", StoredProcedure.CreateInputParam("@strQuizSessionID", SqlDbType.VarChar, 50, sessionID), StoredProcedure.CreateInputParam("@strToolbookPageID", SqlDbType.VarChar, 50, toolbookPageID) )) { sp.ExecuteNonQuery(); } } //CreateQuizQuestionAudit
public void SetPolicyUserAccessByUser(int PolicyID, int UserID, int Granted) { using (StoredProcedure spSetPolicyUserAccessByUser = new StoredProcedure("prcPolicy_SetUserAccessByUser", StoredProcedure.CreateInputParam("@PolicyID", SqlDbType.Int, PolicyID), StoredProcedure.CreateInputParam("@UserID", SqlDbType.Int, UserID), StoredProcedure.CreateInputParam("@Granted", SqlDbType.Bit, Granted))) { spSetPolicyUserAccessByUser.ExecuteNonQuery(); } }
public void DeleteEventType(Event pro) { using (StoredProcedure spUpdateProfile = new StoredProcedure("prcEventType_Delete", StoredProcedure.CreateInputParam("@EventTypeId", SqlDbType.Int, pro.EventTypeId) )) { spUpdateProfile.ExecuteNonQuery(); } }
public void UpdateEventFile(Event pro) { using (StoredProcedure spUpdateProfile = new StoredProcedure("prcEventFile_Update", StoredProcedure.CreateInputParam("@FileID", SqlDbType.Int, pro.FileID), StoredProcedure.CreateInputParam("@FileName", SqlDbType.NVarChar, pro.FileName) )) { spUpdateProfile.ExecuteNonQuery(); } }
public void InitialiseEventPeriodAccess(int OrganisationID, int ProfileID, int EventPeriodID) { using (StoredProcedure spInit = new StoredProcedure("prcEvent_InitialiseEventPeriodAccess", StoredProcedure.CreateInputParam("@OrganisationID", SqlDbType.Int, OrganisationID), StoredProcedure.CreateInputParam("@ProfileID", SqlDbType.Int, ProfileID), StoredProcedure.CreateInputParam("@EventPeriodID", SqlDbType.Int, EventPeriodID))) { spInit.ExecuteNonQuery(); } }
public void SaveDivisionChanges(DataTable divisionchangesToSave, int UserID) { var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = _Schema + ".[Data.DivisionChanges.Save]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@DivisionChangesTableTypes", ParameterType.Structured, divisionchangesToSave)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID)); storedProcedure.ExecuteNonQuery(); }
public void WhenUsingExecuteNonQueryThenExecutes() { using (var command = new StoredProcedure(TestStoredProcedureName)) { command.Parameters["Parameter1"] = "test"; command.Parameters["Parameter2"] = 11; int result = command.ExecuteNonQuery(); } }
public void RejectContract(int stateID, int userID) { var storedProcedure = new StoredProcedure(); storedProcedure.StoredProcedureName = schema + ".[Data.ContractVerification.Reject]"; storedProcedure.Parameters.Add(new StoredProcedureParameter("@StateID", ParameterType.DBInteger, stateID)); storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID)); storedProcedure.ExecuteNonQuery(); }
private void delDME(int StudentID, int ModuleID) { // delete dmes using (StoredProcedure sp = new StoredProcedure("prcSCORMdeleteDME", StoredProcedure.CreateInputParam("@StudentID", SqlDbType.Int, StudentID), StoredProcedure.CreateInputParam("@LessonID", SqlDbType.Int, ModuleID))) { sp.ExecuteNonQuery(); } }
public void WhenCreatedWithoutConnectionAndDefaultAccessorParametersThenExecutes() { using (var command = new StoredProcedure(TestStoredProcedureName)) { command.Parameters["Parameter1"] = "test"; command.Parameters["Parameter2"] = 11; int result = command.ExecuteNonQuery(); } }
public void SaveCCUser(int userId, int scheduleId) { using (StoredProcedure sp = new StoredProcedure("prcReport_SaveCCUser", StoredProcedure.CreateInputParam("@UserId", SqlDbType.Int, userId), StoredProcedure.CreateInputParam("@ScheduleId", SqlDbType.Int, scheduleId) )) { sp.ExecuteNonQuery(); } }
} // GetUserMashup public void AddEbook(int courseid, string ebookFileName, string serverFileName) { using (StoredProcedure sp = new StoredProcedure("prcCourse_EbookAdd", StoredProcedure.CreateInputParam("@courseid", SqlDbType.Int, courseid), StoredProcedure.CreateInputParam("@ebookFileName", SqlDbType.NVarChar, 500, ebookFileName), StoredProcedure.CreateInputParam("@serverFileName", SqlDbType.VarChar, 500, serverFileName))) { sp.ExecuteNonQuery(); } }
private static void UpdateCourseStatus(int userID, int moduleID) { using (StoredProcedure sp = new StoredProcedure("prcUserQuizStatus_UpdateCourseStatus", StoredProcedure.CreateInputParam("@ModuleID", SqlDbType.Int, moduleID), StoredProcedure.CreateInputParam("@UserID", SqlDbType.Int, userID) )) { sp.ExecuteNonQuery(); } }
/// <param name="p_Password">ѕередаем null, если хотим чтоб не измен¤лс¤ пассворд</param> public static void UpdateCustomer(int p_CustomerID, string p_FirstName, string p_LastName, string p_Email, string p_Password) { StoredProcedure sp = new StoredProcedure("p_Customers_u"); sp["@CustomerID"].Value = p_CustomerID; sp["@FirstName"].Value = p_FirstName.Trim(); sp["@LastName"].Value = p_LastName.Trim(); sp["@Email"].Value = p_Email.Trim(); sp["@Password"].Value = p_Password == null ? DBNull.Value : (object)p_Password.Trim(); sp.ExecuteNonQuery(); }
public static void DeleteCustomerAddress(int p_CustomerAddressID) { StoredProcedure sp = new StoredProcedure("p_CustomerAddresses_d"); sp["@CustomerAddressID"].Value = p_CustomerAddressID; sp.ExecuteNonQuery(); }
public static void SetEnable(int p_CategoryID, bool p_isDisable) { StoredProcedure sp = new StoredProcedure("p_Categories_setEnable"); sp["@CategoryID"].Value = p_CategoryID; sp["@isDisable"].Value = p_isDisable; sp.ExecuteNonQuery(); }
public static void UpdateCategory(int p_CategoryID, int? p_ParentCategoryID, string p_Name, string p_CategoryCode, bool p_bShowOpen, string p_Picture) { StoredProcedure sp = new StoredProcedure("p_Categories_u"); sp["@CategoryID"].Value = p_CategoryID; sp["@ParentCategoryID"].Value = p_ParentCategoryID == null ? DBNull.Value : (object)p_ParentCategoryID; sp["@Name"].Value = p_Name.Trim(); sp["@CategoryCode"].Value = p_CategoryCode.Trim(); sp["@ShowOpen"].Value = p_bShowOpen; sp["@Picture"].Value = p_Picture; sp.ExecuteNonQuery(); }
public static void UpdateCategoryOrder(int p_CategoryID, OrderDirection p_Direction) { StoredProcedure sp = new StoredProcedure("p_Categories_u_Order"); sp["@CategoryID"].Value = p_CategoryID; sp["@Direction"].Value = (int) p_Direction; sp.ExecuteNonQuery(); }
public static void DeleteCategory(int p_CategoryID) { StoredProcedure sp = new StoredProcedure("p_Categories_d"); sp["@CategoryID"].Value = p_CategoryID; sp.ExecuteNonQuery(); }
public static void DeleteBanner(int p_BannerID) { StoredProcedure sp = new StoredProcedure("p_Banners_d"); sp["@BannerID"].Value = p_BannerID; sp.ExecuteNonQuery(); }
public static void UpdateCustomerCampaign(int p_CustomerID, int p_CampaignID) { StoredProcedure sp = new StoredProcedure("p_Customers_u_CampaignID"); sp["@CustomerID"].Value = p_CustomerID; sp["@CampaignID"].Value = p_CampaignID; sp.ExecuteNonQuery(); }