//[HttpPost]
//[Route("GetByID")]
//public IHttpActionResult GetByID(int posSettingId)
//{
//
//
// string token = "";
// if (headers.Contains("APIKey"))
// {
// token = headers.GetValues("APIKey").First();
// }
// Validation validation = new Validation();
// bool valid = validation.CheckApiKey(token);
// if (valid)
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// var row = (from S in entity.posSetting
// join psal in entity.printers on S.saleInvPrinterId equals psal.printerId into jsale
// join prep in entity.printers on S.reportPrinterId equals prep.printerId into jrep
// join paper in entity.paperSize on S.saleInvPapersizeId equals paper.sizeId into jpaper
// join dpaper in entity.paperSize on S.docPapersizeId equals dpaper.sizeId into jdcpaper
// from jdocpaper in jdcpaper.DefaultIfEmpty()
// from jjsale in jsale.DefaultIfEmpty()
// from jjrep in jrep.DefaultIfEmpty()
// from jjpaper in jpaper.DefaultIfEmpty()
// where S.posSettingId == posSettingId
// select new PosSettingModel()
// {
// posSettingId = S.posSettingId,
// posId = S.posId,
// saleInvPrinterId = S.saleInvPrinterId,
// reportPrinterId = S.reportPrinterId,
// saleInvPapersizeId = S.saleInvPapersizeId,
// posSerial = S.posSerial,
// repprinterId = jjrep.printerId,
// repname = jjrep.name,
// repprintFor = jjrep.printFor,
// salprinterId = jjsale.printerId,
// salname = jjsale.name,
// salprintFor = jjsale.printFor,
// sizeId = jjpaper.sizeId,
// paperSize1 = jjpaper.paperSize1,
// docPapersize = jdocpaper.paperSize1,
// docPapersizeId = S.docPapersizeId,
// saleSizeValue = jjpaper.sizeValue,// paper sale
// docSizeValue = jdocpaper.sizeValue,// paper doc
// }).FirstOrDefault();
// if (row == null)
// return NotFound();
// else
// return Ok(row);
// }
// }
// else
// return NotFound();
//}
// get by posId
private PosSettingModel GetByposId(int posId)
{
using (incposdbEntities entity = new incposdbEntities())
{
PosSettingModel item = (from S in entity.posSetting
join psal in entity.printers on S.saleInvPrinterId equals psal.printerId into jsale
join prep in entity.printers on S.reportPrinterId equals prep.printerId into jrep
join paper in entity.paperSize on S.saleInvPapersizeId equals paper.sizeId into jpaper
join dpaper in entity.paperSize on S.docPapersizeId equals dpaper.sizeId into jdcpaper
from jdocpaper in jdcpaper.DefaultIfEmpty()
from jjsale in jsale.DefaultIfEmpty()
from jjrep in jrep.DefaultIfEmpty()
from jjpaper in jpaper.DefaultIfEmpty()
where S.posId == posId
select new PosSettingModel()
{
posSettingId = S.posSettingId,
posId = S.posId,
saleInvPrinterId = S.saleInvPrinterId,
reportPrinterId = S.reportPrinterId,
saleInvPapersizeId = S.saleInvPapersizeId,
posSerial = S.posSerial,
repprinterId = S.reportPrinterId,
repname = jjrep.name,
repprintFor = jjrep.printFor,
salprinterId = S.saleInvPrinterId,
salname = jjsale.name,
salprintFor = jjsale.printFor,
sizeId = S.saleInvPapersizeId,
paperSize1 = jjpaper.paperSize1,
docPapersize = jdocpaper.paperSize1,
docPapersizeId = S.docPapersizeId,
saleSizeValue = jjpaper.sizeValue, // paper sale
docSizeValue = jdocpaper.sizeValue, // paper doc
}).FirstOrDefault();
return(item);
}
}
public string GetByposId(string token)
{
// public ResponseVM GetItemByID(string token)int posId
// {
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int message = 0;
int posId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "posId")
{
posId = int.Parse(c.Value);
}
}
PosSettingModel item = GetByposId(posId);
//if (item == null)
//{
// item = new PosSettingModel();
// posSetting newObject = new posSetting();
// newObject.posId = posId;
// message = Save(newObject);
// if (message > 0)
// {
// item = GetByposId(posId);
// }
//}
return(TokenManager.GenerateToken(item));
}
//var re = Request;
//
//string token = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// using (incposdbEntities entity = new incposdbEntities())
// {
// var row = (from S in entity.posSetting
// join psal in entity.printers on S.saleInvPrinterId equals psal.printerId into jsale
// join prep in entity.printers on S.reportPrinterId equals prep.printerId into jrep
// join paper in entity.paperSize on S.saleInvPapersizeId equals paper.sizeId into jpaper
// join dpaper in entity.paperSize on S.docPapersizeId equals dpaper.sizeId into jdcpaper
// from jdocpaper in jdcpaper.DefaultIfEmpty()
// from jjsale in jsale.DefaultIfEmpty()
// from jjrep in jrep.DefaultIfEmpty()
// from jjpaper in jpaper.DefaultIfEmpty()
// where S.posId == posId
// select new PosSettingModel()
// {
// posSettingId = S.posSettingId,
// posId = S.posId,
// saleInvPrinterId = S.saleInvPrinterId,
// reportPrinterId = S.reportPrinterId,
// saleInvPapersizeId = S.saleInvPapersizeId,
// posSerial = S.posSerial,
// repprinterId = jjrep.printerId,
// repname = jjrep.name,
// repprintFor = jjrep.printFor,
// salprinterId = jjsale.printerId,
// salname = jjsale.name,
// salprintFor = jjsale.printFor,
// sizeId = jjpaper.sizeId,
// paperSize1 = jjpaper.paperSize1,
// docPapersize = jdocpaper.paperSize1,
// docPapersizeId=S.docPapersizeId,
// saleSizeValue = jjpaper.sizeValue,// paper sale
// docSizeValue = jdocpaper.sizeValue,// paper doc
// }).FirstOrDefault();
// if (row == null)
// return NotFound();
// else
// return Ok(row);
// }
//}
//else
// return NotFound();
}
