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"); } }