Esempio n. 1
0
        /// <summary>
        /// Creates an object wrapper for the BAOCAO_SOLUONG_NHANGUI_MAU Procedure
        /// </summary>
        public static StoredProcedure BaocaoSoluongNhanguiMau(DateTime? fromDate, DateTime? ToDate, int? ObjectTypeID, int? IDLoaiXN, int? DepartmentID, int? Noitru, int? LAM, string NguoiNhan, string NguoiGui, int? StatusPrint, int? GioNhan)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("BAOCAO_SOLUONG_NHANGUI_MAU", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@fromDate", fromDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@ToDate", ToDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@ObjectType_ID", ObjectTypeID, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@ID_Loai_XN", IDLoaiXN, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@Department_ID", DepartmentID, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@Noitru", Noitru, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@LAM", LAM, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@NguoiNhan", NguoiNhan, DbType.String, null, null);

            sp.Command.AddParameter("@NguoiGui", NguoiGui, DbType.String, null, null);

            sp.Command.AddParameter("@StatusPrint", StatusPrint, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@GioNhan", GioNhan, DbType.Int32, 0, 10);

            return sp;
        }
Esempio n. 2
0
        /// <summary>
        /// Creates an object wrapper for the baocao_danhsachhoadon_thuphi Procedure
        /// </summary>
        public static StoredProcedure BaocaoDanhsachhoadonThuphi(DateTime? TuNgay, DateTime? DenNgay, int? LoaiTimKiem, string DoiTuong, string NguoiThu, int? NTNT, int? cohoadon, string maquyen, int? fromserie, int? toserie, string KhoaThucHien)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("baocao_danhsachhoadon_thuphi", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@TuNgay", TuNgay, DbType.DateTime, null, null);

            sp.Command.AddParameter("@DenNgay", DenNgay, DbType.DateTime, null, null);

            sp.Command.AddParameter("@LoaiTimKiem", LoaiTimKiem, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@DoiTuong", DoiTuong, DbType.String, null, null);

            sp.Command.AddParameter("@NguoiThu", NguoiThu, DbType.String, null, null);

            sp.Command.AddParameter("@NTNT", NTNT, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@cohoadon", cohoadon, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@maquyen", maquyen, DbType.String, null, null);

            sp.Command.AddParameter("@from_serie", fromserie, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@to_serie", toserie, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@KhoaThucHien", KhoaThucHien, DbType.String, null, null);

            return sp;
        }
Esempio n. 3
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_Membership_CreateUser Procedure
        /// </summary>
        public static StoredProcedure AspnetMembershipCreateUser(string ApplicationName, string UserName, string Password, string PasswordSalt, string Email, string PasswordQuestion, string PasswordAnswer, bool? IsApproved, DateTime? CurrentTimeUtc, DateTime? CreateDate, int? UniqueEmail, int? PasswordFormat, Guid? UserId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Membership_CreateUser", DataService.GetInstance("SignificantTradeSS"), "dbo");

            sp.Command.AddParameter("@ApplicationName", ApplicationName, DbType.String, null, null);

            sp.Command.AddParameter("@UserName", UserName, DbType.String, null, null);

            sp.Command.AddParameter("@Password", Password, DbType.String, null, null);

            sp.Command.AddParameter("@PasswordSalt", PasswordSalt, DbType.String, null, null);

            sp.Command.AddParameter("@Email", Email, DbType.String, null, null);

            sp.Command.AddParameter("@PasswordQuestion", PasswordQuestion, DbType.String, null, null);

            sp.Command.AddParameter("@PasswordAnswer", PasswordAnswer, DbType.String, null, null);

            sp.Command.AddParameter("@IsApproved", IsApproved, DbType.Boolean, null, null);

            sp.Command.AddParameter("@CurrentTimeUtc", CurrentTimeUtc, DbType.DateTime, null, null);

            sp.Command.AddParameter("@CreateDate", CreateDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@UniqueEmail", UniqueEmail, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@PasswordFormat", PasswordFormat, DbType.Int32, 0, 10);

            sp.Command.AddOutputParameter("@UserId", DbType.Guid, null, null);

            return sp;
        }
 /// <summary>
 /// Creates an object wrapper for the dt_checkinobject Procedure
 /// </summary>
 public static StoredProcedure DtCheckinobject(string chObjectType, string vchObjectName, string vchComment, string vchLoginName, string vchPassword, int? iVCSFlags, int? iActionFlag, string txStream1, string txStream2, string txStream3)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dt_checkinobject", DataService.GetInstance("WWIprov"), "dbo");
 	
     sp.Command.AddParameter("@chObjectType", chObjectType, DbType.AnsiStringFixedLength, null, null);
 	
     sp.Command.AddParameter("@vchObjectName", vchObjectName, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@vchComment", vchComment, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@vchLoginName", vchLoginName, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@vchPassword", vchPassword, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@iVCSFlags", iVCSFlags, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@iActionFlag", iActionFlag, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@txStream1", txStream1, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@txStream2", txStream2, DbType.AnsiString, null, null);
 	
     sp.Command.AddParameter("@txStream3", txStream3, DbType.AnsiString, null, null);
 	
     return sp;
 }
        /// <summary>
        /// Creates an object wrapper for the ELMAH_LogError Procedure
        /// </summary>
        public static StoredProcedure Elmah_LogError(Guid? ErrorId, string Application, string Host, string Type, string Source, string Message, string User, string AllXml, int? StatusCode, DateTime? TimeUtc)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("ELMAH_LogError" , DataService.GetInstance("DotNetKicks"));

            sp.Command.AddParameter("@ErrorId", ErrorId,DbType.Guid);

            sp.Command.AddParameter("@Application", Application,DbType.String);

            sp.Command.AddParameter("@Host", Host,DbType.String);

            sp.Command.AddParameter("@Type", Type,DbType.String);

            sp.Command.AddParameter("@Source", Source,DbType.String);

            sp.Command.AddParameter("@Message", Message,DbType.String);

            sp.Command.AddParameter("@User", User,DbType.String);

            sp.Command.AddParameter("@AllXml", AllXml,DbType.String);

            sp.Command.AddParameter("@StatusCode", StatusCode,DbType.Int32);

            sp.Command.AddParameter("@TimeUtc", TimeUtc,DbType.DateTime);

            return sp;
        }
        /// <summary>
        /// Creates an object wrapper for the GetItem Procedure
        /// </summary>
        public static StoredProcedure GetItem(string itemId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("GetItem", DataService.GetInstance("External"), "dbo");

            sp.Command.AddParameter("@itemId", itemId, DbType.String, null, null);

            return sp;
        }
        /// <summary>
        /// Creates an object wrapper for the GetChildItems Procedure
        /// </summary>
        public static StoredProcedure GetChildItems(string categoryId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("GetChildItems", DataService.GetInstance("External"), "dbo");

            sp.Command.AddParameter("@categoryId", categoryId, DbType.String, null, null);

            return sp;
        }
Esempio n. 8
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Core_FetchStateOrRegionByCountryCode Procedure
        /// </summary>
        public static StoredProcedure FetchStateOrRegionByCountryCode(string Code)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Core_FetchStateOrRegionByCountryCode" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@Code", Code,DbType.String);

            return sp;
        }
Esempio n. 9
0
        /// <summary>
        /// Creates an object wrapper for the BExpRelate_sp Procedure
        /// </summary>
        public static StoredProcedure BExpRelate_Sp(int? BusinessExpId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("BExpRelate_sp", DataService.GetInstance("SubsonicProvider"), "dbo");

            sp.Command.AddParameter("@BusinessExpId", BusinessExpId, DbType.Int32, 0, 10);

            return sp;
        }
 /// <summary>
 /// Creates an object wrapper for the price_by_companyid_ext Procedure
 /// </summary>
 public static StoredProcedure PriceByCompanyidExt(int? companyid)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("price_by_companyid_ext", DataService.GetInstance("pricerprov"), "pricer_u");
 	
     sp.Command.AddParameter("@companyid", companyid, DbType.Int32, 0, 10);
 	
     return sp;
 }
Esempio n. 11
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Store_FetchAssociatedDownloadsByProductIdAndForPurchase Procedure
        /// </summary>
        public static StoredProcedure FetchAssociatedDownloadsByProductIdAndForPurchase(int? ProductId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Store_FetchAssociatedDownloadsByProductIdAndForPurchase" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@ProductId", ProductId,DbType.Int32);

            return sp;
        }
Esempio n. 12
0
        /// <summary>
        /// Creates an object wrapper for the Danhmuc_Xoadanhsachbaocaohethong Procedure
        /// </summary>
        public static StoredProcedure DanhmucXoadanhsachbaocaohethong(string lstID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Danhmuc_Xoadanhsachbaocaohethong", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@lstID", lstID, DbType.String, null, null);

            return sp;
        }
Esempio n. 13
0
        /// <summary>
        /// Creates an object wrapper for the BasEmScoregv_sp Procedure
        /// </summary>
        public static StoredProcedure BasEmScoregv_Sp(int? EmployeeId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("BasEmScoregv_sp", DataService.GetInstance("SubsonicProvider"), "dbo");

            sp.Command.AddParameter("@EmployeeId", EmployeeId, DbType.Int32, 0, 10);

            return sp;
        }
Esempio n. 14
0
        /// <summary>
        /// Creates an object wrapper for the CustOrdersDetail Procedure
        /// </summary>
        public static StoredProcedure CustOrdersDetail(int? OrderID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersDetail", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[OrderID]", OrderID, DbType.Int32, null, null);

            return sp;
        }
Esempio n. 15
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Store_FetchAllProductsByCategoryId Procedure
        /// </summary>
        public static StoredProcedure FetchAllProductsByCategoryId(int? CategoryId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Store_FetchAllProductsByCategoryId" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@CategoryId", CategoryId,DbType.Int32);

            return sp;
        }
Esempio n. 16
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Content_FetchTemplateRegionsByTemplateId Procedure
        /// </summary>
        public static StoredProcedure FetchTemplateRegionsByTemplateId(int? TemplateId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Content_FetchTemplateRegionsByTemplateId" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@TemplateId", TemplateId,DbType.Int32);

            return sp;
        }
Esempio n. 17
0
        /// <summary>
        /// Creates an object wrapper for the Dmuc_Laydanhmucthuoc_Xuatexcel Procedure
        /// </summary>
        public static StoredProcedure DmucLaydanhmucthuocXuatexcel(int? All)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Dmuc_Laydanhmucthuoc_Xuatexcel", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@All", All, DbType.Int32, 0, 10);

            return sp;
        }
Esempio n. 18
0
        /// <summary>
        /// Creates an object wrapper for the CustOrdersOrders Procedure
        /// </summary>
        public static StoredProcedure CustOrdersOrders(string CustomerID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersOrders", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[CustomerID]", CustomerID, DbType.String, null, null);

            return sp;
        }
Esempio n. 19
0
        /// <summary>
        /// Creates an object wrapper for the CustOrderHist Procedure
        /// </summary>
        public static StoredProcedure CustOrderHist(string CustomerID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrderHist", DataService.GetInstance("NorthwindRepository"), "dbo");

            sp.Command.AddParameter("@CustomerID", CustomerID, DbType.String, null, null);

            return sp;
        }
        /// <summary>
        /// Creates an object wrapper for the aspnet_AnyDataInTables Procedure
        /// </summary>
        public static StoredProcedure AspnetAnyDataInTables(int? TablesToCheck)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_AnyDataInTables" , DataService.GetInstance("WinSubSonicProvider"));

            sp.Command.AddParameter("@TablesToCheck", TablesToCheck,DbType.Int32);

            return sp;
        }
Esempio n. 21
0
        /// <summary>
        /// Creates an object wrapper for the CustOrdersDetail Procedure
        /// </summary>
        public static StoredProcedure CustOrdersDetail(int? OrderID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CustOrdersDetail", DataService.GetInstance("NorthwindRepository"), "dbo");

            sp.Command.AddParameter("@OrderID", OrderID, DbType.Int32, 0, 10);

            return sp;
        }
 /// <summary>
 /// Creates an object wrapper for the dt_adduserobject_vcs Procedure
 /// </summary>
 public static StoredProcedure DtAdduserobjectVcs(string vchProperty)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dt_adduserobject_vcs", DataService.GetInstance("WWIprov"), "dbo");
 	
     sp.Command.AddParameter("@vchProperty", vchProperty, DbType.AnsiString, null, null);
 	
     return sp;
 }
Esempio n. 23
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_Setup_RemoveAllRoleMembers Procedure
        /// </summary>
        public static StoredProcedure AspnetSetupRemoveAllRoleMembers(string name)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Setup_RemoveAllRoleMembers", DataService.GetInstance("Peerfx"), "dbo");

            sp.Command.AddParameter("@name", name, DbType.String, null, null);

            return sp;
        }
Esempio n. 24
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_AnyDataInTables Procedure
        /// </summary>
        public static StoredProcedure AspnetAnyDataInTables(int? TablesToCheck)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_AnyDataInTables", DataService.GetInstance("SignificantTradeSS"), "dbo");

            sp.Command.AddParameter("@TablesToCheck", TablesToCheck, DbType.Int32, 0, 10);

            return sp;
        }
Esempio n. 25
0
 /// <summary>
 /// Creates an object wrapper for the sp_FixPeriodBillingRates Procedure
 /// </summary>
 public static StoredProcedure SpFixPeriodBillingRates(int? PeriodID)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_FixPeriodBillingRates" , DataService.GetInstance("Billing"));
 	
     sp.Command.AddParameter("@PeriodID", PeriodID,DbType.Int32);
 	    
     return sp;
 }
Esempio n. 26
0
        /// <summary>
        /// Creates an object wrapper for the sp_AdminLogin Procedure
        /// </summary>
        public static StoredProcedure SpAdminLogin(string UserName, string Password)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_AdminLogin", DataService.GetInstance("SchoolManagementSystem"), "dbo");

            sp.Command.AddParameter("@UserName", UserName, DbType.AnsiString, null, null);

            sp.Command.AddParameter("@Password", Password, DbType.AnsiString, null, null);

            return(sp);
        }
Esempio n. 27
0
        /// <summary>
        /// Creates an object wrapper for the sp_Groups Procedure
        /// </summary>
        public static StoredProcedure SpGroups(int?AssignTo, int?BranchID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_Groups", DataService.GetInstance("SchoolManagementSystem"), "dbo");

            sp.Command.AddParameter("@AssignTo", AssignTo, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@BranchID", BranchID, DbType.Int32, 0, 10);

            return(sp);
        }
Esempio n. 28
0
        /// <summary>
        /// Creates an object wrapper for the sp_BranchDashBoard Procedure
        /// </summary>
        public static StoredProcedure SpBranchDashBoard(int?BranchID, DateTime?DateX)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_BranchDashBoard", DataService.GetInstance("SchoolManagementSystem"), "dbo");

            sp.Command.AddParameter("@BranchID", BranchID, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@Date", DateX, DbType.DateTime, null, null);

            return(sp);
        }
Esempio n. 29
0
 /// <summary>
 /// Creates an object wrapper for the RIS_Verificar_Si_Existe_Estudio_Investigador Procedure
 /// </summary>
 public static StoredProcedure RisVerificarSiExisteEstudioInvestigador(int? idEstudio, int? idInvestigador)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("RIS_Verificar_Si_Existe_Estudio_Investigador", DataService.GetInstance("sicProvider"), "dbo");
 	
     sp.Command.AddParameter("@idEstudio", idEstudio, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@idInvestigador", idInvestigador, DbType.Int32, 0, 10);
 	
     return sp;
 }
Esempio n. 30
0
        /// <summary>
        /// Creates an object wrapper for the Update_CurrencyCloud_MarketData Procedure
        /// </summary>
        public static StoredProcedure UpdateCurrencyCloudMarketData(decimal?price, int?marketkey)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Update_CurrencyCloud_MarketData", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@price", price, DbType.Decimal, 8, 18);

            sp.Command.AddParameter("@market_key", marketkey, DbType.Int32, 0, 10);

            return(sp);
        }
Esempio n. 31
0
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_AddRating Stored Procedure
        /// </summary>
        public static StoredProcedure StoreProductAddRating(int productID, int rating, string userName)
        {
            ;
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_AddRating");
            sp.Command.AddParameter("@productID", productID, DbType.Int32);
            sp.Command.AddParameter("@rating", rating, DbType.Int32);
            sp.Command.AddParameter("@userName", userName, DbType.String);

            return(sp);
        }
Esempio n. 32
0
        /// <summary>
        /// Creates an object wrapper for the sp_Subjects Procedure
        /// </summary>
        public static StoredProcedure SpSubjects(int?isActive, int?BranchID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_Subjects", DataService.GetInstance("SchoolManagementSystem"), "dbo");

            sp.Command.AddParameter("@isActive", isActive, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@BranchID", BranchID, DbType.Int32, 0, 10);

            return(sp);
        }
Esempio n. 33
0
        /// <summary>
        /// Creates an object wrapper for the SalesByCategory Procedure
        /// </summary>
        public static StoredProcedure SalesByCategory(string CategoryName, string OrdYear)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("SalesByCategory", DataService.GetInstance("Northwind"), "dbo");

            sp.Command.AddParameter("@CategoryName", CategoryName, DbType.String, null, null);

            sp.Command.AddParameter("@OrdYear", OrdYear, DbType.String, null, null);

            return(sp);
        }
Esempio n. 34
0
        /// <summary>
        /// Creates an object wrapper for the Sales by Year Procedure
        /// </summary>
        public static StoredProcedure SalesByYear(DateTime?BeginningDate, DateTime?EndingDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Sales by Year", DataService.GetInstance("Northwind"), "dbo");

            sp.Command.AddParameter("@Beginning_Date", BeginningDate, DbType.DateTime, null, null);

            sp.Command.AddParameter("@Ending_Date", EndingDate, DbType.DateTime, null, null);

            return(sp);
        }
Esempio n. 35
0
        /// <summary>
        /// Creates an object wrapper for the Peaches Procedure
        /// </summary>
        public static StoredProcedure Peaches(string tablename, string mapSuffix)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Peaches", DataService.GetInstance("Northwind"), "dbo");

            sp.Command.AddParameter("@tablename", tablename, DbType.String, null, null);

            sp.Command.AddParameter("@mapSuffix", mapSuffix, DbType.String, null, null);

            return(sp);
        }
Esempio n. 36
0
        /// <summary>
        /// Creates an object wrapper for the SlideShow_Image_MovePosition Procedure
        /// </summary>
        public static StoredProcedure SlideShowImageMovePosition(int?id, bool?direction)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("SlideShow_Image_MovePosition", DataService.GetInstance("WebModules"), "dbo");

            sp.Command.AddParameter("@id", id, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@direction", direction, DbType.Boolean, null, null);

            return(sp);
        }
Esempio n. 37
0
        /// <summary>
        /// Creates an object wrapper for the Update_CurrencyCloud_Tokens Procedure
        /// </summary>
        public static StoredProcedure UpdateCurrencyCloudTokens(int?cctokenkey, string cctoken)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Update_CurrencyCloud_Tokens", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@cctokenkey", cctokenkey, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@cctoken", cctoken, DbType.AnsiString, null, null);

            return(sp);
        }
Esempio n. 38
0
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Product_GetByPriceRange Stored Procedure
        /// </summary>
        public static StoredProcedure StoreProductGetByPriceRange(int categoryID, decimal priceStart, decimal priceEnd)
        {
            ;
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Product_GetByPriceRange");
            sp.Command.AddParameter("@categoryID", categoryID, DbType.Int32);
            sp.Command.AddParameter("@priceStart", priceStart, DbType.Currency);
            sp.Command.AddParameter("@priceEnd", priceEnd, DbType.Currency);

            return(sp);
        }
Esempio n. 39
0
        /// <summary>
        /// Creates an object wrapper for the Procedure Procedure
        /// </summary>
        public static StoredProcedure Procedure(int?param1, int?param2)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Procedure", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@param1", param1, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@param2", param2, DbType.Int32, 0, 10);

            return(sp);
        }
Esempio n. 40
0
        /// <summary>
        /// Creates an object wrapper for the Kick_AddAlertMessageForUser Procedure
        /// </summary>
        public static StoredProcedure Kick_AddAlertMessageForUser(int?userId, int?alertMessageId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Kick_AddAlertMessageForUser", DataService.GetInstance("DotNetKicks"));

            sp.Command.AddParameter("@userId", userId, DbType.Int32);

            sp.Command.AddParameter("@alertMessageId", alertMessageId, DbType.Int32);

            return(sp);
        }
Esempio n. 41
0
        /// <summary>
        /// Creates an object wrapper for the Kick_GetTagsByUserIDAndStoryID Procedure
        /// </summary>
        public static StoredProcedure Kick_GetTagsByUserIDAndStoryID(int?UserID, int?StoryID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Kick_GetTagsByUserIDAndStoryID", DataService.GetInstance("DotNetKicks"));

            sp.Command.AddParameter("@UserID", UserID, DbType.Int32);

            sp.Command.AddParameter("@StoryID", StoryID, DbType.Int32);

            return(sp);
        }
Esempio n. 42
0
        /// <summary>
        /// Creates an object wrapper for the CSK_Coupons_SaveCouponType Stored Procedure
        /// </summary>
        public static StoredProcedure CouponsSaveCouponType(int CouponTypeId, string Description, string ProcessingClassName)
        {
            ;
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Coupons_SaveCouponType");
            sp.Command.AddParameter("@CouponTypeId", CouponTypeId, DbType.Int32);
            sp.Command.AddParameter("@Description", Description, DbType.String);
            sp.Command.AddParameter("@ProcessingClassName", ProcessingClassName, DbType.String);

            return(sp);
        }
Esempio n. 43
0
        /// <summary>
        /// Creates an object wrapper for the Employee Sales by Country Procedure
        /// </summary>
        public static StoredProcedure EmployeeSalesByCountry(DateTime? BeginningDate, DateTime? EndingDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Employee Sales by Country", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[Beginning Date]", BeginningDate, DbType.Date, null, null);

            sp.Command.AddParameter("[Ending Date]", EndingDate, DbType.Date, null, null);

            return sp;
        }
Esempio n. 44
0
        /// <summary>
        /// Creates an object wrapper for the Kick_GetTopKickedStoriesByYear Procedure
        /// </summary>
        public static StoredProcedure Kick_GetTopKickedStoriesByYear(int?HostId, int?Year)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Kick_GetTopKickedStoriesByYear", DataService.GetInstance("DotNetKicks"));

            sp.Command.AddParameter("@HostId", HostId, DbType.Int32);

            sp.Command.AddParameter("@Year", Year, DbType.Int32);

            return(sp);
        }
Esempio n. 45
0
        /// <summary>
        /// Creates an object wrapper for the View_CurrencyCloud_Market_bySource_Destination Procedure
        /// </summary>
        public static StoredProcedure ViewCurrencyCloudMarketBySourceDestination(int?source, int?destination)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("View_CurrencyCloud_Market_bySource_Destination", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@source", source, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@destination", destination, DbType.Int32, 0, 10);

            return(sp);
        }
Esempio n. 46
0
        /// <summary>
        /// Creates an object wrapper for the ELMAH_GetErrorXml Procedure
        /// </summary>
        public static StoredProcedure Elmah_GetErrorXml(string Application, Guid?ErrorId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("ELMAH_GetErrorXml", DataService.GetInstance("DotNetKicks"));

            sp.Command.AddParameter("@Application", Application, DbType.String);

            sp.Command.AddParameter("@ErrorId", ErrorId, DbType.Guid);

            return(sp);
        }
Esempio n. 47
0
        /// <summary>
        /// Creates an object wrapper for the dashCommerce_Content_JoinRegionToPage Procedure
        /// </summary>
        public static StoredProcedure JoinRegionToPage(int? RegionId, int? PageId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("dashCommerce_Content_JoinRegionToPage" , DataService.GetInstance("dashCommerceProvider"));

            sp.Command.AddParameter("@RegionId", RegionId,DbType.Int32);

            sp.Command.AddParameter("@PageId", PageId,DbType.Int32);

            return sp;
        }
Esempio n. 48
0
        /// <summary>
        /// Creates an object wrapper for the Sales by Year Procedure
        /// </summary>
        public static StoredProcedure SalesByYear(DateTime?FormsSalesbyYearDialogBeginningDate, DateTime?FormsSalesbyYearDialogEndingDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Sales by Year", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[Forms]![Sales by Year Dialog]![BeginningDate]", FormsSalesbyYearDialogBeginningDate, DbType.Date, null, null);

            sp.Command.AddParameter("[Forms]![Sales by Year Dialog]![EndingDate]", FormsSalesbyYearDialogEndingDate, DbType.Date, null, null);

            return(sp);
        }
Esempio n. 49
0
 /// <summary>
 /// Creates an object wrapper for the RIS_Cargar_Lista_Entidades Procedure
 /// </summary>
 public static StoredProcedure RisCargarListaEntidades(int? idEstudio, string tipoEntidad)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("RIS_Cargar_Lista_Entidades", DataService.GetInstance("sicProvider"), "dbo");
 	
     sp.Command.AddParameter("@idEstudio", idEstudio, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@tipoEntidad", tipoEntidad, DbType.AnsiString, null, null);
 	
     return sp;
 }
Esempio n. 50
0
        /// <summary>
        /// Creates an object wrapper for the sp_HostelAssignTO Procedure
        /// </summary>
        public static StoredProcedure SpHostelAssignTO(bool?MemberType, int?BranchID)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("sp_HostelAssignTO", DataService.GetInstance("SchoolManagementSystem"), "dbo");

            sp.Command.AddParameter("@MemberType", MemberType, DbType.Boolean, null, null);

            sp.Command.AddParameter("@BranchID", BranchID, DbType.Int32, 0, 10);

            return(sp);
        }
Esempio n. 51
0
 /// <summary>
 /// Creates an object wrapper for the RIS_Obtener_Funcion_En_El_Equipo Procedure
 /// </summary>
 public static StoredProcedure RisObtenerFuncionEnElEquipo(int? idEstudio, int? idInvestigador)
 {
     SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("RIS_Obtener_Funcion_En_El_Equipo", DataService.GetInstance("sicProvider"), "dbo");
 	
     sp.Command.AddParameter("@idEstudio", idEstudio, DbType.Int32, 0, 10);
 	
     sp.Command.AddParameter("@idInvestigador", idInvestigador, DbType.Int32, 0, 10);
 	
     return sp;
 }
Esempio n. 52
0
        /// <summary>
        /// Creates an object wrapper for the Update_Exchange_Rates Procedure
        /// </summary>
        public static StoredProcedure UpdateExchangeRates(int?exchangeratekey, decimal?exchangerate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Update_Exchange_Rates", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@exchange_rate_key", exchangeratekey, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@exchange_rate", exchangerate, DbType.Currency, 4, 19);

            return(sp);
        }
Esempio n. 53
0
        /// <summary>
        /// Creates an object wrapper for the Employee Sales by Country Procedure
        /// </summary>
        public static StoredProcedure EmployeeSalesByCountry(DateTime?BeginningDate, DateTime?EndingDate)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Employee Sales by Country", DataService.GetInstance("NorthwindAccess"), "");

            sp.Command.AddParameter("[Beginning Date]", BeginningDate, DbType.Date, null, null);

            sp.Command.AddParameter("[Ending Date]", EndingDate, DbType.Date, null, null);

            return(sp);
        }
Esempio n. 54
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_CheckSchemaVersion Procedure
        /// </summary>
        public static StoredProcedure AspnetCheckSchemaVersion(string Feature, string CompatibleSchemaVersion)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_CheckSchemaVersion", DataService.GetInstance("SignificantTradeSS"), "dbo");

            sp.Command.AddParameter("@Feature", Feature, DbType.String, null, null);

            sp.Command.AddParameter("@CompatibleSchemaVersion", CompatibleSchemaVersion, DbType.String, null, null);

            return sp;
        }
Esempio n. 55
0
        /// <summary>
        /// Creates an object wrapper for the aspnet_Applications_CreateApplication Procedure
        /// </summary>
        public static StoredProcedure AspnetApplicationsCreateApplication(string ApplicationName, Guid? ApplicationId)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("aspnet_Applications_CreateApplication", DataService.GetInstance("SignificantTradeSS"), "dbo");

            sp.Command.AddParameter("@ApplicationName", ApplicationName, DbType.String, null, null);

            sp.Command.AddOutputParameter("@ApplicationId", DbType.Guid, null, null);

            return sp;
        }
Esempio n. 56
0
        /// <summary>
        /// Creates an object wrapper for the Dmuc_Laydanhsach_Bacsi Procedure
        /// </summary>
        public static StoredProcedure DmucLaydanhsachBacsi(int? DepartmentID, int? NoitruNgoaitru)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Dmuc_Laydanhsach_Bacsi", DataService.GetInstance("ORM"), "dbo");

            sp.Command.AddParameter("@DepartmentID", DepartmentID, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@NoitruNgoaitru", NoitruNgoaitru, DbType.Int32, 0, 10);

            return sp;
        }
Esempio n. 57
0
        /// <summary>
        /// Creates an object wrapper for the CSK_Tax_SaveZipRate Stored Procedure
        /// </summary>
        public static StoredProcedure TaxSaveZipRate(string state, string zipCode, decimal rate, string userName)
        {
            ;
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Tax_SaveZipRate");
            sp.Command.AddParameter("@state", state, DbType.String);
            sp.Command.AddParameter("@zipCode", zipCode, DbType.String);
            sp.Command.AddParameter("@rate", rate, DbType.Currency);
            sp.Command.AddParameter("@userName", userName, DbType.String);

            return(sp);
        }
Esempio n. 58
0
        /// <summary>
        /// Creates an object wrapper for the CSK_Store_Order_Query Stored Procedure
        /// </summary>
        public static StoredProcedure StoreOrderQuery(DateTime dateStart, DateTime dateEnd, string userName, string orderNumber)
        {
            ;
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("CSK_Store_Order_Query");
            sp.Command.AddParameter("@dateStart", dateStart, DbType.DateTime);
            sp.Command.AddParameter("@dateEnd", dateEnd, DbType.DateTime);
            sp.Command.AddParameter("@userName", userName, DbType.String);
            sp.Command.AddParameter("@orderNumber", orderNumber, DbType.String);

            return(sp);
        }
Esempio n. 59
0
        /// <summary>
        /// Creates an object wrapper for the Update_Currencies Procedure
        /// </summary>
        public static StoredProcedure UpdateCurrencies(int?currencykey, string currencyname, bool?isfiat)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Update_Currencies", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@currency_key", currencykey, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@currency_name", currencyname, DbType.AnsiString, null, null);

            sp.Command.AddParameter("@isfiat", isfiat, DbType.Boolean, null, null);

            return(sp);
        }
Esempio n. 60
0
        /// <summary>
        /// Creates an object wrapper for the Update_Path_Route Procedure
        /// </summary>
        public static StoredProcedure UpdatePathRoute(int?pathroutekey, int?pathkey, int?marketkey)
        {
            SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("Update_Path_Route", DataService.GetInstance("Bitcoin_Notify"), "dbo");

            sp.Command.AddParameter("@path_route_key", pathroutekey, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@path_key", pathkey, DbType.Int32, 0, 10);

            sp.Command.AddParameter("@market_key", marketkey, DbType.Int32, 0, 10);

            return(sp);
        }