public IHttpActionResult Add_Lottezy(int lottezyId, [FromBody] ViewModelPrize viewModelPrize)
{
try
{
// MaiPH
// check login
String token = Request.Headers.Authorization.Scheme;
tokenService.verifyToken(token);
//
using (var db = new XSKTDBDataContext())
{
db.DeferredLoadingEnabled = false;
DateTime date = new DateTime(year: DateTime.Now.Year, month: DateTime.Now.Month, day: DateTime.Now.Day, hour: 0, minute: 00, second: 0);
PrizeDetail prizeDetail = db.PrizeDetails.Where(x => x.LoctionPrizeId == lottezyId).Where(x => x.DatePrize == date).FirstOrDefault();
if (prizeDetail == null)
{
Prize prize = new Prize
{
FirstPrize = ConvertListToString(viewModelPrize.FirstPrize),
SecondPrize = ConvertListToString(viewModelPrize.SecondPrize),
ThirdPrize = ConvertListToString(viewModelPrize.ThirdPrize),
FourthPrize = ConvertListToString(viewModelPrize.FourthPrize),
FifthPrize = ConvertListToString(viewModelPrize.FifthPrize),
SixthPrize = ConvertListToString(viewModelPrize.SixthPrize),
SeventhPrize = ConvertListToString(viewModelPrize.SeventhPrize),
SpecialPrize = ConvertListToString(viewModelPrize.SpecialPrize)
};
db.Prizes.InsertOnSubmit(prize);
db.SubmitChanges();
PrizeDetail detail = new PrizeDetail
{
LoctionPrizeId = lottezyId,
PrizeId = prize.ID,
DatePrize = date
};
db.PrizeDetails.InsertOnSubmit(detail);
db.SubmitChanges();
return(Ok(new Response
{
code = 0
}));
}
}
}
catch
{
return(Ok(new Response
{
code = 1
}));
}
return(Ok(new Response
{
code = 1
}));
}
public IHttpActionResult GetLottezyByDate(int lottezyId)
{
Prize kq = null;
ViewModelPrize viewModelPrize = null;
using (var db = new XSKTDBDataContext())
{
PrizeDetail detail = null;
db.DeferredLoadingEnabled = false;
try
{
var DS = db.PrizeDetails.Where(x => x.LoctionPrizeId == lottezyId).ToList();
//lay ra ngay gan nhat
detail = DS.OrderByDescending(x => x.DatePrize).ToList().FirstOrDefault();
//lay ra giai ung voi ngay do
if (detail != null)
{
kq = db.Prizes.SingleOrDefault(x => x.ID == detail.PrizeId);
if (kq != null)
{
viewModelPrize = new ViewModelPrize(kq);
viewModelPrize.date = string.Format("{0}-{1}-{2}", detail.DatePrize.Value.Year, detail.DatePrize.Value.Month, detail.DatePrize.Value.Day);
viewModelPrize.LottezyId = detail.LoctionPrizeId.ToString();
viewModelPrize.LottezyName = db.LocationPrizes.SingleOrDefault(x => x.ID == detail.LoctionPrizeId).Name;
}
}
}
catch
{
Response res = new Response();
res.code = 1;
return(Ok(res));
}
if (kq == null)
{
return(Ok(new Response
{
code = 1
}));
}
else
{
return(Ok(new Response
{
code = 0,
data = viewModelPrize
}
));
}
}
}
public IHttpActionResult Update_Lottezy(int lottezyId, [FromBody] ViewModelPrize viewModelPrize)
{
try
{
// MaiPH
// check login
String token = Request.Headers.Authorization.Scheme;
tokenService.verifyToken(token);
using (var db = new XSKTDBDataContext())
{
db.DeferredLoadingEnabled = false;
PrizeDetail prizeDetail = db.PrizeDetails.Where(x => x.LoctionPrizeId == lottezyId).Where(x => x.DatePrize == tachNgay(viewModelPrize.date)).FirstOrDefault();
if (prizeDetail != null)
{
Prize prize = db.Prizes.Single(x => x.ID == prizeDetail.PrizeId);
prize.FirstPrize = ConvertListToString(viewModelPrize.FirstPrize);
prize.SecondPrize = ConvertListToString(viewModelPrize.SecondPrize);
prize.ThirdPrize = ConvertListToString(viewModelPrize.ThirdPrize);
prize.FourthPrize = ConvertListToString(viewModelPrize.FourthPrize);
prize.FifthPrize = ConvertListToString(viewModelPrize.FirstPrize);
prize.SixthPrize = ConvertListToString(viewModelPrize.FirstPrize);
prize.SeventhPrize = ConvertListToString(viewModelPrize.FirstPrize);
prize.SpecialPrize = ConvertListToString(viewModelPrize.FirstPrize);
db.SubmitChanges();
return(Ok(new Response
{
code = 0
}));
}
}
}
catch
{
return(Ok(new Response
{
code = 1
}));
}
return(Ok(new Response
{
code = 1
}));
}
public IHttpActionResult GetLottezyByDate(int lottezyId, [FromUri] string date)
{
Prize kq = null;
ViewModelPrize viewModelPrize = null;
using (var db = new XSKTDBDataContext())
{
PrizeDetail detail = null;
db.DeferredLoadingEnabled = false;
try
{
if (string.IsNullOrEmpty(date))
{
//var DS = db.PrizeDetails.Where(x => x.LoctionPrizeId == lottezyId).ToList();
////lay ra ngay gan nhat
//detail = DS.OrderBy(x => x.DatePrize).ToList().FirstOrDefault();
////lay ra giai ung voi ngay do
//if (detail != null)
// kq = detail.Prize;
}
else
{
string[] chuoi = date.Split('-');
DateTime dateTime = new DateTime(year: int.Parse(chuoi[0]), month: int.Parse(chuoi[1]), day: int.Parse(chuoi[2]));
var DS = db.PrizeDetails.Where(x => x.LoctionPrizeId == lottezyId).ToList();
//lay ra ngay hop ly
detail = DS.Where(x => x.DatePrize == dateTime).FirstOrDefault();
//lay ra giai ung voi ngay do
if (detail != null)
{
kq = db.Prizes.SingleOrDefault(x => x.ID == detail.PrizeId);
if (kq != null)
{
viewModelPrize = new ViewModelPrize(kq);
viewModelPrize.date = date;
viewModelPrize.LottezyId = detail.LoctionPrizeId.ToString();
viewModelPrize.LottezyName = db.LocationPrizes.SingleOrDefault(x => x.ID == detail.LoctionPrizeId).Name;
}
}
}
}
catch
{
Response res = new Response();
res.code = 1;
return(Ok(res));
}
}
if (kq == null)
{
return(Ok(new Response
{
code = 1
}));
}
else
{
return(Ok(new Response
{
code = 0,
data = viewModelPrize
}
));
}
}
