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