public string ChangeStatus(UpdateOrderDto updateOrderDto) { string orderStatus = ""; string retStatus = ""; try { var identity = (ClaimsPrincipal)Thread.CurrentPrincipal; var userId = identity.Claims.Where(c => c.Type == ClaimTypes.Sid) .Select(c => c.Value) .SingleOrDefault(); using (ORDR_MGMT_SYSEntities en = new ORDR_MGMT_SYSEntities()) { var updateOrder = en.USR_ORDERS.Where(x => x.ORD_ID == updateOrderDto.ORD_ID && x.ORD_LINE_NUM == updateOrderDto.LINE_NUM).SingleOrDefault(); updateOrder.ORDER_STATUS = updateOrderDto.ORDER_STATUS; updateOrder.LAST_MODIFIED_ON = DateTime.Now; if (orderStatus == "Completed") { updateOrder.RECEIPT_DATE = DateTime.Now; } updateOrder.LAST_MODIFIED_BY = userId; en.SaveChanges(); } retStatus = "Updated Successfully"; } catch (Exception ex) { retStatus = ex.InnerException.Message.ToString(); } return(retStatus); }
public string DeleteOrder(JObject orderId) { string resultStatus = "No Operation Performed"; string _OrderID = orderId["orderId"].Value <string>(); try { using (ORDR_MGMT_SYSEntities en = new ORDR_MGMT_SYSEntities()) { List <USR_ORDERS> objs = en.USR_ORDERS.Where(x => x.ORD_ID == _OrderID).ToList <USR_ORDERS>(); if (objs.Count == 0) { throw new Exception("No Data Found! Order ID: " + _OrderID); } int _cnt = 0; foreach (USR_ORDERS obj in objs) { var delObj = en.USR_ORDERS.Remove(obj); if (delObj != null) { _cnt++; } } resultStatus = "Deleted Successfully " + _cnt.ToString() + " out of " + objs.Count.ToString(); en.SaveChanges(); } } catch (Exception ex) { resultStatus = ex.Message; } return(resultStatus); }
public string PostOrder(List <OrdersDto> orders) { ORDR_MGMT_SYSEntities entities = new ORDR_MGMT_SYSEntities(); string status = ""; var identity = (ClaimsPrincipal)Thread.CurrentPrincipal; var usr_id = identity.Claims.Where(c => c.Type == ClaimTypes.Sid) .Select(c => c.Value) .SingleOrDefault(); var email = identity.Claims.Where(c => c.Type == ClaimTypes.Email) .Select(c => c.Value) .SingleOrDefault(); System.Data.Entity.Core.Objects.ObjectParameter document_id = new System.Data.Entity.Core.Objects.ObjectParameter("RETURN_SERIES", typeof(string)); entities.GenerateDocketSeries("ORDERS", DateTime.Now.Year.ToString(), document_id); if (document_id == null || document_id.Value.ToString() == "") { return("Docket series not found"); } try { foreach (OrdersDto dto in orders) { DateTime orderedDateTime; DateTime.TryParseExact(dto.ORDERED_DATE, "dd-MM-yyyy", CultureInfo.CurrentCulture, DateTimeStyles.None, out orderedDateTime); entities.USR_ORDERS.Add(new USR_ORDERS { ORD_ID = document_id.Value.ToString(), PRD_ID = dto.PRD_ID, ORD_LINE_NUM = dto.LineNum, PRD_QNTY = dto.PRD_QNTY, TAX_AMT = dto.TAX_AMT, NET_AMT = dto.NET_AMT, GROSS_AMT = dto.GROSS_AMT, DISC_AMT = dto.DISC_AMT, ORDRED_DATE = orderedDateTime, ORDER_STATUS = dto.ORDER_STATUS, CREATED_BY = usr_id, CUSTOMER_ID = usr_id, CREATED_ON = DateTime.Now }); } entities.SaveChanges(); status = "Inserted Successfully. "; EmailSending sending = new EmailSending(); status += sending.SendMail(email, "Your has been placed", usr_id); } catch (Exception ex) { status = ex.Message; } return(status); }
public List <USR_ORDERS> GetOrders() { var identity = (ClaimsPrincipal)Thread.CurrentPrincipal; var usr_id = identity.Claims.Where(c => c.Type == ClaimTypes.Sid) .Select(c => c.Value) .SingleOrDefault(); var usr_role = identity.Claims.Where(c => c.Type == ClaimTypes.Role) .Select(c => c.Value) .SingleOrDefault(); string orderDetails = ""; ORDR_MGMT_SYSEntities en = new ORDR_MGMT_SYSEntities(); if (usr_role == "B") { return(en.USR_ORDERS.Where(x => x.CUSTOMER_ID == usr_id).ToList()); } return(en.USR_ORDERS.ToList()); }
public override Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { return(Task.Factory.StartNew(() => { var UserID = context.UserName; var UserPwd = context.Password; if (UserID == null || UserPwd == null) { return; } try { System.Data.Entity.Core.Objects.ObjectParameter result = new System.Data.Entity.Core.Objects.ObjectParameter("vResult", typeof(bool)); using (ORDR_MGMT_SYSEntities entities = new ORDR_MGMT_SYSEntities()) { entities.SP_USR_PWD_DECRYPT(UserID, UserPwd, result); if ((bool)result.Value == true) { var userData = entities.USR_ROLES.Where(x => x.USR_ID == UserID).Select(x => x).SingleOrDefault(); var claims = new List <Claim>() { new Claim(ClaimTypes.Sid, userData.USR_ID), new Claim(ClaimTypes.Role, userData.USR_GRP_ID), new Claim(ClaimTypes.Name, userData.USR_NAME), new Claim(ClaimTypes.Email, userData.USR_EMAIL) }; ClaimsIdentity oAuthIdentity = new ClaimsIdentity(claims, Startup.OAuthOptions.AuthenticationType); var properties = CreateProperties(userData.USR_ID); var ticket = new AuthenticationTicket(oAuthIdentity, properties); context.Validated(ticket); } } } catch (Exception e) { context.SetError("Error", e.Message); } })); }