public ResponseModel GetItemDetailByOrderID(int orderID)
{
HSOrderCaller hSOrderCaller = new HSOrderCaller();
ResponseModel objResponseModel = new ResponseModel();
OrdersItemDetails ordersItems = new OrdersItemDetails();
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));
ordersItems = hSOrderCaller.GetItemDetailByOrderID(new HSOrderService(_connectionString), orderID, authenticate.TenantId, authenticate.UserMasterID);
statusCode =
ordersItems.OrdersItems.Count > 0 ?
(int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = ordersItems;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
/// GetItemDetailByOrderID
/// </summary>
/// <param name="orderID"></param>
/// <param name="tenantID"></param>
/// <param name="userID"></param>
/// <returns></returns>
public OrdersItemDetails GetItemDetailByOrderID(int orderID, int tenantID, int userID)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <OrdersItem> lstOrdersItem = new List <OrdersItem>();
OrdersItemDetails ordersItemDetails = new OrdersItemDetails();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand sqlcmd = new MySqlCommand("SP_PHYGetItemDetailByOrderID", conn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("order_ID", orderID);
sqlcmd.Parameters.AddWithValue("tenant_ID", tenantID);
sqlcmd.Parameters.AddWithValue("user_ID", userID);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = sqlcmd;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
OrdersItem ordersItems = new OrdersItem
{
ID = ds.Tables[0].Rows[i]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]),
ItemID = ds.Tables[0].Rows[i]["ItemID"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ItemID"]),
ItemName = ds.Tables[0].Rows[i]["ItemName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ItemName"]),
ItemPrice = ds.Tables[0].Rows[i]["ItemPrice"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["ItemPrice"]),
Quantity = ds.Tables[0].Rows[i]["Quantity"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Quantity"]),
OrderID = ds.Tables[0].Rows[i]["OrderID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["OrderID"]),
Disable = ds.Tables[0].Rows[i]["Disable"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["Disable"]),
Checked = ds.Tables[0].Rows[i]["Checked"] == DBNull.Value ? false : Convert.ToBoolean(ds.Tables[0].Rows[i]["Checked"]),
};
lstOrdersItem.Add(ordersItems);
}
ordersItemDetails.OrdersItems = lstOrdersItem;
}
if (ds != null && ds.Tables[1] != null)
{
ordersItemDetails.InvoiceNumber = ds.Tables[1].Rows[0]["InvoiceNo"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[1].Rows[0]["InvoiceNo"]);
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(ordersItemDetails);
}
