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