public List <VietlottVNDto> GetListByAmount()
{
var lst = new List <VietlottVNDto>();
PostgresBOL.Open();
lst = PostgresBOL.GetTop10();
if (lst.Count > 0)
{
return(lst.Select(obj => new VietlottVNDto()
{
DrawId = obj.DrawId,
DayPrize = obj.DayPrize,
FullBlockNumber = obj.FullBlockNumber,
ImportDate = obj.ImportDate,
NumberOne = obj.NumberOne,
NumberTwo = obj.NumberTwo,
NumberThree = obj.NumberThree,
NumberFour = obj.NumberFour,
NumberFive = obj.NumberFive,
NumberSix = obj.NumberSix
}).ToList());
}
PostgresBOL.Close();
return(new List <VietlottVNDto>());
}
public int TotalRows()
{
int totalRows = 0;
PostgresBOL.Open();
totalRows = PostgresBOL.TotalRows();
PostgresBOL.Close();
return(totalRows);
}
public void ImportVietLottPage(List <PGVietLottVN> lst)
{
List <PGVietLottVN> lstPgVietLottVns = new List <PGVietLottVN>();
if (lst != null && lst.Count > 0)
{
foreach (var dto in lst)
{
try
{
var datePize = dto.DatePizeString.Trim();
DateTime dt = DateTime.ParseExact(datePize, "dd/MM/yyyy", CultureInfo.InvariantCulture);
List <int> listNumberInt = new List <int>();
if (dto.ListNumbers != null && dto.ListNumbers.Count > 0)
{
foreach (var number in dto.ListNumbers)
{
int iNumber = 0;
int.TryParse(number, out iNumber);
if (iNumber > 0)
{
listNumberInt.Add(iNumber);
}
}
}
listNumberInt = listNumberInt.OrderBy(o => o).ToList();
if (dto.ListNumbers != null && listNumberInt.Count == 6)
{
var obj = new PGVietLottVN()
{
DayPrize = dt,
Drawid = 0,
FullBlockNumber = String.Join(" ", dto.ListNumbers),
NumberOne = listNumberInt[0],
NumberTwo = listNumberInt[1],
NumberThree = listNumberInt[2],
NumberFour = listNumberInt[3],
NumberFive = listNumberInt[4],
NumberSix = listNumberInt[5]
};
lstPgVietLottVns.Add(obj);
}
}
catch (Exception exception)
{
;
}
}
}
PostgresBOL.Open();
foreach (var pgVietLottVn in lstPgVietLottVns)
{
PostgresBOL.InsertVietLottVN(pgVietLottVn);
}
PostgresBOL.Close();
}
public int[] GetFrequencyNumbers()
{
PostgresBOL.Open();
int[] arr = new int[45];
for (int i = 0; i < 45; i++)
{
var objNumber = PostgresBOL.CalculateNumber(i + 1);
arr[i] = objNumber;
}
PostgresBOL.Close();
return(arr);
}
public void DemoInertVietLott()
{
PostgresBOL.Open();
var obj = new PGVietLottVN()
{
DayPrize = DateTime.UtcNow,
Drawid = 0,
FullBlockNumber = "28 31 34 37 38 41",
NumberOne = 11,
NumberTwo = 12,
NumberThree = 13,
NumberFour = 14,
NumberFive = 15,
NumberSix = 16
};
PostgresBOL.InsertVietLottVN(obj);
PostgresBOL.Close();
}