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