public ResponseModel GetOrdersDetails(OrdersDataRequest ordersDataRequest) { OrderResponseDetails orderResponseDetails = new OrderResponseDetails(); HSOrderCaller storecampaigncaller = new HSOrderCaller(); ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; try { string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token)); orderResponseDetails = storecampaigncaller.GetOrdersDetails(new HSOrderService(_connectionString), authenticate.TenantId, authenticate.UserMasterID, ordersDataRequest); statusCode = orderResponseDetails.TotalCount.Equals(0) ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; objResponseModel.ResponseData = orderResponseDetails; } catch (Exception) { throw; } return(objResponseModel); }
/// <summary> /// GetShipmentDetails /// </summary> /// <param name="tenantId"></param> /// <param name="userId"></param> /// <param name="ordersDataRequest"></param> /// <returns></returns> public OrderResponseDetails GetShipmentDetails(int tenantId, int userId, OrdersDataRequest ordersDataRequest) { DataSet ds = new DataSet(); OrderResponseDetails objdetails = new OrderResponseDetails(); List <Orders> orderlist = new List <Orders>(); int TotalCount = 0; try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_PHYGetShipmentDetails", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@_TenantID", tenantId); cmd.Parameters.AddWithValue("@_UserID", userId); cmd.Parameters.AddWithValue("@_SearchText", ordersDataRequest.SearchText); cmd.Parameters.AddWithValue("@_pageno", ordersDataRequest.PageNo); cmd.Parameters.AddWithValue("@_pagesize", ordersDataRequest.PageSize); cmd.Parameters.AddWithValue("@_FilterStatus", ordersDataRequest.FilterStatus); MySqlDataAdapter da = new MySqlDataAdapter { SelectCommand = cmd }; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Orders obj = new Orders { ID = ds.Tables[0].Rows[i]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]), InvoiceNo = ds.Tables[0].Rows[i]["InvoiceNo"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["InvoiceNo"]), CustomerName = ds.Tables[0].Rows[i]["CustomerName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CustomerName"]), MobileNumber = ds.Tables[0].Rows[i]["MobileNumber"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["MobileNumber"]), Amount = ds.Tables[0].Rows[i]["Amount"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Amount"]), Date = ds.Tables[0].Rows[i]["Date"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Date"]), Time = ds.Tables[0].Rows[i]["Time"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Time"]), StatusName = ds.Tables[0].Rows[i]["StatusName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["StatusName"]), ShippingAddress = ds.Tables[0].Rows[i]["ShippingAddress"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ShippingAddress"]), ActionTypeName = ds.Tables[0].Rows[i]["ActionTypeName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ActionTypeName"]), IsShoppingBagConverted = ds.Tables[0].Rows[i]["IsShoppingBagConverted"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[i]["IsShoppingBagConverted"]), ShoppingID = ds.Tables[0].Rows[i]["ShoppingID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["ShoppingID"]), ShoppingBagNo = ds.Tables[0].Rows[i]["ShoppingBagNo"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ShoppingBagNo"]), DeliveryType = ds.Tables[0].Rows[i]["DeliveryType"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["DeliveryType"]), DeliveryTypeName = ds.Tables[0].Rows[i]["DeliveryTypeName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["DeliveryTypeName"]), PickupDate = ds.Tables[0].Rows[i]["PickupDate"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["PickupDate"]), PickupTime = ds.Tables[0].Rows[i]["PickupTime"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["PickupTime"]), CourierPartner = ds.Tables[0].Rows[i]["CourierPartner"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CourierPartner"]), OrdersItemList = new List <OrdersItem>(), ShoppingBagItemList = new List <ShoppingBagItem>() }; obj.OrdersItemList = ds.Tables[1].AsEnumerable().Where(x => (x.Field <int>("OrderID")).Equals(obj.ID)).Select(x => new OrdersItem() { ID = Convert.ToInt32(x.Field <int>("ID")), ItemID = Convert.ToString(x.Field <string>("ItemID")), ItemName = Convert.ToString(x.Field <string>("ItemName")), ItemPrice = Convert.ToString(x.Field <string>("ItemPrice")), Quantity = x.Field <int>("Quantity") }).ToList(); obj.ShoppingBagItemList = ds.Tables[2].AsEnumerable().Where(x => (x.Field <int>("ShoppingID")).Equals(obj.ShoppingID)).Select(x => new ShoppingBagItem() { ID = Convert.ToInt32(x.Field <int>("ID")), ItemID = Convert.ToString(x.Field <string>("ItemID")), ItemName = Convert.ToString(x.Field <string>("ItemName")), ItemPrice = Convert.ToString(x.Field <string>("ItemPrice")), Quantity = x.Field <int>("Quantity") }).ToList(); orderlist.Add(obj); } } if (ds != null && ds.Tables[3] != null) { TotalCount = ds.Tables[3].Rows[0]["TotalOrder"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[3].Rows[0]["TotalOrder"]); } objdetails.OrdersList = orderlist; objdetails.TotalCount = TotalCount; } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(objdetails); }