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 = ""; sysEmails 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 <sysEmails>(Object, new IsoDateTimeConverter { DateTimeFormat = "dd/MM/yyyy" }); break; } } if (newObject != null) { sysEmails tmpObject = null; try { 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; } using (incposdbEntities entity = new incposdbEntities()) { // check if there is other same side in same branch var sidebranch = entity.sysEmails .Where(e => e.branchId == newObject.branchId && e.side == newObject.side && e.emailId != newObject.emailId).ToList(); //if not exist continue save if (sidebranch == null || sidebranch.Count() == 0) { var locationEntity = entity.Set <sysEmails>(); if (newObject.emailId == 0) { newObject.createDate = DateTime.Now; newObject.updateDate = DateTime.Now; newObject.updateUserId = newObject.createUserId; // string encodedStr = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes("inputStr")); // string inputStr = Encoding.UTF8.GetString(Convert.FromBase64String(encodedStr)); locationEntity.Add(newObject); entity.SaveChanges(); message = newObject.emailId.ToString(); } else { tmpObject = entity.sysEmails.Where(p => p.emailId == newObject.emailId).FirstOrDefault(); tmpObject.updateDate = DateTime.Now; tmpObject.updateUserId = newObject.updateUserId; tmpObject.name = newObject.name; tmpObject.emailId = newObject.emailId; tmpObject.email = newObject.email; tmpObject.password = newObject.password; tmpObject.port = newObject.port; tmpObject.isSSL = newObject.isSSL; tmpObject.smtpClient = newObject.smtpClient; tmpObject.side = newObject.side; tmpObject.notes = newObject.notes; tmpObject.branchId = newObject.branchId; tmpObject.isActive = newObject.isActive; tmpObject.isMajor = newObject.isMajor; entity.SaveChanges(); message = tmpObject.emailId.ToString(); } // entity.SaveChanges(); return(TokenManager.GenerateToken(message)); } else { message = "-4"; return(TokenManager.GenerateToken(message)); } } } catch { message = "0"; return(TokenManager.GenerateToken(message)); } } // return new ResponseVM { Status = "Fail", Message = 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('"'); // sysEmails newObject = JsonConvert.DeserializeObject<sysEmails>(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()) // { // // check if there is other same side in same branch // var sidebranch = entity.sysEmails // .Where(e => e.branchId == newObject.branchId && e.side == newObject.side && e.emailId != newObject.emailId).ToList(); // //if not exist continue save // if (sidebranch == null || sidebranch.Count()==0) // { // var locationEntity = entity.Set<sysEmails>(); // if (newObject.emailId == 0) // { // newObject.createDate = DateTime.Now; // newObject.updateDate = DateTime.Now; // newObject.updateUserId = newObject.createUserId; // // string encodedStr = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes("inputStr")); // // string inputStr = Encoding.UTF8.GetString(Convert.FromBase64String(encodedStr)); // locationEntity.Add(newObject); // entity.SaveChanges(); // message = newObject.emailId.ToString(); // } // else // { // var tmpObject = entity.sysEmails.Where(p => p.emailId == newObject.emailId).FirstOrDefault(); // tmpObject.updateDate = DateTime.Now; // tmpObject.updateUserId = newObject.updateUserId; // tmpObject.name = newObject.name; // tmpObject.emailId = newObject.emailId; // tmpObject.email = newObject.email; // tmpObject.password = newObject.password; // tmpObject.port = newObject.port; // tmpObject.isSSL = newObject.isSSL; // tmpObject.smtpClient = newObject.smtpClient; // tmpObject.side = newObject.side; // tmpObject.notes = newObject.notes; // tmpObject.branchId = newObject.branchId; // tmpObject.isActive = newObject.isActive; // tmpObject.isMajor = newObject.isMajor; // entity.SaveChanges(); // message = tmpObject.emailId.ToString(); // } // // entity.SaveChanges(); // } // else // { // message = "-4"; // } // } // } // catch // { // message = "-1"; // } //} //return message; }
public string Delete(string token) { // public ResponseVM Delete(string token)int emailId, int userId, bool final //int Id, int userId string message = ""; token = TokenManager.readToken(HttpContext.Current.Request); var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { int emailId = 0; int userId = 0; bool final = false; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "emailId") { emailId = int.Parse(c.Value); } else if (c.Type == "userId") { userId = int.Parse(c.Value); } else if (c.Type == "userId") { userId = int.Parse(c.Value); } } try { using (incposdbEntities entity = new incposdbEntities()) { sysEmails objectDelete = entity.sysEmails.Find(emailId); entity.sysEmails.Remove(objectDelete); message = entity.SaveChanges().ToString(); return(TokenManager.GenerateToken(message)); } // 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) //{ // if (final) // { // try // { // using (incposdbEntities entity = new incposdbEntities()) // { // sysEmails objectDelete = entity.sysEmails.Find(emailId); // entity.sysEmails.Remove(objectDelete); // message = entity.SaveChanges(); // return message.ToString(); // } // } // catch // { // return "-1"; // } // } // else // { // try // { // using (incposdbEntities entity = new incposdbEntities()) // { // sysEmails objectDelete = entity.sysEmails.Find(emailId); // objectDelete.isActive = 0; // objectDelete.updateUserId = userId; // objectDelete.updateDate = DateTime.Now; // message = entity.SaveChanges(); // return message.ToString(); ; // } // } // catch // { // return "-2"; // } // } //} //else // return "-3"; }
public string GetByBranchIdandSide(string token) { // public ResponseVM GetPurinv(string token)int branchId,string side token = TokenManager.readToken(HttpContext.Current.Request); var strP = TokenManager.GetPrincipal(token); if (strP != "0") //invalid authorization { return(TokenManager.GenerateToken(strP)); } else { string side = ""; int branchId = 0; IEnumerable <Claim> claims = TokenManager.getTokenClaims(token); foreach (Claim c in claims) { if (c.Type == "branchId") { branchId = int.Parse(c.Value); } else if (c.Type == "side") { side = c.Value; } } sysEmails emptyrow = null; // DateTime cmpdate = DateTime.Now.AddDays(newdays); try { using (incposdbEntities entity = new incposdbEntities()) { // return email with same branch and side or // return email with same side and isMajor var row = entity.sysEmails .Where(u => u.branchId == branchId && u.side == side) .Select(S => new { S.emailId, S.name, S.email, S.password, S.port, S.isSSL, S.smtpClient, S.side, S.notes, S.branchId, S.isMajor, S.isActive, S.createDate, S.updateDate, S.createUserId, S.updateUserId, }) .FirstOrDefault(); if (row == null) { var row2 = entity.sysEmails .Where(u => u.side == side && u.isMajor == true) .Select(S => new { S.emailId, S.name, S.email, S.password, S.port, S.isSSL, S.smtpClient, S.side, S.notes, S.branchId, S.isMajor, S.isActive, S.createDate, S.updateDate, S.createUserId, S.updateUserId, }).FirstOrDefault(); if (row2 == null) { return(TokenManager.GenerateToken(emptyrow)); } else { return(TokenManager.GenerateToken(row2)); } } else { return(TokenManager.GenerateToken(row)); } } } catch { return(TokenManager.GenerateToken(emptyrow)); } } }