public EditCustomerBO GetPendingApprovalsToReportingUser(EditCustomerBO editCustomerBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(editCustomerBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "[uspCustomerEditApproval]"; sqlHelper.AddParameter(command, "@Mode", editCustomerBO.Mode, ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", editCustomerBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ShopId", editCustomerBO.ShopId, ParameterDirection.Input); DataSet ds = sqlHelper.ExecuteDataSet(command); DataRow row = ds.Tables[0].Rows[0]; decimal temp = 0.0M; editCustomerBO.ShopName = (row.Field <string>("ShopName") == null ? "" : row.Field <string>("ShopName")); editCustomerBO.ReportingUser = (row.Field <string>("ReportingUser") == null ? "" : row.Field <string>("ReportingUser")); editCustomerBO.RequestedUser = (row.Field <string>("RequestedUser") == null ? "" : row.Field <string>("RequestedUser")); editCustomerBO.UserEmail = (row.Field <string>("ToUserEmail") == null ? "" : row.Field <string>("ToUserEmail")); editCustomerBO.ContactName = (row.Field <string>("ContactPerson") == null ? "" : Convert.ToString(row.Field <string>("ContactPerson"))); editCustomerBO.MobileNo = (row.Field <string>("MobileNo") == null ? "" : Convert.ToString(row.Field <string>("MobileNo"))); editCustomerBO.PinCode = (row.Field <string>("PINCode") == null ? "" : Convert.ToString(row.Field <string>("PINCode"))); editCustomerBO.Address = (row.Field <string>("Address") == null ? "" : Convert.ToString(row.Field <string>("Address"))); editCustomerBO.StreetName = (row.Field <string>("StreetName") == null ? "" : Convert.ToString(row.Field <string>("StreetName"))); editCustomerBO.ShopPotential = (row.Field <decimal?>("ShopPotential") == null ? temp : Convert.ToDecimal(row.Field <decimal>("ShopPotential"))); editCustomerBO.GstNumber = (row.Field <string>("GSTIN") == null ? "" : Convert.ToString(row.Field <string>("GSTIN"))); editCustomerBO.EditedContactName = (row.Field <string>("ContactName") == null ? "" : Convert.ToString(row.Field <string>("ContactName"))); editCustomerBO.EditedMobile = (row.Field <string>("EditedMobile") == null ? "" : Convert.ToString(row.Field <string>("EditedMobile"))); editCustomerBO.EditedPinCode = (row.Field <string>("EditedPinCode") == null ? "" : Convert.ToString(row.Field <string>("EditedPinCode"))); editCustomerBO.EditedAddress = (row.Field <string>("EditedAddress") == null ? "" : Convert.ToString(row.Field <string>("EditedAddress"))); editCustomerBO.Landmark = (row.Field <string>("Landmark") == null ? "" : Convert.ToString(row.Field <string>("Landmark"))); editCustomerBO.IsEditCustomerMailReq = (row.Field <bool?>("IsEditCustomerMailReq") == null ? false : Convert.ToBoolean(row.Field <bool>("IsEditCustomerMailReq"))); editCustomerBO.EditedShopPotential = (row.Field <decimal?>("EditedShopPotential") == null ? temp : Convert.ToDecimal(row.Field <decimal>("EditedShopPotential"))); editCustomerBO.EditedGstNumber = (row.Field <string>("EditedGstNumber") == null ? "" : Convert.ToString(row.Field <string>("EditedGstNumber"))); return(editCustomerBO); }
internal DataSet GetImagePath(PhotoCaptureBO photoCaptureBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(photoCaptureBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "getImagePath"; return(sqlHelper.ExecuteDataSet(command)); }
//public DataSet GetPromotionalActivities(PromotionalActivitiesBO prmBO) //{ // DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(prmBO.ConString); // SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); // command.CommandText = "getPromoDetails"; // return sqlHelper.ExecuteDataSet(command); //} public DataSet getProm(PromotionalActivitiesBO prmbo1) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(prmbo1.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "getPromoDetails"; return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetModifiedDate(ApplicationSettingsBO objApplicationSettingsBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(objApplicationSettingsBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspGetModifiedDate"; return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetDeviceId(DeviceTokenBO deviceBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(deviceBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "ReadFromDeviceToken"; sqlHelper.AddParameter(command, "@userId", deviceBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetReceiptNoDetails(ReceiptNoBO receiptNoBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(receiptNoBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GetReceiptNo"; sqlHelper.AddParameter(command, "@UserId", receiptNoBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetQueryResultForChild(DynamicReportBO reportBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(reportBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "mdr_getDynamicChildRprt"; sqlHelper.AddParameter(command, "@Param", reportBO.paramValue, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet getCustomerShop(ShopBO shopBo) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(shopBo.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspWSGetTopThreeShopNames"; sqlHelper.AddParameter(command, "@UserId", shopBo.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetAssignedBeats(EditPlanBO editPlanBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(editPlanBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GetAssignedBeats"; sqlHelper.AddParameter(command, "@UserId", editPlanBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetBuildNo(VersionLogBO versionLogBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(versionLogBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GETVersionNO"; sqlHelper.AddParameter(command, "@Mode", "4", ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetApplicationSettings(ApplicationSettingsBO objApplicationSettingsBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(objApplicationSettingsBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GetApplicationSettings"; sqlHelper.AddParameter(command, "@Mode", objApplicationSettingsBO.Mode, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetShopLocation(ShopLocationBO shopLocationBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(shopLocationBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "mdr_getShopLocationsForAndroid"; sqlHelper.AddParameter(command, "@UserId", shopLocationBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetReturnedQty(ProductTransactionBO productTransactionBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(productTransactionBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); sqlHelper.AddParameter(command, "@UserId", productTransactionBO.UserId, ParameterDirection.Input); command.CommandText = "getReturnedQtyForAndroid"; return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet getEmailSettings(EmailBO emailBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(emailBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspEmailSettings"; sqlHelper.AddParameter(command, "@Mode", 5, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetOrderDetails(RecentOrderBO recentOrderBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(recentOrderBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "GetOrdersDetailsToConfirmAndroid"; sqlHelper.AddParameter(command, "@OrderId", recentOrderBO.OrderId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetJourneyCycle(JourneyCycleBO journeyCycleBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(journeyCycleBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "GetDateRangePharmaAndroid"; sqlHelper.AddParameter(command, "@UserId", journeyCycleBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet getShopPaymentParam(PaymentBO paymentBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(paymentBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "getCustomerPaymentParam"; sqlHelper.AddParameter(command, "@ShopId", paymentBO.ShopId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetVanUnloadDetails(StockReconcilationBO stockReconcilationBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(stockReconcilationBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "GetVanUnloadDetailsAndroid"; sqlHelper.AddParameter(command, "@StoreId", stockReconcilationBO.StoreId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetLicenceOfUser(DBCredentialBO dBCredentialBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(dBCredentialBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspGetLicenceOfUser"; sqlHelper.AddParameter(command, "@UserId", dBCredentialBO.User, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetWorkWithMasters(WorkWithBO workWithBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(workWithBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspMobileWorkingWith"; sqlHelper.AddParameter(command, "@UserId", workWithBO.userId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Mode", 1, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetOrderDispatchDetails(OrderBO orderBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(orderBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspOrderDispatchDetails"; sqlHelper.AddParameter(command, "@Mode", orderBO.Mode, ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", orderBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetSKUDriveAchieved(IncentiveDashboardBO incentiveDashboardBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(incentiveDashboardBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspIncentiveDashBoardReport"; sqlHelper.AddParameter(command, "@userId", incentiveDashboardBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@mode", incentiveDashboardBO.Mode, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetPriceRange(PriceRangeBO priceRangeBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(priceRangeBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.Text); command.CommandText = "select RateChangeLowerLimit,RateChangeUpperLimit,FirstDiscountLimit,SecondDiscountLimit from ParameterSettings"; //return Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet RequireMailForPjp(PjpBO pjpBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(pjpBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspUpdatePjp"; sqlHelper.AddParameter(command, "@Mode", "3", ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", pjpBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetSMSDetails(NewCustomerBO newCustomerBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(newCustomerBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "GetMailId"; sqlHelper.AddParameter(command, "@DistributorId", newCustomerBO.ShopId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Mode", newCustomerBO.Mode, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetCollectionDetails(CollectionBO collectionBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(collectionBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "getInvoiceorCollectionDetails"; sqlHelper.AddParameter(command, "@Mode", collectionBO.Mode, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ReceiptNo", collectionBO.ReceiptNo, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet getBills(FieldMax.MobileSyncService.Data.BO.DeliveryBO deliveryBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(deliveryBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "GetShipmentBillNo"; sqlHelper.AddParameter(command, "@ShopId", deliveryBO.shopId, System.Data.ParameterDirection.Input); // return sqlHelper.ExecuteDataSet(command); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetCustomerForBeat(EditPlanBO editPlanBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(editPlanBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GetCustomerForBeat"; sqlHelper.AddParameter(command, "@BeatPalnId", editPlanBO.BeatPlanId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@date", editPlanBO.DateSet, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetUserParameters(ParameterSettingsBO parameterSettingsBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(parameterSettingsBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "GetInstanceDetails"; sqlHelper.AddParameter(command, "@UserId", parameterSettingsBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Date", parameterSettingsBO.date, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
internal DataSet GetEditableFlag(ApplicationSettingsBO objApplicationSettingsBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(objApplicationSettingsBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_WSUserConfiguration"; sqlHelper.AddParameter(command, "@Mode", objApplicationSettingsBO.Mode, ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", objApplicationSettingsBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Date", objApplicationSettingsBO.Date, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }