public ResponseModel GetOrderDeliveredDetails(OrderDeliveredFilterRequest orderDeliveredFilter)
{
OrderDeliveredDetails orderDelivereds = new OrderDeliveredDetails();
HSOrderCaller hSOrderCaller = 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));
orderDelivereds = hSOrderCaller.GetOrderDeliveredDetails(new HSOrderService(_connectionString),
authenticate.TenantId, authenticate.UserMasterID, orderDeliveredFilter);
statusCode =
orderDelivereds.TotalCount == 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 = orderDelivereds;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public OrderDeliveredDetails GetOrderDeliveredDetails(int tenantId, int userId, OrderDeliveredFilterRequest orderDeliveredFilter)
{
DataSet ds = new DataSet();
OrderDeliveredDetails objdetails = new OrderDeliveredDetails();
List <OrderDelivered> orderDelivered = new List <OrderDelivered>();
int TotalCount = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_PHYGetOrderDeliveredDetails", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@_tenantID", tenantId);
cmd.Parameters.AddWithValue("@_UserID", userId);
cmd.Parameters.AddWithValue("@_SearchText", orderDeliveredFilter.SearchText);
cmd.Parameters.AddWithValue("@_pageno", orderDeliveredFilter.PageNo);
cmd.Parameters.AddWithValue("@_pagesize", orderDeliveredFilter.PageSize);
cmd.Parameters.AddWithValue("@_FilterStatus", orderDeliveredFilter.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++)
{
OrderDelivered obj = new OrderDelivered
{
ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]),
InvoiceNo = Convert.ToString(ds.Tables[0].Rows[i]["InvoiceNo"]),
CustomerName = Convert.ToString(ds.Tables[0].Rows[i]["CustomerName"]),
MobileNumber = Convert.ToString(ds.Tables[0].Rows[i]["MobileNumber"]),
Date = Convert.ToString(ds.Tables[0].Rows[i]["Date"]),
Time = Convert.ToString(ds.Tables[0].Rows[i]["Time"]),
StatusName = Convert.ToString(ds.Tables[0].Rows[i]["StatusName"]),
ActionTypeName = Convert.ToString(ds.Tables[0].Rows[i]["ActionTypeName"]),
orderDeliveredItems = new List <OrderDeliveredItem>()
};
obj.orderDeliveredItems = ds.Tables[1].AsEnumerable().Where(x => (x.Field <int>("OrderID")).Equals(obj.ID)).Select(x => new OrderDeliveredItem()
{
ItemID = Convert.ToString(x.Field <string>("ItemID")),
ItemName = Convert.ToString(x.Field <string>("ItemName")),
ItemPrice = x.Field <double>("ItemPrice"),
Quantity = x.Field <int>("Quantity")
}).ToList();
orderDelivered.Add(obj);
}
}
if (ds != null && ds.Tables[2] != null)
{
TotalCount = ds.Tables[2].Rows[0]["TotalOrder"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[2].Rows[0]["TotalOrder"]);
}
objdetails.orderDelivereds = orderDelivered;
objdetails.TotalCount = TotalCount;
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
if (ds != null)
{
ds.Dispose();
}
}
return(objdetails);
}
