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