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