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; } }
/// <summary> /// /// </summary> /// <param name="VoucherDataList"></param> /// <param name="UserID"></param> /// <param name="ProcedurName"></param> /// <returns></returns> public static DataTable CancelVoucherRandom(CommonVoucerInfoCollection VoucherDataList, string UserID, string ProcedurName) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = ProcedurName; ParameterCollection.Add(new clsParameter("@UserID", UserID)); ParameterCollection.Add(new clsParameter("@tblVoucher", GetVoucherTable(VoucherDataList))); //DataAccess.ExecuteNonQuerySp(ParameterCollection); return DataAccess.ExecuteSpAndGetDataTable(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
public DataTable GetFilteredTranslationData(string UserName, int StartIndex, int EndIndex, string sort, string sortDir) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.sp_Translation_FilterByUserName; clsParaCollection.Add(new clsParameter("@UserName", UserName)); clsParaCollection.Add(new clsParameter("@StartIndex", StartIndex)); clsParaCollection.Add(new clsParameter("@EndIndex", EndIndex)); clsParaCollection.Add(new clsParameter("@sort", sort)); clsParaCollection.Add(new clsParameter("@sortdir", sortDir)); return DataAccess.ExecuteSpAndGetDataTable(clsParaCollection); } catch (Exception ex) { BL_Exception.WriteLog(ex); throw ex; } }
public static void ClearScannedData(string ModuleName, string UserId) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = "DeleteScannedValues"; ParameterCollection.Add(new clsParameter("@moduleName", ModuleName)); ParameterCollection.Add(new clsParameter("@UserId", UserId)); DataAccess.ExecuteNonQuerySp(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
public void CurrentCartItems_Insert(Cart C) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.VP_CurrentCartItems_Insert; clsParaCollection.Add(new clsParameter("@UserID", C.UserID)); clsParaCollection.Add(new clsParameter("@CartID", C.CartID)); clsParaCollection.Add(new clsParameter("@ProductID", C.ProductID)); clsParaCollection.Add(new clsParameter("@Quantity", C.Quantity)); clsParaCollection.Add(new clsParameter("@Price", C.Price)); DataAccess.ExecuteNonQuerySp(clsParaCollection); } catch (Exception ex) { BL_Exception.WriteLog(ex); throw ex; } }
public static void SaveVouchers(string UserID, string Date, string InvoiceNumber, int Amount) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = "BS_SalesChange3AddVoucher"; ParameterCollection.Add(new clsParameter("@UserID", UserID)); ParameterCollection.Add(new clsParameter("@ValidityDate", Date)); ParameterCollection.Add(new clsParameter("@InvoiceNumber", InvoiceNumber)); ParameterCollection.Add(new clsParameter("@Amount", Amount)); DataAccess.ExecuteNonQuerySp(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
public static DataTable ScanVouchersChange4(string UserID, string VoucherNo, string StoreCode, bool isEmployeeRedemption) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = "BS_RedemptionChange4ScanVoucher"; ParameterCollection.Add(new clsParameter("@UserID", UserID)); ParameterCollection.Add(new clsParameter("@VoucherNo", VoucherNo)); ParameterCollection.Add(new clsParameter("@StoreCode", StoreCode)); ParameterCollection.Add(new clsParameter("@isEmployeeRedemption", isEmployeeRedemption)); 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 cancel voucher. /// </summary> /// <param name="Info"></param> /// <param name="UserID"></param> public static void CancelVouchers(string VocuherNo, string UserID) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = "BS_Cancellation_Cancel"; ParameterCollection.Add(new clsParameter("@VoucherNo", VocuherNo)); ParameterCollection.Add(new clsParameter("@cancelledBy", UserID)); DataAccess.ExecuteNonQuerySp(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
/// <summary> /// /// </summary> /// <param name="FirstID"></param> /// <param name="LastId"></param> /// <param name="UserId"></param> /// <param name="ProcedurName"></param> public static void CancelVoucherSeries(string FirstID, string LastId, string UserId, string ProcedurName) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = ProcedurName; ParameterCollection.Add(new clsParameter("@VocStart", FirstID)); ParameterCollection.Add(new clsParameter("@VocEnd", LastId)); ParameterCollection.Add(new clsParameter("@UserID", UserId)); DataAccess.ExecuteNonQuerySp(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
/// <summary> /// This method is used to add Vendor Discount. /// </summary> /// <param name="Store"></param> public static void AddUpdateVendorDiscount(VendorDiscountInfo VDiscount) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = "GV_InsertVendorDiscount"; ParameterCollection.Add(new clsParameter("@VendorId", VDiscount.VendorId)); ParameterCollection.Add(new clsParameter("@Amount", VDiscount.Amount)); ParameterCollection.Add(new clsParameter("@CreatedBy", VDiscount.CreatedBy)); DataAccess.ExecuteNonQuerySp(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
public List<Cart> CurrentCartItems_Get(int UserID, int CartID) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.VP_CurrentCartItems_Get; clsParaCollection.Add(new clsParameter("@UserID", UserID)); clsParaCollection.Add(new clsParameter("@CartID", CartID)); dt = DataAccess.ExecuteSpAndGetDataTable(clsParaCollection); ListCart.Clear(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { ListCart.Add(new Cart { SRNO = Convert.ToInt32(dr[0]), CartID = Convert.ToInt32(dr[2]), UserID = Convert.ToInt32(dr[3]), ProductID = Convert.ToInt32(dr[4]), ProductTitle = Convert.ToString(dr[5]), Quantity = Convert.ToInt32(dr[6]), Price = Convert.ToInt32(dr[7]), ItemPrice = Convert.ToInt32(dr[8]), TotalAmt = Convert.ToInt32(dr[9]), UpdatedDate = Convert.ToString(dr[10]) }); } } return ListCart; } catch (Exception ex) { BL_Exception.WriteLog(ex); throw ex; } }
/// <summary> /// This method is used to perform operations on vocuhers (Redeemption/Cancelation) /// </summary> /// <param name="Info"></param> /// <param name="UserID"></param> public static DataTable VoucherOperation(CommonVoucerInfoCollection VoucherDataList, string UserID, string ProcedurName, string RequestorName, string RequestorEmail, string RequestorPhone) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = ProcedurName; 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("@tblVoucher", GetVoucherTable(VoucherDataList))); //DataAccess.ExecuteNonQuerySp(ParameterCollection); 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 Redeem voucher. /// </summary> /// <param name="Info"></param> /// <param name="UserID"></param> public static void RedeemVouchers(RedemptionInfoCollection RedemData, string UserID) { try { clsParameterCollection ParameterCollection = new clsParameterCollection(); ParameterCollection.ProcedureName = "BS_Redemption_Redeem"; ParameterCollection.Add(new clsParameter("@RedeempedBy", UserID)); ParameterCollection.Add(new clsParameter("@VoucherNo", GetVoucherTable(RedemData))); //ParameterCollection.Add(new clsParameter("@VoucherNo", VocuherNo)); //ParameterCollection.Add(new clsParameter("@RedeempedBy", UserID)); //DataAccess.ExecuteNonQuerySp(ParameterCollection); } catch (Exception Ex) { if (!Ex.Message.Contains("User Define:")) BL_Exception.WriteLog(Ex); throw Ex; } }
public DataTable GetProofReadingUserData(string UserID) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.sp_RetrieveProofReadingUserData; clsParaCollection.Add(new clsParameter("@UserID", UserID)); return DataAccess.ExecuteSpAndGetDataTable(clsParaCollection); } catch (Exception Ex) { throw Ex; } }
public void BookAuthorInsert(DataTable dt) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.ProcedureName = Constants.VP_athor_book_Insert; clsParaCollection.Add(new clsParameter("@author_book", dt)); DataAccess.ExecuteNonQuerySp(clsParaCollection); } catch (Exception ex) { BL_Exception.WriteLog(ex); throw ex; } }
///// <summary> ///// This is Used to calculate Estimated Amount based on input(Number of words) ///// </summary> ///// <param name="wCount"></param> ///// <returns></returns> //public string CalculateEstimateAmt(int wCount) //{ // try // { // clsParameterCollection clsParaCollection = new clsParameterCollection(); // clsParaCollection.ProcedureName = Constants.sp_CalculateEstimateAmt; // clsParaCollection.Add(new clsParameter("@Wcont", wCount)); // dt.Reset(); // dt = DataAccess.ExecuteSpAndGetDataTable(clsParaCollection); // return dt.Rows[0][0].ToString(); // } // catch (Exception ex) // { // BL_Exception.WriteLog(ex); // throw ex; // } //} /// <summary> /// This Method is used to Cancel service request (set status=Canceled on respective trnid) /// </summary> /// <param name="trnID"></param> public void Cancellation(int trnID) { try { clsParameterCollection clsParaCollection = new clsParameterCollection(); clsParaCollection.Add(new clsParameter("@TrnID", trnID)); clsParaCollection.ProcedureName = Constants.sp_CoverDesign_CancelRequest; DataAccess.ExecuteNonQuerySp(clsParaCollection); } catch (Exception ex) { BL_Exception.WriteLog(ex); throw ex; } }