public ResponseModel GetShipmentAssignedDetails(ShipmentAssignedFilterRequest shipmentAssignedFilter)
{
ShipmentAssignedDetails assignedDetails = new ShipmentAssignedDetails();
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));
assignedDetails = hSOrderCaller.GetShipmentAssignedDetails(new HSOrderService(_connectionString),
authenticate.TenantId, authenticate.UserMasterID, shipmentAssignedFilter);
statusCode =
assignedDetails.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 = assignedDetails;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public ShipmentAssignedDetails GetShipmentAssignedDetails(int tenantId, int userId, ShipmentAssignedFilterRequest shipmentAssignedFilter)
{
DataSet ds = new DataSet();
ShipmentAssignedDetails objdetails = new ShipmentAssignedDetails();
List <ShipmentAssigned> shipmentAssigned = new List <ShipmentAssigned>();
int TotalCount = 0;
try
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SP_PHYGetOrderShipmentAssigned", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@_tenantID", tenantId);
cmd.Parameters.AddWithValue("@_UserID", userId);
cmd.Parameters.AddWithValue("@_SearchText", shipmentAssignedFilter.SearchText);
cmd.Parameters.AddWithValue("@_pageno", shipmentAssignedFilter.PageNo);
cmd.Parameters.AddWithValue("@_pagesize", shipmentAssignedFilter.PageSize);
cmd.Parameters.AddWithValue("@_FilterReferenceNo", shipmentAssignedFilter.FilterReferenceNo);
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++)
{
ShipmentAssigned obj = new ShipmentAssigned
{
OrderID = Convert.ToInt16(ds.Tables[0].Rows[i]["OrderID"]),
AWBNo = Convert.ToString(ds.Tables[0].Rows[i]["AWBNo"]),
InvoiceNo = Convert.ToString(ds.Tables[0].Rows[i]["InvoiceNo"]),
CourierPartner = Convert.ToString(ds.Tables[0].Rows[i]["CourierPartner"]),
ReferenceNo = Convert.ToString(ds.Tables[0].Rows[i]["ReferenceNo"]),
StoreName = Convert.ToString(ds.Tables[0].Rows[i]["StoreName"]),
StaffName = Convert.ToString(ds.Tables[0].Rows[i]["StaffName"]),
MobileNumber = Convert.ToString(ds.Tables[0].Rows[i]["MobileNumber"]),
IsProceed = Convert.ToBoolean(ds.Tables[0].Rows[i]["IsProceed"]),
ShipmentAWBID = Convert.ToString(ds.Tables[0].Rows[i]["ShipmentAWBID"])
};
shipmentAssigned.Add(obj);
}
}
if (ds != null && ds.Tables[1] != null)
{
TotalCount = ds.Tables[1].Rows[0]["TotalAssignedShipment"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[1].Rows[0]["TotalAssignedShipment"]);
}
objdetails.shipmentAssigned = shipmentAssigned;
objdetails.TotalCount = TotalCount;
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
if (ds != null)
{
ds.Dispose();
}
}
return(objdetails);
}
