internal int UpdateDoctorDetails(ShopBO shopBo)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(shopBo.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "UpdateDoctorDetailsAndroid"; //"uspWSUpdateCollectionDetails";
sqlHelper.AddParameter(command, "@Name", shopBo.Name, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Address", shopBo.address, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@MobileNo", shopBo.mobileNo, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@Email", shopBo.email, ParameterDirection.Input);
try
{
Convert.ToDateTime(shopBo.dob);
sqlHelper.AddParameter(command, "@DOB", shopBo.dob, ParameterDirection.Input);
}
catch
{
}
try
{
Convert.ToDateTime(shopBo.dob);
sqlHelper.AddParameter(command, "@WeddingDate", shopBo.weddingDate, ParameterDirection.Input);
}
catch
{
}
sqlHelper.AddParameter(command, "@Qualifications", shopBo.qualifications, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(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));
}
internal int GetShopCount(ShopBO shopBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(shopBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspWSGetShopCount";
sqlHelper.AddParameter(command, "@UserId", shopBO.UserId, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteScalar(command)));
}
internal int UpdateShopDefaultDistributor(ShopBO shopBo)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(shopBo.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspShop";
sqlHelper.AddParameter(command, "@Mode", "21", ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ShopIds", shopBo.ShopIds, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@DistributorIds", shopBo.DistributorIds, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@userId", shopBo.UserId, ParameterDirection.Input);
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
}
internal ShopBO.ShopData GetRouteOutlets(ShopBO shopBo)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(shopBo.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "uspGetRouteOutlets";
sqlHelper.AddParameter(command, "@BeatPlanId", shopBo.BeatPlanId, ParameterDirection.Input);
SqlDataReader reader = sqlHelper.ExecuteReader(command);
ShopBO.ShopData shopData = new ShopBO.ShopData();
shopData.ShopList = new List <ShopBO.Shop>();
while (reader.Read())
{
ShopBO.Shop shop = new ShopBO.Shop();
shop.ShopId = Convert.ToInt32(reader["ShopId"]);
shop.Name = Convert.ToString(reader["Name"]);
shopData.ShopList.Add(shop);
}
reader.Close();
return(shopData);
}
