C# clsParameterCollection.Add方法代码示例

        public int CheckPkgCountBeforeInsert(int PackageID, int UserID)
        {
            try
            {
                clsParameterCollection clsParaCollection = new clsParameterCollection();
                clsParaCollection.ProcedureName = Constants.VP_UserPackage_CheckPkgCountBeforeInsert;
                clsParaCollection.Add(new clsParameter { ParameterName = "@UserID", ParameterValue = UserID });
                clsParaCollection.Add(new clsParameter { ParameterName = "@PackageID", ParameterValue = PackageID });
                dt = DataAccess.ExecuteSpAndGetDataTable(clsParaCollection);
                if (dt.Rows.Count > 0)
                {
                    return Convert.ToInt32(dt.Rows[0][0]);
                }
                else
                {
                    return 0;
                }

            }

            catch (Exception ex)
            {
                BL_Exception.WriteLog(ex);
                throw ex;
            }
        }

        /// <summary>
        /// This method is used to save voucher (Default).
        /// </summary>
        /// <param name="voucherInfo"></param>
        /// <param name="userId"></param>
        public static void SaveVoucherDefault(VoucherInfo voucherInfo, string userId)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_Voucher_CreateVoucher";
                ParameterCollection.Add(new clsParameter("@vouchertypeID", voucherInfo.vouchertypeId));
                ParameterCollection.Add(new clsParameter("@denomination", voucherInfo.voucherDenomination));
                ParameterCollection.Add(new clsParameter("@quantity", voucherInfo.quantity));
                ParameterCollection.Add(new clsParameter("@amountvalue", voucherInfo.priceAmount));
                ParameterCollection.Add(new clsParameter("@userid", userId));
                ParameterCollection.Add(new clsParameter("@voucherValidateDate", voucherInfo.VoucherValidity));
                ParameterCollection.Add(new clsParameter("@isThirdparty", voucherInfo.isThirdparty));
                ParameterCollection.Add(new clsParameter("@salesValidateDate", voucherInfo.SalesValidity));
                ParameterCollection.Add(new clsParameter("@showDenomination", voucherInfo.showDenomination));
                ParameterCollection.Add(new clsParameter("@redeemStore", voucherInfo.RedeemStores));


                DataAccess.ExecuteNonQuerySp(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

 /// <summary>
 /// This Method is used to Check that partucular role has permisions assigned or not (Validation on ManagePermissions View on Assign button and Remove nutton click)
 /// </summary>
 /// <param name="RoleName"></param>
 /// <param name="ViewName"></param>
 /// <returns></returns>
 public DataTable checkPermissionForRole(string RoleName,string ViewName)
 {
     try
     {
         clsParameterCollection clsParaCollection = new clsParameterCollection();
         clsParaCollection.ProcedureName = Constants.sp_checkPermissionForRole;
         clsParaCollection.Add(new clsParameter { ParameterName="@RoleName",ParameterValue=RoleName});
         clsParaCollection.Add(new clsParameter { ParameterName="@ViewName",ParameterValue=ViewName});
         dt = DataAccess.ExecuteSpAndGetDataTable(clsParaCollection);
         return dt;
     }
     catch (Exception ex)
     {
         BL_Exception.WriteLog(ex);
         throw ex;
     }
 }

        public static void SaleVoucherSeries(string FirstID, string LastId, string RequestorName, string RequestorEmail, string RequestorPhone, string Amount, string UserId)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_SalesNew_SaleSeries";
                ParameterCollection.Add(new clsParameter("@VocStart", FirstID));
                ParameterCollection.Add(new clsParameter("@VocEnd", LastId));
                ParameterCollection.Add(new clsParameter("@UserID", UserId));
                ParameterCollection.Add(new clsParameter("@name", RequestorName));
                ParameterCollection.Add(new clsParameter("@EmailId", RequestorEmail));
                ParameterCollection.Add(new clsParameter("@phoneNumber", RequestorPhone));
                ParameterCollection.Add(new clsParameter("@TotalSalesAmout", Amount));


                DataAccess.ExecuteNonQuerySp(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        /// <summary>
        /// This method is used to get voucherDenomination.
        /// </summary>
        /// <returns></returns>
        public static DataTable GetVouhcerDenomination(int voucherType, int isBooklet)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_StoreAllocation_FillDenomination";
                ParameterCollection.Add(new clsParameter("@VoucherType", voucherType));
                ParameterCollection.Add(new clsParameter("@IsBooklet", isBooklet));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        public static DataTable BL_GetVoucherBookletNumbers(string Vnumber,string TransactionID)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_ValidityReset_GetVoucherBookletNumbers";
                ParameterCollection.Add(new clsParameter("@Vnumber", Vnumber));
                ParameterCollection.Add(new clsParameter("@TransactionID",TransactionID));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        public static DataTable ScanVouchers(string UserID, string VoucherNo)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_AllocateToEmployeeScanVoucher";
                ParameterCollection.Add(new clsParameter("@UserID", UserID));
                ParameterCollection.Add(new clsParameter("@VoucherNo", VoucherNo));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        public void insert_TemplatesData(TemplatesMaster tr)
        {
            try
            {
                clsParameterCollection clsParaCollection = new clsParameterCollection();
                clsParaCollection.ProcedureName = Constants.sp_insertTemplates;
                clsParaCollection.Add(new clsParameter { ParameterName = "@temp_Name", ParameterValue = tr.TemplateName });
                clsParaCollection.Add(new clsParameter { ParameterName = "@is_Avail", ParameterValue = tr.IsAvailable });
                clsParaCollection.Add(new clsParameter { ParameterName = "@Uploaded_By", ParameterValue = tr.UploadedBy });

                DataAccess.ExecuteNonQuerySp(clsParaCollection);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// This method is used to get user role details.
        /// </summary>
        /// <param name="ApplicationName"></param>
        /// <param name="UserName"></param>
        /// <returns></returns>
        public static DataTable GetUserRole(string ApplicationName, string UserName)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_PermissionManagement_GetUserRole";
                ParameterCollection.Add(new clsParameter("@ApplicationName", ApplicationName));
                ParameterCollection.Add(new clsParameter("@UserName", UserName));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        /// <summary>
        /// This method is used to update user profile details.
        /// </summary>
        /// <param name="objUserInfo"></param>
        /// <returns></returns>
        public static DataTable UpdateUserProfile(UserManagementInfo objUserInfo)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_UpdateUserProfile";
                ParameterCollection.Add(new clsParameter("@PropertyValuesString", objUserInfo.PropertyValuesString));
                ParameterCollection.Add(new clsParameter("@UserName", objUserInfo.UserName));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        public static DataTable GetVoucherDetails(string VID, string userID)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_SalesNew2_GetVoucherDetails";
                ParameterCollection.Add(new clsParameter("@VoucherNo", VID));
                ParameterCollection.Add(new clsParameter("@UserID", userID));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

 public static DataTable AddFeedBack(Feedback fb)
 {
     try
     {
         clsParameterCollection ParameterCollection = new clsParameterCollection();
         ParameterCollection.ProcedureName = "VOC.BS_FeedBack_AddFeedback";
         ParameterCollection.Add(new clsParameter("@Name", fb.FullName));
         ParameterCollection.Add(new clsParameter("@MobileNumber", fb.MobileNumber));
         ParameterCollection.Add(new clsParameter("@Email", fb.Email));
         return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
     }
     catch (Exception Ex)
     {
         if (!Ex.Message.Contains("User Define:"))
             BL_Exception.WriteLog(Ex);
         throw Ex;
     }
 }

        public static void BL_UpdateTransactionNosValidityDate(DataTable dt,DateTime date)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_ValidityReset_UpdateValidityDate";
                ParameterCollection.Add(new clsParameter("@ValidityDate", date));
                ParameterCollection.Add(new clsParameter("@VoucherNo", dt));
                DataAccess.ExecuteNonQuerySp(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        public static void AddState(StateCityInfo info)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_AddState";
                ParameterCollection.Add(new clsParameter("@StateName", info.StateName));
                ParameterCollection.Add(new clsParameter("@StateId", info.StateId));

                DataAccess.ExecuteNonQuerySp(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }

        /// <summary>
        /// This method is used to get vouchers list Inwarded at store.
        /// </summary>
        /// <returns></returns>
        public static DataTable GetInwardDetails(string UserID, string StoreCode, string VoucherNo)
        {
            try
            {
                clsParameterCollection ParameterCollection = new clsParameterCollection();
                ParameterCollection.ProcedureName = "BS_InwardAtStore_ShowVouchers";
                ParameterCollection.ParaCollection.Add(new clsParameter("@UserID", UserID));
                ParameterCollection.Add(new clsParameter("@ToStore", StoreCode));
                ParameterCollection.Add(new clsParameter("@voucherNo", VoucherNo));
                return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection);
            }
            catch (Exception Ex)
            {
                if (!Ex.Message.Contains("User Define:"))
                    BL_Exception.WriteLog(Ex);

                throw Ex;
            }
        }