public string shortageIsManipulated(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int inventoryId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
inventoryId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var List = (from c in entity.inventoryItemLocation
.Where(c => c.realAmount - c.amount > 0 && c.inventoryId == inventoryId && c.isFalls == false)
select new InventoryItemLocationModel()
{
id = c.id,
})
.ToList();
bool result = false;
if (List.Count == 0)
{
result = true;
}
else
{
result = false;
}
return(TokenManager.GenerateToken(result));
}
}
}
public string GetByID(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int storageCostId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
storageCostId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var row = entity.storageCost
.Where(u => u.storageCostId == storageCostId)
.Select(S => new
{
S.storageCostId,
S.name,
S.cost,
S.note,
S.isActive,
S.createDate,
S.updateDate,
S.createUserId,
S.updateUserId,
})
.FirstOrDefault();
return(TokenManager.GenerateToken(row));
}
}
}
public string Get(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int itemId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
itemId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var servicesList = entity.servicesCosts
.Where(S => S.itemId == itemId)
.Select(S => new
{
S.costId,
S.name,
S.itemId,
S.costVal,
S.createDate,
S.updateDate,
S.updateUserId,
S.createUserId
})
.ToList();
return(TokenManager.GenerateToken(servicesList));
}
}
}
public string Get(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int invoiceId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
invoiceId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var invoiceStatus = entity.invoiceStatus.Where(x => x.invoiceId == invoiceId)
.Select(c => new InvoiceStatusModel()
{
invStatusId = c.invStatusId,
invoiceId = c.invoiceId,
status = c.status,
createDate = c.createDate,
updateDate = c.updateDate,
createUserId = c.createUserId,
updateUserId = c.updateUserId,
notes = c.notes,
isActive = c.isActive,
})
.ToList();
return(TokenManager.GenerateToken(invoiceStatus));
}
}
}
public string GetByID(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int cId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
cId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var list = entity.branchStore
.Where(c => c.id == cId)
.Select(c => new {
c.id,
c.branchId,
c.storeId,
c.note,
c.createDate,
c.updateDate,
c.createUserId,
c.updateUserId,
c.isActive,
})
.FirstOrDefault();
return(TokenManager.GenerateToken(list));
}
}
}
//[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 GetByisActive(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int isActive = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "isActive")
{
isActive = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var card = entity.cards
.Where(c => c.isActive == isActive)
.Select(c => new {
c.cardId,
c.name,
c.notes,
c.createDate,
c.updateDate,
c.createUserId,
c.updateUserId,
c.isActive,
c.hasProcessNum,
c.image,
})
.ToList();
return(TokenManager.GenerateToken(card));
}
}
}
public string Delete(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
string message = "";
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
try
{
int errorId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
errorId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
error objectDelete = entity.error.Find(errorId);
entity.error.Remove(objectDelete);
message = entity.SaveChanges().ToString();
return(TokenManager.GenerateToken(message));
}
}
catch
{
message = "-1";
return(TokenManager.GenerateToken(message));
}
}
}
public string GetNotUserCount(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int userId = 0;
string type = "";
int posId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
userId = int.Parse(c.Value);
}
else if (c.Type == "type")
{
type = c.Value;
}
else if (c.Type == "posId")
{
posId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var notificationCount = entity.notificationUser
.Where(x => (x.userId == userId || x.posId == posId) && x.isRead == false && x.notification.msgType.Contains(type))
.ToList().Count;
return(TokenManager.GenerateToken(notificationCount));
}
}
}
public string GetByID(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
int cId = 0;
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
using (incposdbEntities entity = new incposdbEntities())
{
var list = entity.inventoryItemLocation
.Where(c => c.id == cId)
.Select(c => new {
c.id,
c.isDestroyed,
c.amount,
c.amountDestroyed,
c.realAmount,
c.itemLocationId,
c.inventoryId,
c.isActive,
c.notes,
c.createDate,
c.updateDate,
c.createUserId,
c.updateUserId,
})
.FirstOrDefault();
return(TokenManager.GenerateToken(list));
}
}
}
public string IsExistcode(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string code = "";
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemId")
{
code = c.Value;
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var coupon = entity.coupons
.Where(c => c.code == code)
.Select(c => new
{
c.cId,
c.name,
c.code,
c.barcode,
})
.FirstOrDefault();
return(TokenManager.GenerateToken(coupon));
}
}
}
public string GetU(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
using (incposdbEntities entity = new incposdbEntities())
{
var unitsList = (from u in entity.units
select new
{
unitId = u.unitId,
name = u.name,
isSmallest = u.isSmallest,
parentid = u.parentid,
smallestId = u.smallestId,
notes = u.notes,
createDate = u.createDate,
createUserId = u.createUserId,
updateDate = u.updateDate,
updateUserId = u.updateUserId,
isActive = u.isActive,
}).ToList();
return(TokenManager.GenerateToken(unitsList));
}
}
}
public string GetUnactivated(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int branchId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "branchId")
{
branchId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var posList = (from p in entity.pos where p.isActive == 1
join b in entity.branches on p.branchId equals b.branchId into lj
from x in lj.DefaultIfEmpty()
where x.branchId == branchId && !entity.posSetting.Any(m => m.posId == p.posId)
select new PosModel()
{
posId = p.posId,
name = p.name,
}).ToList();
return(TokenManager.GenerateToken(posList));
}
}
}
public int getSalesInvCountInMonth()
{
int invCount = 0;
using (incposdbEntities entity = new incposdbEntities())
{
var expireDate = entity.ProgramDetails.Select(x => x.expireDate).Single();
int expireDay = Convert.ToDateTime(expireDate).Day;
int currentMonth = DateTime.Now.Month;
int currentYear = DateTime.Now.Year;
int currentMonthDays = DateTime.DaysInMonth(currentYear, currentMonth);
if (expireDay > currentMonthDays)
{
expireDay = currentMonthDays;
}
DateTime compaireDate2 = new DateTime(currentYear, currentMonth, expireDay);
DateTime compairDate1 = compaireDate2.AddMonths(-1);
// get sales imvoice count between compaireDate1 and compairDate2
invCount = entity.invoices.Where(x => x.invType == "s" && x.updateDate >= compairDate1 && x.updateDate < compaireDate2).Count();
}
return(invCount);
}
public bool checkLogByID(int logId)
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
var item = entity.usersLogs.Where(u => u.logId == logId).FirstOrDefault();
//check if user change server date
if (item.sInDate > DateTime.Now)
{
return(true);
}
if (item.sOutDate != null)
{
return(true);
}
return(false);
}
}
catch
{
return(false);
}
}
public string GetByID(string token)
{
// public ResponseVM GetPurinv(string token)int printerId
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int printerId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "printerId")
{
printerId = int.Parse(c.Value);
}
}
using (incposdbEntities entity = new incposdbEntities())
{
var item = entity.printers
.Where(u => u.printerId == printerId)
.Select(S => new
{
S.printerId,
S.name,
S.printFor,
S.createDate,
S.updateDate,
S.createUserId,
S.updateUserId,
})
.FirstOrDefault();
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 = entity.printers
// .Where(u => u.printerId == printerId)
// .Select(S => new
// {
// S.printerId,
// S.name,
// S.printFor,
// S.createDate,
// S.updateDate,
// S.createUserId,
// S.updateUserId,
// })
// .FirstOrDefault();
// if (row == null)
// return NotFound();
// else
// return Ok(row);
// }
//}
//else
// return NotFound();
}
public string GetAll(string token)
{
// public ResponseVM GetPurinv(string token)
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
//int mainBranchId = 0;
//int userId = 0;
//IEnumerable<Claim> claims = TokenManager.getTokenClaims(token);
//foreach (Claim c in claims)
//{
// if (c.Type == "mainBranchId")
// {
// mainBranchId = int.Parse(c.Value);
// }
// else if (c.Type == "userId")
// {
// userId = int.Parse(c.Value);
// }
//}
// DateTime cmpdate = DateTime.Now.AddDays(newdays);
try
{
using (incposdbEntities entity = new incposdbEntities())
{
var list = (from S in entity.printers
select new
{
S.printerId,
S.name,
S.printFor,
S.createDate,
S.updateDate,
S.createUserId,
S.updateUserId,
}).ToList();
return(TokenManager.GenerateToken(list));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
//
//
// string token = "";
// if (headers.Contains("APIKey"))
// {
// token = headers.GetValues("APIKey").First();
// }
// Validation validation = new Validation();
// bool valid = validation.CheckApiKey(token);
// if (valid) // APIKey is valid
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// var List = (from S in entity.printers
// select new
// {
// S.printerId,
// S.name,
// S.printFor,
// S.createDate,
// S.updateDate,
// S.createUserId,
// S.updateUserId,
// }).ToList();
// /*
//public int printerId { get; set; }
// public string name { get; set; }
// public string printFor { get; set; }
// public Nullable<System.DateTime> createDate { get; set; }
// public Nullable<System.DateTime> updateDate { get; set; }
// public Nullable<int> createUserId { get; set; }
// public Nullable<int> updateUserId { get; set; }
// */
// if (List == null)
// return NotFound();
// else
// return Ok(List);
// }
// }
// //else
// return NotFound();
}
public string CanLogIn(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int posId = 0;
int userId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "posId")
{
posId = int.Parse(c.Value);
}
else if (c.Type == "userId")
{
userId = int.Parse(c.Value);
}
}
List <UserModel> users = new List <UserModel>();
try
{
using (incposdbEntities entity = new incposdbEntities())
{
var usersList = (from bu in entity.branchesUsers
join B in entity.branches on bu.branchId equals B.branchId
join P in entity.pos on B.branchId equals P.branchId
// from u in entity.users.Where(us => us.isActive == 1 || us.userId == 1)
where P.posId == posId && bu.userId == userId
select new
{
bu.branchsUsersId,
bu.branchId,
bu.userId,
}).ToList();
int can = 0;
if (usersList == null || usersList.Count == 0)
{
can = 0;
}
else
{
can = 1;
}
return(TokenManager.GenerateToken(can.ToString()));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
}
public int checkLoginAvalability(int posId, string deviceCode, string userName, string password)
{
// 1 : can login-
// 0 : error
// -1 : package is expired
// -2 : device code is not correct
// -3 : serial is not active
// -4 : customer server code is wrong
// -5 : login date is before last login date
try
{
using (incposdbEntities entity = new incposdbEntities())
{
//check support user
if (userName == "Support@Increase")
{
var suppUser = entity.users.Where(u => u.isActive == 1 && u.username == userName && u.password == password && u.isAdmin == true).FirstOrDefault();
if (suppUser != null)
{
return(1);
}
}
//compair login date with last login date for this user
var user = entity.users.Where(x => x.username == userName && x.password == password && x.isActive == 1).FirstOrDefault();
if (user != null)
{
var logs = entity.usersLogs.Where(x => x.userId == user.userId).OrderByDescending(x => x.sInDate).FirstOrDefault();
if (logs != null && logs.sInDate > DateTime.Now)
{
return(-5);
}
}
ActivateController ac = new ActivateController();
int active = ac.CheckPeriod();
if (active == 0)
{
return(-1);
}
else
{
var tmpObject = entity.posSetting.Where(x => x.posId == posId).FirstOrDefault();
if (tmpObject != null)
{
// check customer code
if (tmpObject.posDeviceCode != deviceCode)
{
return(-2);
}
//check customer server code
ProgramDetailsController pc = new ProgramDetailsController();
var programD = pc.getCustomerServerCode();
if (programD == null || programD.customerServerCode != ac.ServerID())
{
return(-4);
}
}
// check serial && package avalilability
var serial = entity.posSetting.Where(x => x.posId == posId && x.posSerials.isActive == true).FirstOrDefault();
var programDetails = entity.ProgramDetails.Where(x => x.isActive == true).FirstOrDefault();
if (serial == null || programDetails == null)
{
return(-3);
}
}
return(1);
}
}
catch
{
return(0);
}
}
public string Save(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
string message = "";
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string userObject = "";
users userObj = null;
users newObject = null;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "itemObject")
{
userObject = c.Value.Replace("\\", string.Empty);
userObject = userObject.Trim('"');
newObject = JsonConvert.DeserializeObject <users>(userObject, new JsonSerializerSettings {
DateParseHandling = DateParseHandling.None
});
break;
}
}
if (newObject.updateUserId == 0 || newObject.updateUserId == null)
{
Nullable <int> id = null;
newObject.updateUserId = id;
}
if (newObject.createUserId == 0 || newObject.createUserId == null)
{
Nullable <int> id = null;
newObject.createUserId = id;
}
try
{
using (incposdbEntities entity = new incposdbEntities())
{
var userEntity = entity.Set <users>();
var catEntity = entity.Set <categoryuser>();
if (newObject.userId == 0)
{
newObject.isAdmin = false;
ProgramInfo programInfo = new ProgramInfo();
int userMaxCount = programInfo.getUserCount();
int usersCount = entity.users.Count();
if (usersCount >= userMaxCount && userMaxCount != -1)
{
message = "-1";
return(TokenManager.GenerateToken(message));
}
else
{
newObject.createDate = DateTime.Now;
newObject.updateDate = DateTime.Now;
newObject.updateUserId = newObject.createUserId;
newObject.balance = 0;
newObject.balanceType = 0;
userObj = userEntity.Add(newObject);
// get all categories
var categories = entity.categories.Where(x => x.isActive == 1).Select(x => x.categoryId).ToList();
int sequence = 0;
for (int i = 0; i < categories.Count; i++)
{
sequence++;
int categoryId = categories[i];
categoryuser cu = new categoryuser()
{
categoryId = categoryId,
userId = userObj.userId,
sequence = sequence,
createDate = DateTime.Now,
updateDate = DateTime.Now,
createUserId = newObject.createUserId,
updateUserId = newObject.updateUserId,
};
catEntity.Add(cu);
}
entity.SaveChanges().ToString();
message = userObj.userId.ToString();
return(TokenManager.GenerateToken(message));
}
}
else
{
userObj = entity.users.Where(p => p.userId == newObject.userId).FirstOrDefault();
userObj.name = newObject.name;
userObj.username = newObject.username;
userObj.password = newObject.password;
userObj.name = newObject.name;
userObj.lastname = newObject.lastname;
userObj.job = newObject.job;
userObj.workHours = newObject.workHours;
userObj.updateDate = DateTime.Now;
userObj.updateUserId = newObject.updateUserId;
userObj.phone = newObject.phone;
userObj.mobile = newObject.mobile;
userObj.email = newObject.email;
userObj.notes = newObject.notes;
userObj.address = newObject.address;
userObj.isActive = newObject.isActive;
userObj.balance = newObject.balance;
userObj.balanceType = newObject.balanceType;
userObj.isOnline = newObject.isOnline;
entity.SaveChanges().ToString();
message = userObj.userId.ToString();
return(TokenManager.GenerateToken(message));
}
}
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
// return TokenManager.GenerateToken(ex.ToString());
}
}
}
public string Delete(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
string message = "";
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int delUserId = 0;
int userId = 0;
Boolean final = false;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "delUserId")
{
delUserId = int.Parse(c.Value);
}
else if (c.Type == "userId")
{
userId = int.Parse(c.Value);
}
else if (c.Type == "final")
{
final = bool.Parse(c.Value);
}
}
if (final)
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
entity.categoryuser.RemoveRange(entity.categoryuser.Where(x => x.userId == delUserId));
users usersDelete = entity.users.Find(delUserId);
entity.users.Remove(usersDelete);
message = entity.SaveChanges().ToString();
return(TokenManager.GenerateToken(message));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
else
{
try
{
using (incposdbEntities entity = new incposdbEntities())
{
users userDelete = entity.users.Find(delUserId);
userDelete.isActive = 0;
userDelete.updateDate = DateTime.Now;
userDelete.updateUserId = userId;
message = entity.SaveChanges().ToString();
return(TokenManager.GenerateToken(message));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
}
}
public string Get(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
Boolean canDelete = false;
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
using (incposdbEntities entity = new incposdbEntities())
{
var usersList = entity.users
.Select(u => new UserModel()
{
userId = u.userId,
username = u.username,
password = u.password,
name = u.name,
lastname = u.lastname,
job = u.job,
workHours = u.workHours,
createDate = u.createDate,
updateDate = u.updateDate,
createUserId = u.createUserId,
updateUserId = u.updateUserId,
phone = u.phone,
mobile = u.mobile,
email = u.email,
notes = u.notes,
address = u.address,
isActive = u.isActive,
isOnline = u.isOnline,
image = u.image,
balance = u.balance,
balanceType = u.balanceType,
isAdmin = u.isAdmin,
})
.ToList();
if (usersList.Count > 0)
{
for (int i = 0; i < usersList.Count; i++)
{
canDelete = false;
if (usersList[i].isActive == 1)
{
int userId = (int)usersList[i].userId;
var usersPos = entity.posUsers.Where(x => x.userId == userId).Select(b => new { b.posUserId }).FirstOrDefault();
if (usersPos is null)
{
canDelete = true;
}
}
usersList[i].canDelete = canDelete;
}
}
return(TokenManager.GenerateToken(usersList.Where(u => u.userId != 1)));
}
}
}
public string GetSalesMan(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int branchId = 0;
string deliveryPermission = "";
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "branchId")
{
branchId = int.Parse(c.Value);
}
else if (c.Type == "deliveryPermission")
{
deliveryPermission = c.Value;
}
}
List <UserModel> users = new List <UserModel>();
using (incposdbEntities entity = new incposdbEntities())
{
var usersList = (from u in entity.users.Where(us => us.isActive == 1 && us.userId != 1)
join bu in entity.branchesUsers on u.userId equals bu.userId
where bu.branchId == branchId
select new UserModel
{
userId = u.userId,
username = u.username,
name = u.name,
lastname = u.lastname,
fullName = u.name + " " + u.lastname,
balance = u.balance,
balanceType = u.balanceType,
isAdmin = u.isAdmin,
}).ToList();
foreach (UserModel user in usersList)
{
var groupObjects = (from GO in entity.groupObject
where GO.showOb == 1 && GO.objects.name.Contains(deliveryPermission)
join U in entity.users on GO.groupId equals U.groupId
where U.userId == user.userId
select new
{
//group object
GO.id,
GO.showOb,
}).FirstOrDefault();
if (groupObjects != null)
{
users.Add(user);
}
}
return(TokenManager.GenerateToken(users));
}
}
}
public string Getloginuser(string token)
{
token = TokenManager.readToken(HttpContext.Current.Request);
List <UserModel> usersList = new List <UserModel>();
UserModel user = new UserModel();
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string userName = "";
string password = "";
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "userName")
{
userName = c.Value;
}
else if (c.Type == "password")
{
password = c.Value;
}
}
UserModel emptyuser = new UserModel();
emptyuser.createDate = DateTime.Now;
emptyuser.updateDate = DateTime.Now;
//emptyuser.username = userName;
emptyuser.createUserId = 0;
emptyuser.updateUserId = 0;
emptyuser.userId = 0;
emptyuser.isActive = 0;
emptyuser.isOnline = 0;
emptyuser.canDelete = false;
emptyuser.balance = 0;
emptyuser.balanceType = 0;
try
{
using (incposdbEntities entity = new incposdbEntities())
{
usersList = entity.users.Where(u => u.isActive == 1 && u.username == userName)
.Select(u => new UserModel
{
userId = u.userId,
username = u.username,
password = u.password,
name = u.name,
lastname = u.lastname,
fullName = u.name + " " + u.lastname,
job = u.job,
workHours = u.workHours,
createDate = u.createDate,
updateDate = u.updateDate,
createUserId = u.createUserId,
updateUserId = u.updateUserId,
phone = u.phone,
mobile = u.mobile,
email = u.email,
notes = u.notes,
address = u.address,
isActive = u.isActive,
isOnline = u.isOnline,
image = u.image,
balance = u.balance,
balanceType = u.balanceType,
isAdmin = u.isAdmin,
})
.ToList();
if (usersList == null || usersList.Count <= 0)
{
user = emptyuser;
// rong user
return(TokenManager.GenerateToken(user));
}
else
{
user = usersList.Where(i => i.username == userName).FirstOrDefault();
if (user.password.Equals(password))
{
// correct username and pasword
return(TokenManager.GenerateToken(user));
}
else
{
// rong pass return just username
user = emptyuser;
user.username = userName;
return(TokenManager.GenerateToken(user));
}
}
}
}
catch
{
return(TokenManager.GenerateToken(emptyuser));
}
}
}
public string Delete(string token)
{
//public String Save(string token)int docId
//{
//string Object
string message = "";
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int docId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "docId")
{
docId = int.Parse(c.Value);
}
}
try
{
using (incposdbEntities entity = new incposdbEntities())
{
docImages docImageObj = entity.docImages.Find(docId);
entity.docImages.Remove(docImageObj);
entity.SaveChanges();
// delete image from folder
//var files = Directory.GetFiles(System.Web.Hosting.HostingEnvironment.MapPath("~\\images\\docImage"), docImageObj.image);
string tmpPath = System.IO.Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~\\images\\docImage"), docImageObj.image);
if (File.Exists(tmpPath))
{
File.Delete(tmpPath);
}
// return Ok("Serial is Deleted Successfully");
return(TokenManager.GenerateToken("1"));
}
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
//var re = Request;
//var headers = re.Headers;
//string token = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// docImages docImageObj = entity.docImages.Find(docId);
// entity.docImages.Remove(docImageObj);
// entity.SaveChanges();
// // delete image from folder
// //var files = Directory.GetFiles(System.Web.Hosting.HostingEnvironment.MapPath("~\\images\\docImage"), docImageObj.image);
// string tmpPath = System.IO.Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~\\images\\docImage"), docImageObj.image);
// if (File.Exists(tmpPath))
// {
// File.Delete(tmpPath);
// }
// return Ok("Serial is Deleted Successfully");
// }
// }
// catch { return NotFound(); }
//}
//else
// return NotFound();
}
public string UpdateImage(string token)
{
//public String Save(string token)string docImageObject
//{
//string Object
string message = "";
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string Object = "";
docImages newObject = null;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "Object")
{
Object = c.Value.Replace("\\", string.Empty);
Object = Object.Trim('"');
newObject = JsonConvert.DeserializeObject <docImages>(Object, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
break;
}
}
if (newObject != null)
{
if (newObject.updateUserId == 0 || newObject.updateUserId == null)
{
Nullable <int> id = null;
newObject.updateUserId = id;
}
if (newObject.createUserId == 0 || newObject.createUserId == null)
{
Nullable <int> id = null;
newObject.createUserId = id;
}
try
{
docImages docImage;
using (incposdbEntities entity = new incposdbEntities())
{
var docImgEntity = entity.Set <docImages>();
docImage = entity.docImages.Where(p => p.id == newObject.id).First();
docImage.image = newObject.image;
entity.SaveChanges();
}
return(TokenManager.GenerateToken(docImage.id.ToString()));
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
else
{
return(TokenManager.GenerateToken(message));
}
}
//var re = Request;
//var headers = re.Headers;
//string token = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//docImageObject = docImageObject.Replace("\\", string.Empty);
//docImageObject = docImageObject.Trim('"');
//if (valid)
//{
// docImages docImageObj = JsonConvert.DeserializeObject<docImages>(docImageObject, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });
// if (docImageObj.updateUserId == 0 || docImageObj.updateUserId == null)
// {
// Nullable<int> id = null;
// docImageObj.updateUserId = id;
// }
// if (docImageObj.createUserId == 0 || docImageObj.createUserId == null)
// {
// Nullable<int> id = null;
// docImageObj.createUserId = id;
// }
// try
// {
// docImages docImage;
// using (incposdbEntities entity = new incposdbEntities())
// {
// var docImgEntity = entity.Set<docImages>();
// docImage = entity.docImages.Where(p => p.id == docImageObj.id).First();
// docImage.image = docImageObj.image;
// entity.SaveChanges();
// }
// return docImage.id;
// }
// catch { return 0; }
//}
//else
// return 0;
}
public string Get(string token)
{
//public string GetByGroupId(string token)string tableName, int tableId
//{
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int tableId = 0;
string tableName = "";
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "tableId")
{
tableId = int.Parse(c.Value);
}
else if (c.Type == "tableName")
{
tableName = c.Value;
}
}
// DateTime cmpdate = DateTime.Now.AddDays(newdays);
try
{
using (incposdbEntities entity = new incposdbEntities())
{
var docImageList = entity.docImages.Where(x => x.tableName == tableName && x.tableId == tableId)
.Select(b => new
{
b.id,
b.docName,
b.docnum,
b.image,
b.tableName,
b.tableId,
b.note,
b.createDate,
b.updateDate,
b.createUserId,
b.updateUserId,
})
.ToList();
return(TokenManager.GenerateToken(docImageList));
}
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
//var re = Request;
//var headers = re.Headers;
//string token = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid) // APIKey is valid
//{
// using (incposdbEntities entity = new incposdbEntities())
// {
// var docImageList = entity.docImages.Where(x => x.tableName == tableName && x.tableId == tableId)
// .Select(b => new
// {
// b.id,
// b.docName,
// b.docnum,
// b.image,
// b.tableName,
// b.tableId,
// b.note,
// b.createDate,
// b.updateDate,
// b.createUserId,
// b.updateUserId,
// })
// .ToList();
// if (docImageList == null)
// return NotFound();
// else
// return Ok(docImageList);
// }
//}
////else
//return NotFound();
}
public string Save(string token)
{
//string Object
string message = "";
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
string Object = "";
printers newObject = null;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "Object")
{
Object = c.Value.Replace("\\", string.Empty);
Object = Object.Trim('"');
newObject = JsonConvert.DeserializeObject <printers>(Object, new IsoDateTimeConverter {
DateTimeFormat = "dd/MM/yyyy"
});
break;
}
}
if (newObject != null)
{
printers tmpObject;
if (newObject.updateUserId == 0 || newObject.updateUserId == null)
{
Nullable <int> id = null;
newObject.updateUserId = id;
}
if (newObject.createUserId == 0 || newObject.createUserId == null)
{
Nullable <int> id = null;
newObject.createUserId = id;
}
try
{
using (incposdbEntities entity = new incposdbEntities())
{
var locationEntity = entity.Set <printers>();
if (newObject.printerId == 0)
{
newObject.createDate = DateTime.Now;
newObject.updateDate = DateTime.Now;
newObject.updateUserId = newObject.createUserId;
locationEntity.Add(newObject);
entity.SaveChanges();
message = newObject.printerId.ToString();
}
else
{
tmpObject = entity.printers.Where(p => p.printerId == newObject.printerId).FirstOrDefault();
tmpObject.updateDate = DateTime.Now;
tmpObject.updateUserId = newObject.updateUserId;
tmpObject.name = newObject.name;
// tmpObject.printerId = newObject.printerId;
tmpObject.printFor = newObject.printFor;
entity.SaveChanges();
message = tmpObject.printerId.ToString();
}
// entity.SaveChanges();
}
return(TokenManager.GenerateToken(message));
}
catch
{
message = "0";
return(TokenManager.GenerateToken(message));
}
}
return(TokenManager.GenerateToken(message));
}
//var re = Request;
//
//string token = "";
//string message = "";
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// Object = Object.Replace("\\", string.Empty);
// Object = Object.Trim('"');
// printers newObject = JsonConvert.DeserializeObject<printers>(Object, new JsonSerializerSettings { DateParseHandling = DateParseHandling.None });
// if (newObject.updateUserId == 0 || newObject.updateUserId == null)
// {
// Nullable<int> id = null;
// newObject.updateUserId = id;
// }
// if (newObject.createUserId == 0 || newObject.createUserId == null)
// {
// Nullable<int> id = null;
// newObject.createUserId = id;
// }
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// var locationEntity = entity.Set<printers>();
// if (newObject.printerId == 0)
// {
// newObject.createDate = DateTime.Now;
// newObject.updateDate = DateTime.Now;
// newObject.updateUserId = newObject.createUserId;
// locationEntity.Add(newObject);
// entity.SaveChanges();
// message = newObject.printerId.ToString();
// }
// else
// {
// var tmpObject = entity.printers.Where(p => p.printerId == newObject.printerId).FirstOrDefault();
// tmpObject.updateDate = DateTime.Now;
// tmpObject.updateUserId = newObject.updateUserId;
// tmpObject.name = newObject.name;
// // tmpObject.printerId = newObject.printerId;
// tmpObject.printFor = newObject.printFor;
// entity.SaveChanges();
// message = tmpObject.printerId.ToString();
// }
// // entity.SaveChanges();
// }
// }
// catch
// {
// message = "-1";
// }
//}
//return message;
}
public string Delete(string token)
{//int printerId
string message = "";
token = TokenManager.readToken(HttpContext.Current.Request);
var strP = TokenManager.GetPrincipal(token);
if (strP != "0") //invalid authorization
{
return(TokenManager.GenerateToken(strP));
}
else
{
int printerId = 0;
IEnumerable <Claim> claims = TokenManager.getTokenClaims(token);
foreach (Claim c in claims)
{
if (c.Type == "printerId")
{
printerId = int.Parse(c.Value);
}
}
try
{
using (incposdbEntities entity = new incposdbEntities())
{
printers objectDelete = entity.printers.Find(printerId);
entity.printers.Remove(objectDelete);
message = entity.SaveChanges().ToString();
}
return(TokenManager.GenerateToken(message));
}
catch
{
return(TokenManager.GenerateToken("0"));
}
}
//var re = Request;
//
//string token = "";
//int message = 0;
//if (headers.Contains("APIKey"))
//{
// token = headers.GetValues("APIKey").First();
//}
//Validation validation = new Validation();
//bool valid = validation.CheckApiKey(token);
//if (valid)
//{
// try
// {
// using (incposdbEntities entity = new incposdbEntities())
// {
// printers objectDelete = entity.printers.Find(printerId);
// entity.printers.Remove(objectDelete);
// message = entity.SaveChanges();
// return message.ToString();
// }
// }
// catch
// {
// return "-1";
// }
//}
//else
// return "-3";
}
//////////////////////
///
public string Save(usersLogs newObject)
{
//public string Save(string token)
//string Object string newObject
string message = "";
if (newObject != null)
{
usersLogs tmpObject = null;
try
{
if (newObject.posId == 0 || newObject.posId == null)
{
Nullable <int> id = null;
newObject.posId = id;
}
if (newObject.userId == 0 || newObject.userId == null)
{
Nullable <int> id = null;
newObject.userId = id;
}
using (incposdbEntities entity = new incposdbEntities())
{
var locationEntity = entity.Set <usersLogs>();
if (newObject.logId == 0 || newObject.logId == null)
{
// signIn
// sign out old
using (incposdbEntities entity2 = new incposdbEntities())
{
List <usersLogs> ul = new List <usersLogs>();
List <usersLogs> locationE = entity2.usersLogs.ToList();
ul = locationE.Where(s => s.sOutDate == null &&
((DateTime.Now - (DateTime)s.sInDate).TotalHours >= 8) || (s.userId == newObject.userId && s.sOutDate == null)).ToList();
if (ul != null)
{
foreach (usersLogs row in ul)
{
row.sOutDate = DateTime.Now;
entity2.SaveChanges();
}
}
}
newObject.sInDate = DateTime.Now;
locationEntity.Add(newObject);
entity.SaveChanges();
message = newObject.logId.ToString();
//sign out old user
}
else
{//signOut
tmpObject = entity.usersLogs.Where(p => p.logId == newObject.logId).FirstOrDefault();
tmpObject.logId = newObject.logId;
// tmpObject.sInDate=newObject.sInDate;
tmpObject.sOutDate = DateTime.Now;
// tmpObject.posId=newObject.posId;
// tmpObject.userId = newObject.userId;
entity.SaveChanges();
message = tmpObject.logId.ToString();
}
// entity.SaveChanges();
}
return(message);
}
catch
{
message = "0";
return(message);
}
}
else
{
return("0");
}
}
