public DataSourceResult GetComplaintGridData(GetComplaintGridData model, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
int usersno = (((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"]))).UserSNo;
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetComplaintGridData";
string filters = GridFilter.ProcessFilters <ComplaintGrid>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@searchComplainNo", model.searchComplainNo),
new SqlParameter("@searchComplainStatus", model.searchComplainStatus),
new SqlParameter("@searchAWBNo", model.searchAWBNo),
new SqlParameter("@searchFromDate", model.searchFromDate),
new SqlParameter("@searchToDate", model.searchToDate),
new SqlParameter("@SearchClaim", model.SearchClaim),
new SqlParameter("@LoggedInCity", model.LoggedInCity),
new SqlParameter("@UserSNo", usersno)
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var ComplaintList = ds.Tables[0].AsEnumerable().Select(e => new ComplaintGrid
{
//SNo = Convert.ToInt32(e["SNo"]),
ComplaintSNo = Convert.ToInt32(e["ComplaintSNo"]),
ComplaintNo = e["ComplaintNo"].ToString(),
RaisedDate = DateTime.SpecifyKind(Convert.ToDateTime(e["RaisedDate"]), DateTimeKind.Utc),
AWBNo = e["AWBNo"].ToString(),
ComplaintName = e["ComplaintName"].ToString(),
Claim = (Convert.ToBoolean(e["PreClaim"]) == true ? "Yes" : "No").ToString(),
ContactNo = e["ContactNo"].ToString(),
ComplainSourceName = e["ComplainSourceName"].ToString(),
ComplaintStatusName = e["ComplaintStatusName"].ToString(),
PreClaim = Convert.ToBoolean(e["PreClaim"]),
IsClosed = Convert.ToBoolean((e["IsClosed"])),
IsAssign = Convert.ToBoolean((e["IsAssign"])),
IsEdox = Convert.ToBoolean((e["IsEdox"])),
IsAction = Convert.ToBoolean((e["IsAction"])),
IsEdit = Convert.ToBoolean((e["IsEdit"])),
});
ds.Dispose();
return(new DataSourceResult
{
Data = ComplaintList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//(Exception ex)
{
throw ex;
}
}
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string filters = GridFilter.ProcessFilters <InvVehicleService>(filter);
string connectionString = CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString.ToString();
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts) };
DataSet ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "GetListInvVehicleService", Parameters);
var InvVehicleServiceList = ds.Tables[0].AsEnumerable().Select(e => new CargoFlash.Cargo.Model.Inventory.InvVehicleService
{
SNo = Convert.ToInt32(e["SNo"]),
Text_VehicleSNo = e["Text_VehicleSNo"].ToString().ToUpper(),
RegistrationNo = e["RegistrationNo"].ToString().ToUpper(),
Text_VehicleServiceType = e["Text_VehicleServiceType"].ToString().ToUpper(),
ServicedOn = DateTime.Parse(e["ServicedOn"].ToString()),
NextServiceDueOn = DateTime.Parse(e["NextServiceDueOn"].ToString()),
IsActive = Convert.ToBoolean(e["IsActive"])
});
ds.Dispose();
return(new DataSourceResult
{
Data = InvVehicleServiceList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString())
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetNestedGridData(string SNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "ImportFlightMonitor";
string filters = GridFilter.ProcessFilters <ImportFlightMonitoringModel>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@DailyFlightSNo", SNo),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "spGetImportFlightMonitoringTrans", Parameters);
var lst = ds.Tables[0].AsEnumerable().Select(e => new ImportFlightMonitoringModelNestedGrid
{
DailyFlightSno = Convert.ToInt32(e["DailyFlightSno"]),
AWBNo = e["AWBNo"].ToString(),
Weight = e["Weight"].ToString(),
ARRTime = e["ARRTime"].ToString(),
RCFTime = e["RCFTime"].ToString(),
NFDTime = e["NFDTime"].ToString(),
SHC = e["SHC"].ToString(),
FFMArrLocPcsCount = e["FFMArrLocPcCount"].ToString(),
LocationPercent = e["LocationPercent"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = lst.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
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", "spGetImportFlightMonitoringTrans"),
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 DataSourceResult GetHousehipppingBillGridData(string HAWBSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListHouseShippingBill";
string filters = GridFilter.ProcessFilters <HouseShippingBillGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@HAWBSNo", HAWBSNo) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new HouseShippingBillGridData
{
SNo = Convert.ToInt32(e["SNo"]),
ShippingBillNo = Convert.ToInt32(e["ShippingBillNo"]),
AWBNo = e["AWBNo"].ToString(),
MessageType = e["MessageType"].ToString(),
AWBType = e["AWBType"].ToString(),
LEONo = e["LEONo"].ToString()
});
//DateTime.ParseExact(e["BookingDate"].ToString(), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
// FFMManagement fm = new FFMManagement();
//fm.GenerateFlightManifest(DateTime.Parse("2015-29-08"), "AI-0233", "5");
}
//public HouseService(bool authenticationCheck)
// : base(authenticationCheck)
//{
//}
public DataSourceResult GetWMSHouseGridData(string OriginCity, String DestinationCity, String FlightNo, string FlightDate, string AWBPrefix, string AWBNo, string HAWBNo, string LoggedInCity, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
//FFMManagement ffm = new FFMManagement();
//EDICommon edicom=new EDICommon();
//DataTable dtedimessage = new DataTable();
//string flightno = "";
//ffm.GenerateFlightManifest(DateTime.Parse("2015-08-29"), "AI-0233", "5");
// var ediFile = new EDIFileTransmitter();
// for (int i = 0; i < ffm.FFMTable.Rows.Count; i++)
// {
// ediFile.ManuallyRead(ffm.FFMTable.Rows[i]["XMLFile"].ToString());
// edicom.SendMailonSitaAndEmailAddress("", ffm.FFMTable.Rows[i]["XMLFile"].ToString(), "nGen - System Generated Message", "*****@*****.**", "");
// }
// FWBManagement fwb = new FWBManagement();
// fwb.MakeFwbFile("7", string.Empty, "AI-0233", DateTime.Parse("2015-08-29"), string.Empty);
//if (fwb.FwbMessageTable != null)
//{
// dtedimessage.Merge(fwb.FwbMessageTable);
//}
//FSUManagement fsu = new FSUManagement();
//fsu.GenerateFsuMessage(string.Empty, string.Empty, "AI-0233", String.Empty, DateTime.Parse("2015-08-29"),"6","DEL");
//if (fsu.FsuMessageTable != null)
// dtedimessage.Merge(fsu.FsuMessageTable);
// FHLManagement fhl = new FHLManagement();
// fhl.GenerateHouseAwb(string.Empty, "AI-0233", DateTime.Parse("2015-08-29"), string.Empty, "3");
//if (fhl.FhlTable != null)
// dtedimessage.Merge(fhl.FhlTable);
//if (dtedimessage.Rows.Count > 0)
//{
// for (int j = 0; j < dtedimessage.Rows.Count; j++)
// {
// var ediFilefsu = new EDIFileTransmitter();
// ediFilefsu.ManuallyRead(dtedimessage.Rows[j]["XMLFile"].ToString());
// }
//}
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListHouseBookingParam";
string filters = GridFilter.ProcessFilters <HouseGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@OriginCity", OriginCity), new SqlParameter("@DestinationCity", DestinationCity), /*new SqlParameter("@FlightNo", FlightNo), */ new SqlParameter("@HAWBDate", FlightDate), new SqlParameter("@AWBPrefix", AWBPrefix), new SqlParameter("@AWBNo", AWBNo), new SqlParameter("@HAWBNo", FlightNo), new SqlParameter("@LoggedInCity", LoggedInCity) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var houseBookingList = ds.Tables[0].AsEnumerable().Select(e => new HouseGridData
{
SNo = Convert.ToInt32(e["SNo"]),
ProcessStatus = Convert.ToString(e["ProcessStatus"]),
HAWBNo = e["HAWBNo"].ToString().ToUpper(),
AWBNo = e["AWBNo"].ToString(),
//HAWBDate = e["HAWBDate"].ToString() == "" ? "" : Convert.ToDateTime(e["HAWBDate"].ToString()).ToString(DateFormat.DateFormatString),
HAWBDate = e["HAWBDate"].ToString(),
OriginCity = e["OriginCity"].ToString().ToUpper(),
DestinationCity = e["DestinationCity"].ToString().ToUpper(),
GrossWeight = Convert.ToDecimal(e["GrossWeight"].ToString()),
VolumeWeight = Convert.ToDecimal(e["VolumeWeight"].ToString() == "" ? "0" : e["VolumeWeight"].ToString()),
ChargeableWeight = Convert.ToDecimal(e["ChargeableWeight"].ToString() == "" ? "0" : e["ChargeableWeight"].ToString()),
Pieces = Convert.ToInt32(e["Pieces"].ToString() == "" ? "0" : e["Pieces"].ToString()),
CommodityCode = e["CommodityCode"].ToString(),
AccGrWt = Convert.ToDecimal(e["AccGrWt"].ToString()),
AccVolWt = Convert.ToDecimal(e["AccVolWt"].ToString() == "" ? "0" : e["AccVolWt"].ToString()),
AccPcs = Convert.ToInt32(e["AccPcs"].ToString() == "" ? "0" : e["AccPcs"].ToString()),
});
//DateTime.ParseExact(e["BookingDate"].ToString(), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
ds.Dispose();
return(new DataSourceResult
{
Data = houseBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetManifestULDGridData(String FlightNo, String FlightDate, string CurrentProcessSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetRampOffload";
string filters = GridFilter.ProcessFilters <ManifestULD>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@FlightNo", FlightNo),
new SqlParameter("@FlightDate", FlightDate),
new SqlParameter("@LoggedAirport", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportCode.ToString()),
new SqlParameter("@CurrentProcessSNo", CurrentProcessSNo) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsManifestULDList = ds.Tables[0].AsEnumerable().Select(e => new ManifestULD
{
ULDStockSNo = Convert.ToInt32(e["ULDStockSNo"]),
Pieces = Convert.ToInt32(e["Pieces"]),
ULDNo = e["ULDNo"].ToString(),
GrossWeight = Convert.ToString(e["GrossWeight"]),
VolumeWeight = Convert.ToString(e["VolumeWeight"]),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"].ToString(),
OriginCity = e["CityCode"].ToString(),
DailyFlightSNo = Convert.ToInt32(e["DailyFlightSNo"]), // Daily Flight Sno
Status = e["Status"].ToString(),
isSelect = Convert.ToInt16(e["isSelect"]),
});
//DateTime.ParseExact(e["BookingDate"].ToString(), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
ds.Dispose();
return(new DataSourceResult
{
Data = wmsManifestULDList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string filters = GridFilter.ProcessFilters <InventoryItem>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListInventoryItem", Parameters);
var InventoryItemList = ds.Tables[0].AsEnumerable().Select(e => new InventoryItem
{
SNo = Convert.ToInt32(e["SNo"]),
ItemName = e["ItemName"].ToString().ToUpper(),
//CreatedOn = Convert.ToDateTime(e["CreatedOn"]),
// CreatedBy = Convert.ToString(e["CreatedBy"]),
// UpdatedBy = Convert.ToString(e["UpdatedBy"]),
// UpdatedOn = Convert.ToDateTime(e["UpdatedOn"]),
Active = e["Active"].ToString().ToUpper()
});
ds.Dispose();
return(new DataSourceResult
{
Data = InventoryItemList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString())
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetCTMGridData(GetCTMGridData model, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
//if (filter == null)
//{
// filter = new GridFilter();
// filter.Logic = "AND";
// filter.Filters = new List<GridFilter>();
//}
DataSet ds = new DataSet();
string filters = GridFilter.ProcessFilters <CTMRecord>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@CitySNo", model.CitySNo),
new SqlParameter("@FlightNo", model.FlightNo),
new SqlParameter("@FlightDate", model.FlightDate),
new SqlParameter("@IsBondedWareHouse", model.IsBondedWareHouse),
new SqlParameter("@UserID", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo),
new SqlParameter("@AirportCode", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportCode.ToString())
};
ds = SqlHelper.ExecuteDataset((DMLConnectionString.WebConfigConnectionString), CommandType.StoredProcedure, "spGetCTMDetailsGetList", Parameters);
var CTMList = ds.Tables[0].AsEnumerable().Select(e => new CTMRecord
{
SNo = Convert.ToInt32(e["SNo"]),
AWBSNo = e["AWBSNo"].ToString(),
AWBNo = e["AWBNo"].ToString(),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
Pieces = Convert.ToInt32(e["Pieces"]),
GrossWeight = Convert.ToDecimal(e["GrossWeight"]),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDate"]), DateTimeKind.Utc),
IsPrint = e["ISprint"].ToString(),
AWBTYPE = e["AWBTYPE"].ToString(),
TRANSFERTO = e["TransferTo"].ToString(),
TransferAirportCode = e["TransferAirportCode"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = CTMList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetFWBImportGridData(string searchAirline, string searchFlightNo, string searchAWBNo, string searchFromDate, string searchToDate, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListFWBImportBookingParam";
string filters = GridFilter.ProcessFilters <FWBImportGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@searchAirline", searchAirline), new SqlParameter("@searchFlightNo", searchFlightNo), new SqlParameter("@searchAWBNo", searchAWBNo), new SqlParameter("@searchFromDate", searchFromDate), new SqlParameter("@searchToDate", searchToDate), new SqlParameter("@LoggedInCity", "") };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var FWBImportList = ds.Tables[0].AsEnumerable().Select(e => new FWBImportGridData
{
SNo = Convert.ToInt32(e["SNo"]),
ProcessStatus = Convert.ToString(e["ProcessStatus"]),
DailyFlightSNo = Convert.ToInt64(e["DailyFlightSNo"].ToString() == "" ? 0 : e["DailyFlightSNo"]),
AWBNo = e["AWBNo"].ToString(),
SLINo = e["SLINo"].ToString(),
//AWBDate = e["AWBDate"].ToString() == "" ? "" : Convert.ToDateTime(e["AWBDate"].ToString()).ToString("yyyy/MM/dd"),
AWBDate = e["AWBDate"].ToString(),
ShipmentOrigin = e["ShipmentOrigin"].ToString(),
ShipmentDestination = e["ShipmentDestination"].ToString(),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
Gross = Convert.ToDecimal(e["Gross"].ToString()),
Volume = Convert.ToDecimal(e["Volume"].ToString() == "" ? "0" : e["Volume"].ToString()),
ChWt = Convert.ToDecimal(e["ChWt"].ToString() == "" ? "0" : e["ChWt"].ToString()),
Pcs = Convert.ToInt32(e["Pcs"].ToString() == "" ? "0" : e["Pcs"].ToString()),
FlightNo = e["FlightNo"].ToString(),
//FlightDate = e["FlightDate"].ToString() == "" ? "" : Convert.ToDateTime(e["FlightDate"].ToString()).ToString("yyyy/MM/dd"),
FlightDate = Convert.ToString(e["FlightDate"]),
FlightOrigin = e["FlightOrigin"].ToString(),
FlightDestination = e["FlightDestination"].ToString(),
Status = e["Status"].ToString(),
CommodityCode = e["CommodityCode"].ToString(),
ProductName = e["ProductName"].ToString(),
NoOfHouse = e["NoOfHouse"].ToString(),
AccGrWt = Convert.ToDecimal(e["AccGrWt"].ToString()),
AccVolWt = Convert.ToDecimal(e["AccVolWt"].ToString() == "" ? "0" : e["AccVolWt"].ToString()),
AccPcs = Convert.ToInt32(e["AccPcs"].ToString() == "" ? "0" : e["AccPcs"].ToString()),
Shipper = "",
Consignee = "",
HandlingInfo = "",
XRay = "",
Location = "",
Payment = "",
Dimension = "",
Weight = "",
Reservation = "",
HAWB = "",
ShippingBill = "",
Document = "",
IsWarning = Convert.ToBoolean(e["IsWarning"]),
WarningRemarks = e["WarningRemarks"].ToString(),
//FBLWt = Convert.ToDecimal(e["FBLWt"].ToString() == "" ? "0" : e["FBLWt"].ToString()),
FWBWt = Convert.ToDecimal(e["FWBWt"].ToString() == "" ? "0" : e["FWBWt"].ToString()),
RCSWt = Convert.ToDecimal(e["RCSWt"].ToString() == "" ? "0" : e["RCSWt"].ToString())
});
ds.Dispose();
return(new DataSourceResult
{
Data = FWBImportList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetAirMailDetailsLyingListRecord(string GroupFlightSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "POMailPreManifestLyingListRecord";
string filters = GridFilter.ProcessFilters <AirMail>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@GroupFlightSNo", GroupFlightSNo)
};
ds = SqlHelper.ExecuteDataset((DMLConnectionString.WebConfigConnectionString), CommandType.StoredProcedure, ProcName, Parameters);
var AirMailList = ds.Tables[0].AsEnumerable().Select(e => new AirMailPreManifestRecord
{
SNo = Convert.ToInt32(e["SNo"]),
CN38No = e["CN38No"].ToString(),
FlightNo = e["FlightNo"].ToString(),
FlightDate = Convert.ToDateTime(e["FlightDate"]).ToString("dd-MMM-yyyy"),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
OffPoint = e["OffPoint"].ToString(),
SPHC = e["SPHC"].ToString(),
TotalPieces = Convert.ToInt32(e["TotalPieces"]),
GrossWeight = Convert.ToDecimal(e["GrossWeight"]),
VolumeWeight = Convert.ToDecimal(e["VolumeWeight"]),
ChargeableWeight = Convert.ToDecimal(e["ChargeableWeight"]),
MailCategoryName = e["MailCategoryName"].ToString(),
MHCName = e["MHCName"].ToString(),
ULDNo = e["ULDStockSNo"].ToString(),
TotalDN = Convert.ToInt32(e["TotalDN"]),
IsManifested = e["IsManifested"].ToString(),
CN_ULDNo = e["CN_ULDNo"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = AirMailList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetAirMailChildLyingListRecord(int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
GridFilter filters = new GridFilter();
filters.Logic = "AND";
filters.Filters = new List <GridFilter>();
filters.Filters.Add(filter);
DataSet ds = new DataSet();
ProcName = "POMailLyingListGetList";
string filterValue = GridFilter.ProcessFilters <PreManifestChildRecord>(filters);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filterValue),
new SqlParameter("@OrderBy", sorts),
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var lst = ds.Tables[0].AsEnumerable().Select(e => new PreManifestChildRecord
{
SNo = Convert.ToInt32(e["POMailSNo"]),
TransSNo = Convert.ToInt32(e["TransSNo"]),
DNNo = e["DNNo"].ToString(),
OriCityCode = e["OriCityCode"].ToString(),
DestCityCode = e["DestCityCode"].ToString(),
ReceptacleNumber = e["ReceptacleNumber"].ToString(),
HNRIndicator = e["HNRIndicator"].ToString(),
RIICode = e["RIICode"].ToString(),
ReceptacleWeight = e["ReceptacleWeight"].ToString(),
DNULDNo = e["DNULDStockSNo"].ToString(),
IsManifested = e["IsManifested"].ToString(),
DN_ULDNo = e["DN_ULDNo"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = lst.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filterValue,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetAirMailDetailsGridData(string FlightNo, string FlightDate, string Origin, string Destination, string OffPoint, string FlightStatus, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "POMailPreManifestGetList";
string filters = GridFilter.ProcessFilters <AirMail>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@FlightNo", FlightNo),
new SqlParameter("@FlightDate", FlightDate),
new SqlParameter("@Origin", Origin),
new SqlParameter("@Destination", Destination),
new SqlParameter("@OffPoint", OffPoint),
new SqlParameter("@FlightStatus", FlightStatus),
new SqlParameter("@UserSNo", Convert.ToString(((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo)),
};
ds = SqlHelper.ExecuteDataset((DMLConnectionString.WebConfigConnectionString), CommandType.StoredProcedure, ProcName, Parameters);
var AirMailList = ds.Tables[0].AsEnumerable().Select(e => new AirMailPreManifestGrid
{
GroupFlightSNo = e["GroupFlightSNo"].ToString(),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDate"]), DateTimeKind.Utc),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
OffPoint = e["OffPoint"].ToString(),
FlightStatus = e["FlightStatus"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = AirMailList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetAddShipmentAdjustmentGridData(GetAddShipmentAdjustmentGridFilter model, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "AddShipmentAdjustmentGrid";
string filters = GridFilter.ProcessFilters <AddShipmentAdjustment>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@searchAWBSNo", model.searchAWBSNo),
new SqlParameter("@LoginCitySNo", Convert.ToInt32(((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).CitySNo)),
new SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString())
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var AddShipmentAdjustmentList = ds.Tables[0].AsEnumerable().Select(e => new AddShipmentAdjustment
{
SNo = Convert.ToInt32(e["AWBSNo"]),
AirlineName = e["AirlineName"].ToString(),
AWBNo = e["AWBNo"].ToString(),
AWBOD = e["AWBOD"].ToString(),
AWBPieces = Convert.ToInt32(e["AWBPieces"]),
//S1 = e["S1"].ToString(),
//SP1 = e["SP1"].ToString(),
//S2 = e["S2"].ToString(),
//SP2 = e["SP2"].ToString(),
//S3 = e["S3"].ToString(),
//SP3 = e["SP3"].ToString(),
//S4 = e["S4"].ToString(),
//SP4 = e["SP4"].ToString(),
//S5 = e["S5"].ToString(),
//SP5 = e["SP5"].ToString(),
//Total = e["Total"].ToString(),
//ExtraPieces = e["ExtraPieces"].ToString(),
ProcessStatus = e["Status"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = AddShipmentAdjustmentList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)
{
throw ex;
}
}
public DataSourceResult GetULDMonitoringULDGridData(string ULDNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "getuldhistory";
string filters = GridFilter.ProcessFilters <ULDGridData>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@ULDNo", ULDNo)
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new ULDGridData
{
ULDName = Convert.ToString(e["ULDName"].ToString()),
FlightNo = Convert.ToString(e["FlightNo"].ToString()),
AwbCount = Convert.ToString(e["AWB"].ToString()),
OUTULD = Convert.ToString(e["OUTULD"].ToString())
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
public DataSourceResult GetWMSWaybillGridDataFBL(string OriginCity, string DestinationCity, string FlightNo, string FlightDateSearch, string AWBPrefix, string AWBNo, string LoggedInCity, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
// FlightDate = Convert.ToDateTime(FlightDate, CultureInfo.CurrentCulture).ToString("yyyy/MM/dd");
//FlightDate = e["FlightDate"].ToString() == "" ? "" : Convert.ToDateTime(e["FlightDate"].ToString()).ToString(DateFormat.DateFormatString)
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListWMSBookingParamFBL";
string filters = GridFilter.ProcessFilters <WMSBookingGridDataFBL>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@OriginCity", OriginCity), new SqlParameter("@DestinationCity", DestinationCity), new SqlParameter("@FlightNo", FlightNo), new SqlParameter("@FlightDateSearch", FlightDateSearch), new SqlParameter("@AWBPrefix", AWBPrefix), new SqlParameter("@AWBNo", AWBNo), new SqlParameter("@LoggedInCity", LoggedInCity) /*For Multicity*/, new SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()), new SqlParameter("@IsShowAllData", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).IsShowAllData.ToString()) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new WMSBookingGridDataFBL
{
SNo = Convert.ToInt32(e["SNo"]),
DailyFlightSNo = Convert.ToInt32(e["DailyFlightSNo"].ToString() == "" ? 0 : e["DailyFlightSNo"]),
AWBNo = e["AWBNo"].ToString(),
AWBDate = e["AWBDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["AWBDate"]), DateTimeKind.Utc),
ShipmentOrigin = e["ShipmentOrigin"].ToString(),
ShipmentDestination = e["ShipmentDestination"].ToString(),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
Gross = Convert.ToDecimal(e["Gross"].ToString() == "" ? 0 : e["Gross"]),
Volume = Convert.ToDecimal(e["Volume"].ToString() == "" ? "0" : e["Volume"].ToString()),
ChWt = Convert.ToDecimal(e["ChWt"].ToString() == "" ? "0" : e["ChWt"].ToString()),
Pcs = Convert.ToInt32(e["Pcs"].ToString() == "" ? "0" : e["Pcs"].ToString()),
FlightNo = e["FlightNo"].ToString(),
FlightDateSearch = e["FlightDateSearch"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDateSearch"]), DateTimeKind.Utc),
FlightOrigin = e["FlightOrigin"].ToString(),
FlightDestination = e["FlightDestination"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetGridData(string SearchFlightNo, string FromDate, string ToDate, string SearchDestination, string SearchAirline, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetExportFlightMonitor";
string filters = GridFilter.ProcessFilters <ExportFlightMonitoringModel>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@pAirlineCode", (SearchAirline == "A~A"?"":SearchAirline)),
new SqlParameter("@FromDate", Convert.ToDateTime(FromDate.Replace('_', ':'))),
new SqlParameter("@ToDate", Convert.ToDateTime(ToDate.Replace('_', ':'))),
new SqlParameter("@pFlightNo", (SearchFlightNo == "A~A"?"":SearchFlightNo)),
new SqlParameter("@pAirportCode", (SearchDestination == "A~A"?"":SearchDestination)),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()),
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var lst = ds.Tables[0].AsEnumerable().Select(e => new ExportFlightMonitoringModelGrid
{
SNo = Convert.ToInt32(e["DailyFlightSNo"]),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"].ToString(),
ETD = "",//e["ETD"].ToString(),
LPWeight = e["LPWeight"].ToString() + " / " + e["LPPieces"].ToString(),
ActualBuildUpWeight = e["ActualBuildUpWeight"].ToString(),
BuildCount = e["BuildCount"].ToString(),
DestinationAirportCode = e["DestinationAirportCode"].ToString(),
FWB = e["FWBSuccess"].ToString(),
FOH = e["FOHSuccess"].ToString(),
RCS = e["RCSSuccess"].ToString(),
UWSCutOffMinutes = e["UWSCutOffMins"].ToString(),
UWSSlaMet = e["UWSSlaMet"].ToString(),
UWSTimeDifference = e["UWSTimeDifference"].ToString(),
TimeRemainingToDep = e["TimeRemainingToDep"].ToString(),
GrossWeight = e["GrossWeight"].ToString(),
AirlineName = e["AirlineName"].ToString(),
FWBSLATime = e["FWBSLATime"].ToString(),
FOHSLATime = e["FOHSLATime"].ToString(),
RCSSLATime = e["RCSSLATime"].ToString(),
UWSSLATime = e["UWSSLATime"].ToString(),
FlightStatus = e["FlightStatus"].ToString(),
FBLSLAMet = e["FBLSLAMet"].ToString(),
FBLAwbCount = e["FBLAwbCount"].ToString(),
FBLGross = e["FBLGross"].ToString(),
FBLPcs = e["FBLPcs"].ToString(),
LateCount = e["LateCount"].ToString(),
LateWeightPct = e["LateWeightPct"].ToString(),
FWBRecdCount = e["FWBRecdCount"].ToString(),
FWBRecdPct = e["FWBRecdPct"].ToString(),
FWBSentCount = e["FWBSentCount"].ToString(),
FFMSLATime = e["FFMSLATime"].ToString(),
FFMSLAMet = e["FFMSLAMet"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = lst.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
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", "GetExportFlightMonitor"),
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 DataSourceResult GetDIMSGridDataFBL(string AWBSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetDIMSGridData";
string filters = GridFilter.ProcessFilters <DIMSGridDataFBL>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@AWBSNo", AWBSNo) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var DIMSGridDataFBLList = ds.Tables[0].AsEnumerable().Select(e => new DIMSGridDataFBL
{
Pieces = e["NOP"].ToString() == "" ? 0 : Convert.ToInt32(e["NOP"]),
Weight = e["Weight"].ToString() == "" ? 0 : Convert.ToDecimal(e["Weight"]),
Length = e["Length"].ToString() == "" ? 0 : Convert.ToDecimal(e["Length"]),
Width = e["Width"].ToString() == "" ? 0 : Convert.ToDecimal(e["Width"]),
Height = e["Height"].ToString() == "" ? 0 : Convert.ToDecimal(e["Height"]),
cms = e["Meas_Unit"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = DIMSGridDataFBLList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetTransitFWBGridData(BookingGetTranistFWBGrid model, string PageName, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListTransitFWB";
string filters = GridFilter.ProcessFilters <WMSBookingGridData>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters.Replace("FlightDate", "FlightDateSearch").Replace("AWBDate", "AWBDateSearch")),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@OriginCity", model.OriginCity),
new SqlParameter("@DestinationCity", model.DestinationCity),
new SqlParameter("@FlightNo", model.FlightNo),
new SqlParameter("@FlightDate", model.FlightDate),
new SqlParameter("@AWBPrefix", model.AWBPrefix),
new SqlParameter("@AWBNo", model.AWBNo),
new SqlParameter("@LoggedInCity", model.LoggedInCity),
new SqlParameter("@LoggedInAirport", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportSNo.ToString()),
/*For MultCity */ new SqlParameter("@IsShowAllData", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).IsShowAllData.ToString()),/*For MultCity */
new SqlParameter("@IsSLI", "0"),
new SqlParameter("@MovementType", "0")
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new WMSBookingGridData
{
SNo = Convert.ToInt32(e["SNo"]),
ProcessStatus = Convert.ToString(e["ProcessStatus"]),
DailyFlightSNo = Convert.ToInt64(e["DailyFlightSNo"].ToString() == "" ? 0 : e["DailyFlightSNo"]),
AWBNo = e["AWBNo"].ToString(),
SLINo = e["SLINo"].ToString(),
AWBDate = e["AWBDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["AWBDate"]), DateTimeKind.Utc),
ShipmentOrigin = e["ShipmentOrigin"].ToString(),
ShipmentDestination = e["ShipmentDestination"].ToString(),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
Gross = Convert.ToDecimal(e["Gross"].ToString()),
Volume = Convert.ToDecimal(e["Volume"].ToString() == "" ? "0" : e["Volume"].ToString()),
ChWt = Convert.ToDecimal(e["ChWt"].ToString() == "" ? "0" : e["ChWt"].ToString()),
Pcs = Convert.ToInt32(e["Pcs"].ToString() == "" ? "0" : e["Pcs"].ToString()),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDate"]), DateTimeKind.Utc),
FlightOrigin = e["FlightOrigin"].ToString(),
FlightDestination = e["FlightDestination"].ToString(),
Status = e["Status"].ToString(),
CommodityCode = e["CommodityCode"].ToString(),
ProductName = e["ProductName"].ToString(),
NoOfHouse = e["NoOfHouse"].ToString(),
AccGrWt = Convert.ToDecimal(e["AccGrWt"].ToString()),
AccVolWt = Convert.ToDecimal(e["AccVolWt"].ToString() == "" ? "0" : e["AccVolWt"].ToString()),
AccPcs = Convert.ToInt32(e["AccPcs"].ToString() == "" ? "0" : e["AccPcs"].ToString()),
Shipper = "",
Consignee = "",
HandlingInfo = "",
XRay = "",
Location = "",
Payment = "",
Dimension = "",
Weight = "",
Reservation = "",
HAWB = "",
ShippingBill = "",
Document = "",
IsWarning = Convert.ToBoolean(e["IsWarning"]),
WarningRemarks = e["WarningRemarks"].ToString(),
FBLWt = Convert.ToDecimal(e["FBLWt"].ToString() == "" ? "0" : e["FBLWt"].ToString()),
FWBWt = Convert.ToDecimal(e["FWBWt"].ToString() == "" ? "0" : e["FWBWt"].ToString()),
RCSWt = Convert.ToDecimal(e["RCSWt"].ToString() == "" ? "0" : e["RCSWt"].ToString()),
SPHC = e["SPHC"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetMULDShipmentGridData(String FlightNo, String FlightDate, string CurrentProcessSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetMULDShipmentChild_RampOffload";
string filters = GridFilter.ProcessFilters <ManifestShipment>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@FlightNo", FlightNo),
new SqlParameter("@FlightDate", FlightDate),
new SqlParameter("@CurrentProcessSNo", CurrentProcessSNo),
new SqlParameter("@LoggedAirport", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportCode.ToString())
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsManifestShipList = ds.Tables[0].AsEnumerable().Select(e => new ManifestShipment
{
AWBSNo = Convert.ToInt64(e["AWBSNo"]),
AWBNo = Convert.ToString(e["AWBNo"]),
AWBSector = Convert.ToString(e["AWBSector"]),
TotalPieces = Convert.ToDecimal(e["TotalPieces"]),
PlannedPieces = Convert.ToInt64(e["PlannedPieces"]),
Act_G_V = e["Act_G_V"].ToString(),
Plan_G_V = e["Plan_G_V"].ToString(),
Status = e["Status"].ToString(),
ULDStockSNo = Convert.ToInt32(e["ULDStockSNo"]),
DailyFlightSNo = Convert.ToInt64(e["DailyFlightSNo"]),
PG = Convert.ToDecimal(e["PG"]),
PV = Convert.ToDecimal(e["PV"]),
PGW = Convert.ToDecimal(e["PGW"]),
PVW = Convert.ToDecimal(e["PVW"]),
IsBulk = Convert.ToInt16(e["IsBulk"]),
TotalPPcs = Convert.ToInt64(e["PlannedPieces"]),
Location = Convert.ToInt32(e["Location"]),
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsManifestShipList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetWMSWaybillGridData(string OriginCity, String DestinationCity, String FlightNo, string FlightDate, string AWBPrefix, string AWBNo, string LoggedInCity, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
// FlightDate = Convert.ToDateTime(FlightDate, CultureInfo.CurrentCulture).ToString("yyyy/MM/dd");
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListWMSBookingParam";
string filters = GridFilter.ProcessFilters <WMSBookingGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters.Replace("FlightDate", "FlightDateSearch").Replace("AWBDate", "AWBDateSearch")), new SqlParameter("@OrderBy", sorts), new SqlParameter("@OriginCity", OriginCity), new SqlParameter("@DestinationCity", DestinationCity), new SqlParameter("@FlightNo", FlightNo), new SqlParameter("@FlightDate", FlightDate), new SqlParameter("@AWBPrefix", AWBPrefix), new SqlParameter("@AWBNo", AWBNo), new SqlParameter("@LoggedInCity", LoggedInCity), new SqlParameter("@LoggedInAirport", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AirportSNo.ToString()), new SqlParameter("@UserSno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()), new SqlParameter("@IsSLI", "1") };
//SqlDataReader dr = SqlHelper.ExecuteReader(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new WMSBookingGridData
{
SNo = Convert.ToInt32(e["SNo"]),
ProcessStatus = Convert.ToString(e["ProcessStatus"]),
DailyFlightSNo = Convert.ToInt64(e["DailyFlightSNo"].ToString() == "" ? 0 : e["DailyFlightSNo"]),
AWBNo = e["AWBNo"].ToString(),
SLINo = e["SLINo"].ToString(),
SLIStatus = e["SLIStatus"].ToString(),
AWBDate = e["AWBDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["AWBDate"]), DateTimeKind.Utc),
ShipmentOrigin = e["ShipmentOrigin"].ToString(),
ShipmentDestination = e["ShipmentDestination"].ToString(),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
Gross = Convert.ToDecimal(e["Gross"].ToString()),
Volume = Convert.ToDecimal(e["Volume"].ToString() == "" ? "0" : e["Volume"].ToString()),
//ChWt = Convert.ToDecimal(e["ChWt"].ToString() == "" ? "0" : e["ChWt"].ToString()),
Pcs = Convert.ToInt32(e["Pcs"].ToString() == "" ? "0" : e["Pcs"].ToString()),
FWBPCSWT = e["FWBPCSWT"].ToString(),
SLIPCSWT = e["SLIPCSWT"].ToString(),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDate"]), DateTimeKind.Utc),
FlightOrigin = e["FlightOrigin"].ToString(),
FlightDestination = e["FlightDestination"].ToString(),
Status = e["Status"].ToString(),
CommodityCode = e["CommodityCode"].ToString(),
ProductName = e["ProductName"].ToString(),
NoOfHouse = e["NoOfHouse"].ToString(),
AccGrWt = Convert.ToDecimal(e["AccGrWt"].ToString()),
AccVolWt = Convert.ToDecimal(e["AccVolWt"].ToString() == "" ? "0" : e["AccVolWt"].ToString()),
AccPcs = Convert.ToInt32(e["AccPcs"].ToString() == "" ? "0" : e["AccPcs"].ToString()),
Shipper = "",
Consignee = "",
HandlingInfo = "",
XRay = "",
Location = "",
Payment = "",
Dimension = "",
Weight = "",
Reservation = "",
HAWB = "",
ShippingBill = "",
Document = "",
IsWarning = Convert.ToBoolean(e["IsWarning"]),
WarningRemarks = e["WarningRemarks"].ToString(),
FBLWt = Convert.ToDecimal(e["FBLWt"].ToString() == "" ? "0" : e["FBLWt"].ToString()), // Added by RH 12-08-15
FWBWt = Convert.ToDecimal(e["FWBWt"].ToString() == "" ? "0" : e["FWBWt"].ToString()), // Added by RH 12-08-15
RCSWt = Convert.ToDecimal(e["RCSWt"].ToString() == "" ? "0" : e["RCSWt"].ToString()), // Added by RH 12-08-15
SPHC = e["SPHC"].ToString(),
IsDirectAcceptance = e["IsDirectAcceptance"].ToString(),
AdviceCode = e["AdviceCode"].ToString(),
TerminalName = e["TerminalName"].ToString(),
TransactionType = e["TransactionType"].ToString(),
InternationalORDomestic = e["InternationalORDomestic"].ToString(),
AccountTypeSNo = e["AccountTypeSNo"].ToString(),
OriginAirportCode = e["OriginAirportCode"].ToString(),
DestinationAirportCode = e["DestinationAirportCode"].ToString(),
LateAWBHoldSNo = e["LateAWBHoldSNo"].ToString(),
IsApprovedLateAWBHold = e["IsApprovedLateAWBHold"].ToString(),
SLISNo = Convert.ToInt32(e["SLISNo"].ToString() == "" ? "0" : e["SLISNo"].ToString()),
ETD = e["ETD"].ToString(),
ETA = e["ETA"].ToString(),
RECEIPTSNO = e["RECEIPTSNO"].ToString(),
WOSNO = e["WOSNO"].ToString(),
INVOICESNO = e["INVOICESNO"].ToString(),
AgentName = e["AgentName"].ToString(),
AcceptanceTime = e["AcceptanceTime"].ToString(),
AcceptanceDate = e["AcceptanceDate"].ToString(),
Userid = ((Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString(),
UserName = ((Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserName.ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetWMSWaybillGridDataFBL(string AWBNumber, string OriginCity, string DestinationCity, string FlightNo, string FlightDateSearch, string LoggedInCity, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListNonExecutedBooking";
string filters = GridFilter.ProcessFilters <NonExecutedBooking>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@AWBNumber", AWBNumber), new SqlParameter("@OriginCity", OriginCity), new SqlParameter("@DestinationCity", DestinationCity), new SqlParameter("@FlightNo", FlightNo), new SqlParameter("@FlightDateSearch", FlightDateSearch), new SqlParameter("@LoggedInCity", LoggedInCity) /*For Multicity*/, new SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new NonExecutedBooking
{
SNo = Convert.ToInt32(e["SNo"]),
AWBNo = Convert.ToString(e["AWBNo"].ToString()),
OriginCity = Convert.ToString(e["OriginCity"]),
DestinationCity = Convert.ToString(e["DestinationCity"]),
FlightNo = Convert.ToString(e["FlightNo"].ToString()),
FlightDate = e["FlightDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDate"]), DateTimeKind.Utc),
//FlightDate = Convert.ToString(e["FlightDate"]),
FFMDetail = Convert.ToString(e["FFMDetail"]),
//ProcessStatus = ",FreightBookingListSendFBL_"+Convert.ToString(e["EnableSENDFBL"]) + ",FreightBookingListPRINTFBL_" + Convert.ToString(e["EnablePRINT"]) + ",FreightBookingListVersion_" + Convert.ToString(e["EnableVERSION"])
// ProcessStatus = Convert.ToString(e["EnableSENDFBL"]) + ',' + Convert.ToString(e["EnablePRINT"]) + ',' + Convert.ToString(e["EnableVERSION"])
//EnableSENDFBL = Convert.ToString(e["EnableSENDFBL"]),
//EnablePRINT = Convert.ToString(e["EnablePRINT"]),
//EnableVERSION = Convert.ToString(e["EnableVERSION"])
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
public DataSourceResult GetWMSHAWBGridData(string AWBSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListWMSHAWB";
string filters = GridFilter.ProcessFilters <WMSHAWBGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@AWBSNo", AWBSNo) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new WMSHAWBGridData
{
SNo = Convert.ToInt32(e["SNo"]),
HAWBNo = e["HAWBNo"].ToString(),
OriginCity = e["OriginCity"].ToString(),
DestinationCity = e["DestinationCity"].ToString(),
GrossWeight = Convert.ToDecimal(e["GrossWeight"].ToString() == "" ? "0" : e["GrossWeight"].ToString()),
VolumeWeight = Convert.ToDecimal(e["VolumeWeight"].ToString() == "" ? "0" : e["VolumeWeight"].ToString()),
Pieces = Convert.ToInt32(e["Pieces"].ToString() == "" ? "0" : e["Pieces"].ToString())
});
//DateTime.ParseExact(e["BookingDate"].ToString(), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetHouseCheckListGridData(string HAWBSNo, string CheckListTypeSNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetListHouseCheckList";
string filters = GridFilter.ProcessFilters <HouseCheckListGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@HAWBSNo", HAWBSNo), new SqlParameter("@CheckListTypeSNo", CheckListTypeSNo) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new HouseCheckListGridData
{
SNo = Convert.ToInt32(e["SNo"]),
SrNo = e["SrNo"].ToString(),
Description = e["Description"].ToString(),
Y = e["Y"].ToString(),
N = e["N"].ToString(),
NA = e["NA"].ToString()
});
//DateTime.ParseExact(e["BookingDate"].ToString(), "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture)
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
//-- RH 030815 starts
public DataSourceResult GetEDIGridData(string AWBNo, string FlightNo, string FlightDate, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetEDIIMessageForAWB";
string filters = GridFilter.ProcessFilters <WMSShippingBillGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@AWBNo", AWBNo), new SqlParameter("@FlightNo", FlightNo), new SqlParameter("@FlightDate", FlightDate) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new WMSEDIGridData
{
CarrierCode = e["CarrierCode"].ToString(),
MessageType = e["MessageType"].ToString(),
GeneratedXml = e["GeneratedXml"].ToString(),
AWBNo = e["AWBNo"].ToString(),
FlightNo = e["FlightNo"].ToString(),
FlightOrigin = e["FlightOrigin"].ToString(),
FlightDestination = e["FlightDestination"].ToString(),
FlightDate = e["FlightDate"].ToString(),
SentAddress = e["SentAddress"].ToString(),
UpdatedOn = e["UpdatedOn"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
public SoftwareFactory.Data.DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string filters = GridFilter.ProcessFilters <InvVehicle>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListInvVehicle", Parameters);
var InventoryVehTypeList = ds.Tables[0].AsEnumerable().Select(e => new InvVehicle
{
SNo = Convert.ToInt32(e["SNo"]),
Text_VehicleTypeSNo = e["Text_VehicleType"].ToString().ToUpper(),
ManufactureDate = DateTime.Parse(e["ManufactureDate"].ToString()),
EngineNo = e["EngineNo"].ToString().ToUpper(),
ChasisNo = e["ChasisNo"].ToString().ToUpper(),
RegistrationNo = e["RegistrationNo"].ToString().ToUpper(),
DateofPurchase = DateTime.Parse(e["DateofPurchase"].ToString()),
VehicleType = e["VehicleType"].ToString().ToUpper(),
PurchasedFrom = e["PurchasedFrom"].ToString().ToUpper(),
CostOfVehicle = Convert.ToDecimal(e["CostOfVehicle"]),
CityCode = e["CityCode"].ToString().ToUpper(),
IsActive = Convert.ToBoolean(e["IsActive"])
});
ds.Dispose();
return(new DataSourceResult
{
Data = InventoryVehTypeList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString())
});
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult FHLGridData(string searchAirline, string searchFlightNo, string searchAWBNo, string searchFromDate, string searchToDate, string SearchIncludeTransitAWB, string SearchExcludeDeliveredAWB, string searchSPHC, string searchConsignee, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "FHLExportGridData";
string filters = GridFilter.ProcessFilters <FHLExport>(filter);
//SqlParameter[] Parameters = {
// //Convert.ToDateTime(ds.Tables[0].Rows[0]["FlightDate"]).ToString("dd-MMM-yy")
// new SqlParameter("@PageNo", page),
// new SqlParameter("@PageSize", pageSize),
// new SqlParameter("@WhereCondition", filters + ( Convert.ToDateTime(searchFromDate).ToString("dd-MMM-yy") != "0" ? " FlightDate>='" + Convert.ToDateTime(searchFromDate).ToString("dd-MMM-yy") + "'" : string.Empty) + (Convert.ToDateTime(searchToDate).ToString("dd-MMM-yy") != "0" ? (Convert.ToDateTime(searchFromDate).ToString("dd-MMM-yy") != "0" ? " AND FlightDate<='" + Convert.ToDateTime(searchToDate).ToString("dd-MMM-yy") + "'" : " FlightDate<='" +Convert.ToDateTime(searchToDate).ToString("dd-MMM-yy") + "'") : string.Empty)),
// new SqlParameter("@OrderBy", sorts),
// new SqlParameter("@searchAirline", searchAirline),
// new SqlParameter("@searchFlightNo", searchFlightNo),
// new SqlParameter("@searchAWBNo", searchAWBNo),
// new SqlParameter("@searchFromDate", searchFromDate),
// new SqlParameter("@searchToDate", searchToDate),
// new SqlParameter("@SearchIncludeTransitAWB", SearchIncludeTransitAWB),
// new SqlParameter("@SearchExcludeDeliveredAWB", SearchExcludeDeliveredAWB),
// new SqlParameter("@LoggedInCity", ""),
// new SqlParameter("@searchSPHC", ""),
// new SqlParameter("@searchConsignee", "")
// };
int accountsno = Convert.ToInt32(((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).AgentSNo.ToString());
int OfficeSNo = Convert.ToInt32(((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).OfficeSNo.ToString());
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@searchAirline", searchAirline),
new SqlParameter("@searchFlightNo", searchFlightNo),
new SqlParameter("@searchAWBNo", searchAWBNo),
new SqlParameter("@searchFromDate", searchFromDate),
new SqlParameter("@searchToDate", searchToDate),
new SqlParameter("@SearchIncludeTransitAWB", SearchIncludeTransitAWB),
new SqlParameter("@SearchExcludeDeliveredAWB", SearchExcludeDeliveredAWB),
new SqlParameter("@LoggedInCity", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).CityCode.ToString()),
new SqlParameter("@searchSPHC", ""),
new SqlParameter("@searchConsignee", "0"),
new SqlParameter("@AccountSNo", accountsno),
new SqlParameter("@OfficeSNo", OfficeSNo)
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var DeliveryOrderList = ds.Tables[0].AsEnumerable().Select(e => new FHLExport
{
SNo = Convert.ToInt32(e["SNo"]),
// DailyFlightSNo = Convert.ToInt32(e["DailyFlightSNo"]),
//Airline = e["Airline"].ToString(),
FlightNo = e["FlightNo"].ToString(),
FlightDate = e["FlightDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["FlightDate"]), DateTimeKind.Utc),
AWBNo = e["AWBNo"].ToString(),
//SLINo = e["SLINo"].ToString(),
Origin = e["Origin"].ToString(),
Destination = e["Destination"].ToString(),
Pcs = Convert.ToInt16(e["Pcs"]),
//ArrivedShipmentSNo = Convert.ToInt32(e["ArrivedShipmentSNo"]),
//ATA = e["ATA"].ToString(),
ProcessStatus = e["ProcessStatus"].ToString(),
//ProcessStatus = e["Status"].ToString(),
//EnteredType = e["EnteredType"].ToString(),
});
ds.Dispose();
return(new DataSourceResult
{
Data = DeliveryOrderList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex) //
{
throw ex;
}
}
public DataSourceResult GetGridData(string SearchFlightNo, string FromDate, string ToDate, string SearchOriginCity, string SearchAirline, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GetimportFlightMonitor";
string filters = GridFilter.ProcessFilters <ImportFlightMonitoringModelGrid>(filter);
SqlParameter[] Parameters =
{
new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@WhereCondition", filters),
new SqlParameter("@OrderBy", sorts),
new SqlParameter("@pAirlineCode", (SearchAirline == "A~A"?"":SearchAirline)),
new SqlParameter("@FromDate", Convert.ToDateTime(FromDate.Replace('_', ':'))),
new SqlParameter("@ToDate", Convert.ToDateTime(ToDate.Replace('_', ':'))),
new SqlParameter("@pFlightNo", (SearchFlightNo == "A~A"?"":SearchFlightNo)),
new SqlParameter("@pAirportCode", (SearchOriginCity == "A~A"?"":SearchOriginCity)),
new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()),
};
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var lst = ds.Tables[0].AsEnumerable().Select(e => new ImportFlightMonitoringModelGrid
{
SNo = Convert.ToInt32(e["DailyFlightSNo"]),
FlightNo = e["FlightNo"].ToString(),
OriginAirportCode = e["OriginAirportCode"].ToString(),
FlightDate = e["FlightDate"].ToString(),
FlightETADate = e["FlightETADate"].ToString(),
FFMSLATime = e["FFMSLATime"].ToString(),
ULDBreak = e["ULDBreak"].ToString(),
FFMArrLocPcCount = e["FFMArrLocPcCount"].ToString(),
LocationPercent = e["LocationPercent"].ToString(),
SHCQRTDGR = e["SHCQRTDGR"].ToString(),
RCFSLATime = e["RCFSLATime"].ToString(),
NFDSLATime = e["NFDSLATime"].ToString(),
ARRSLATime = e["ARRSLATime"].ToString(),
FFMSLAMet = e["FFMSLAMet"].ToString(),
DLVSLATime = e["DLVSLATime"].ToString(),
DLVSuccess = e["DLVSuccess"].ToString(),
AirlineName = e["AirlineName"].ToString(),
FFMPc = e["FFMPc"].ToString(),
FlightCapacity = e["FlightCapacity"].ToString(),
FFMWT = e["FFMWT"].ToString(),
NFDSuccess = e["NFDSuccess"].ToString(),
ARRSuccess = e["ARRSuccess"].ToString(),
RCFSuccess = e["RCFSuccess"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = lst.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
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", "GetimportFlightMonitor "),
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 DataSourceResult GeSpecialCargoGridData(string SpecialCargoType, string SpecialCargoNo, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "GeSpecialCargoGridData";
string filters = GridFilter.ProcessFilters <SpecialCargo>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@SpecialCargoType", SpecialCargoType), new SqlParameter("@SpecialCargoNo", SpecialCargoNo) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var SpecialCargoList = ds.Tables[0].AsEnumerable().Select(e => new SpecialCargo
{
SNo = Convert.ToInt32(e["SNo"]),
SpecialCargoType = e["SpecialCargoType"].ToString(),
SpecialCargoNo = e["SpecialCargoNo"].ToString(),
Remarks = e["Remarks"].ToString(),
IsDoc = Convert.ToBoolean(e["IsDoc"].ToString()),
CreatedBy = e["CreatedBy"].ToString(),
CreatedOn = e["CreatedOn"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["CreatedOn"]), DateTimeKind.Utc)
});
ds.Dispose();
return(new DataSourceResult
{
Data = SpecialCargoList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw new System.ServiceModel.Web.WebFaultException <string>("Bad Request.", HttpStatusCode.BadRequest);
}
}
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string filters = GridFilter.ProcessFilters <LUCOutGrid>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts) };
DataSet ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "LUC_GetGridRecord", Parameters);
var obj = ds.Tables[0].AsEnumerable().Select(e => new LUCOutGrid
{
SNo = e["SNo"].ToString(),
ULDNumber = e["ULDNumber"].ToString(),
ULDCode = e["ULDCode"].ToString(),
OwnerCode = e["OwnerCode"].ToString(),
ULDDate = DateTime.SpecifyKind(Convert.ToDateTime(e["ULDDate"]), DateTimeKind.Utc),
ULDTime = e["ULDTime"].ToString(),
UserName = e["UserName"].ToString(),
ReceivedByCityCode = e["ReceivedByCityCode"].ToString().ToUpper(),
AirportName = e["AirportName"].ToString(),
FinalDestination = e["FinalDestination"].ToString(),
DAM = e["DAM"].ToString(),
UHFReceiptNo = e["UHFReceiptNo"].ToString(),
UCRReceiptNo = e["UCRReceiptNo"].ToString(),
SentLUC = e["SentLUC"].ToString(),
IssuedTo = Convert.ToInt32(e["IssuedTo"]),
ULDCount = Convert.ToInt32(e["ULDCount"]),
IsESS = Convert.ToBoolean(e["IsESS"]),
IsAL = Convert.ToBoolean(e["IsAL"]),
IsUCR = Convert.ToBoolean(e["IsUCR"]),
IsPayment = Convert.ToBoolean(e["IsPayment"]),
});
ds.Dispose();
var res = new DataSourceResult {
Data = obj.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString())
};
return(res);
}
catch (Exception ex)//
{
throw ex;
}
}
public DataSourceResult GetFlightArrivalULDGridData(string DailyFlightSno, int skip, int take, int page, int pageSize, List <SoftwareFactory.Data.GridSort> sort, SoftwareFactory.Data.GridFilter filter)
{
try
{
string sorts = GridSort.ProcessSorting(sort);
string ProcName = "";
if (filter == null)
{
filter = new GridFilter();
filter.Logic = "AND";
filter.Filters = new List <GridFilter>();
}
DataSet ds = new DataSet();
ProcName = "FA_GetFlightArrivalULDGridData";
string filters = GridFilter.ProcessFilters <WMSFlightArrivalULDGridData>(filter);
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@DailyFlightSno", DailyFlightSno) };
ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, ProcName, Parameters);
var wmsBookingList = ds.Tables[0].AsEnumerable().Select(e => new WMSFlightArrivalULDGridData
{
DailyFlightSNo = Convert.ToInt32(e["DailyFlightSNo"]),
ULDNo = e["ULDNo"].ToString(),
BUP = e["BUP"].ToString(),
TotalPieces = e["TotalPieces"].ToString(),
TotalGrossWeight = e["TotalGrossWeight"].ToString(),// Convert.ToDecimal(e["TotalGrossWeight"].ToString() == "" ? "0" : e["TotalGrossWeight"].ToString()),
Transit = e["Transit"].ToString(),
CleanLoad = e["CleanLoad"].ToString(),
SPHC = e["SPHC"].ToString(),
BreakDownStart = e["BreakDownStart"].ToString(),
BreakDownEnd = e["BreakDownEnd"].ToString()
});
ds.Dispose();
return(new DataSourceResult
{
Data = wmsBookingList.AsQueryable().ToList(),
Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()),
FilterCondition = filters,
SortCondition = sorts,
StoredProcedure = ProcName
});
}
catch (Exception ex)//
{
throw ex;
}
}
