public ResponseModel GetShoppingBagDetails(OrdersDataRequest ordersDataRequest)
{
ShoppingBagResponseDetails shoppingBagResponseDetails = new ShoppingBagResponseDetails();
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));
shoppingBagResponseDetails = storecampaigncaller.GetShoppingBagDetails(new HSOrderService(_connectionString),
authenticate.TenantId, authenticate.UserMasterID, ordersDataRequest);
statusCode =
shoppingBagResponseDetails.TotalShoppingBag.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 = shoppingBagResponseDetails;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public OrderResponseDetails GetShipmentDetails(IHSOrder order, int tenantId, int userId, OrdersDataRequest ordersDataRequest)
{
_OrderRepository = order;
return(_OrderRepository.GetShipmentDetails(tenantId, userId, ordersDataRequest));
}
/// <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);
}
