public List <BuyingValue> GetBuyingInfoFromDB(BuyingTicketValue buyingValue)
{
List <BuyingValue> buying = new List <BuyingValue>();
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["RW"].ConnectionString))
{
var sql = "exec [GetBuingValueForTicket] @StationFrom,@StationTo,@Surname,@Name,@Privilege,@SeatID,@Mail";
for (int i = 0; i < buyingValue.SeatID.Count; i++)
{
var values = new
{
StationFrom = buyingValue.StationFrom,
StationTo = buyingValue.StationTo,
Surname = buyingValue.SName[i],
Name = buyingValue.Name[i],
Privilege = buyingValue.Privilege[i],
SeatID = buyingValue.SeatID[i],
Mail = buyingValue.Mail[i]
};
buying.Add(connection.QueryFirst <BuyingValue>(sql, values));
}
}
return(buying);
}
public IBuyingValueList GetBuyingInfo(BuyingTicketValue buyingValue)
{
buying = Base.GetBuyingInfoFromDB(buyingValue);
BuyingValueList buingValueList = new BuyingValueList();
buingValueList = repository.InsertValueIntoClass(buyingValue, buying, buingValueList);
return(buingValueList);
}
