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; } }