internal SqlDataReader getUserDetails(QuatationDetailsBO boObject) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(boObject.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.Text); command.CommandText = "SELECT u.name,u.address,ur.userRole from [user] u INNER JOIN UserRole ur ON u.userRoleId = ur.userRoleId where userId =" + boObject.userId; return(sqlHelper.ExecuteReader(command)); }
internal SqlDataReader getShopDetails(QuatationDetailsBO boObject) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(boObject.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.Text); command.CommandText = "SELECT name,address from shop where shopid = " + boObject.shopId; return(sqlHelper.ExecuteReader(command)); }
internal SqlDataReader getNewCustomerDetails(QuatationDetailsBO boObject) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(boObject.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.Text); command.CommandText = "SELECT CustomerName, address from NewCustomer where TempMShopId like '" + boObject.TempShopId + "'"; return(sqlHelper.ExecuteReader(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); }