public KeyValuePair <string, List <UWSPending> > GetUWSPendingRecord(string recordID, int page, int pageSize, UWSPendingRequest model, string sort)
{
//string Equipment = whereCondition.Split('*')[0];
//string Destination = whereCondition.Split('*')[1];
//string Airline = whereCondition.Split('*')[2];
//string FlightNumber = whereCondition.Split('*')[3];
//string FlightDt = whereCondition.Split('*')[4];
//string ULD = whereCondition.Split('*')[5];
//string AwbNo = whereCondition.Split('*')[6];
//DateTime todt;
// whereCondition = "";
//String tdt = "01/01/1900";
//if (FlightDt == "")
//{
// todt = Convert.ToDateTime(tdt);
//}
//else
//{
// todt = Convert.ToDateTime(FlightDt);
//}
try
{
UWSPending UWSPending = new UWSPending();
SqlParameter[] Parameters =
{
new SqlParameter("@Equipment", model.Equipment),
new SqlParameter("@Destination", model.Destination),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()),
new SqlParameter("@Airline", model.Airline),
new SqlParameter("@FlightNo", model.FlightNumber),
new SqlParameter("@FlightDt", model.FlightDt),
new SqlParameter("@ULD", model.ULD),
new SqlParameter("@AwbNo", model.AwbNo)
};
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetUWSPending", Parameters);
var UWSPendingList = ds.Tables[0].AsEnumerable().Select(e => new UWSPending
{
FlightNo = Convert.ToString(e["FlightNo"].ToString()),
FlightDate = Convert.ToString(e["FlightDate"].ToString()),
Load = Convert.ToString(e["Text_LoadType"].ToString()),
EquipmentNo = Convert.ToString(e["EquipmentNo"].ToString()),
Issued = Convert.ToString(e["issued"].ToString()),
ULDNo = Convert.ToString(e["Shipment"].ToString()),
Origin = Convert.ToString(e["OriginCode"].ToString()),
Destination = Convert.ToString(e["DestinationCode"].ToString()),
Process = Convert.ToString(e["Process"].ToString()),
ScaleWt = Convert.ToString(e["ScaleWeight"].ToString()),
TareWt = Convert.ToString(e["TareWeight"].ToString()),
TotalWt = Convert.ToString(e["TotalShipWeight"].ToString()),
NetWt = Convert.ToString(e["NetWeight"].ToString()),
Variance = Convert.ToString(e["Variance"].ToString()),
Manual = Convert.ToString(e["Manual"].ToString()),
Remark = Convert.ToString(e["Remarks"].ToString()),
SHC = Convert.ToString(e["SHC"].ToString()),
Dt = Convert.ToString(e["Dt"].ToString()),
AwbNo = Convert.ToString(e["AWBNo"].ToString())
});
return(new KeyValuePair <string, List <UWSPending> >(ds.Tables[1].Rows[0][0].ToString(), UWSPendingList.AsQueryable().ToList()));
}
catch (Exception ex)// (Exception ex)
{
// do something for error
DataSet dsError;
System.Data.SqlClient.SqlParameter[] ParametersError =
{
new System.Data.SqlClient.SqlParameter("@ErrorMessage", ex.Message),
new System.Data.SqlClient.SqlParameter("@ProcName", "GetUWSPending"),
new System.Data.SqlClient.SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
dsError = CargoFlash.SoftwareFactory.Data.SqlHelper.ExecuteDataset(CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString, System.Data.CommandType.StoredProcedure, "ProcOfHandleErrors", ParametersError);
throw ex;
}
}
public List <UWSPending> SearchData(UWSPending obj)
{
try
{
List <UWSPending> lst = new List <UWSPending>();
DateTime todt;
String tdt = "01/01/1900";
if (obj.FlightDt == "")
{
todt = Convert.ToDateTime(tdt);
}
else
{
todt = Convert.ToDateTime(obj.FlightDt);
}
SqlParameter[] Parameters =
{
new SqlParameter("@Equipment", obj.Equipment),
new SqlParameter("@Destination", obj.DestCode),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()),
new SqlParameter("@Airline", obj.Airline),
new SqlParameter("@FlightNo", obj.FlightNumber),
new SqlParameter("@FlightDt", todt),
new SqlParameter("@ULD", obj.ULD),
new SqlParameter("@AwbNo", obj.AwbNo)
};
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetUWSPending", Parameters);
if (ds != null && ds.Tables.Count > 0)
{
lst = ds.Tables[0].AsEnumerable().Select(e => new UWSPending
{
FlightNo = Convert.ToString(e["FlightNo"].ToString()),
FlightDate = Convert.ToString(e["FlightDate"].ToString()),
Load = Convert.ToString(e["Text_LoadType"].ToString()),
EquipmentNo = Convert.ToString(e["EquipmentNo"].ToString()),
Issued = Convert.ToString(e["issued"].ToString()),
ULDNo = Convert.ToString(e["Shipment"].ToString()),
Origin = Convert.ToString(e["OriginCode"].ToString()),
Destination = Convert.ToString(e["DestinationCode"].ToString()),
Process = Convert.ToString(e["Process"].ToString()),
ScaleWt = Convert.ToString(e["ScaleWeight"].ToString()),
TareWt = Convert.ToString(e["TareWeight"].ToString()),
TotalWt = Convert.ToString(e["TotalShipWeight"].ToString()),
NetWt = Convert.ToString(e["NetWeight"].ToString()),
Variance = Convert.ToString(e["Variance"].ToString()),
Manual = Convert.ToString(e["Manual"].ToString()),
Remark = Convert.ToString(e["Remarks"].ToString()),
SHC = Convert.ToString(e["SHC"].ToString()),
Dt = Convert.ToString(e["Dt"].ToString()),
AwbNo = Convert.ToString(e["AWBNo"].ToString())
}).ToList();
}
return(lst);
}
catch (Exception ex)// (Exception ex)
{
// do something for error
DataSet dsError;
System.Data.SqlClient.SqlParameter[] ParametersError =
{
new System.Data.SqlClient.SqlParameter("@ErrorMessage", ex.Message),
new System.Data.SqlClient.SqlParameter("@ProcName", "GetUWSPending"),
new System.Data.SqlClient.SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
dsError = CargoFlash.SoftwareFactory.Data.SqlHelper.ExecuteDataset(CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString, System.Data.CommandType.StoredProcedure, "ProcOfHandleErrors", ParametersError);
throw ex;
}
}