/// <summary> /// Get the list of records to be shown n the database /// </summary> /// <param name="skip">no. of records to be Skipped</param> /// <param name="take">no. of records to be Retrieved</param> /// <param name="page">page no</param> /// <param name="pageSize">size of the page i.e. No of record to be displayed at once</param> /// <param name="sort">column no according to which records are to be Ordered</param> /// <param name="filter">values/parameter according to which record are to be Filtered</param> /// <returns></returns> public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <RateGlobalDueCarrier>(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, "GetListRateGlobalDueCarrier", Parameters); var RateGlobalDueCarrierList = ds.Tables[0].AsEnumerable().Select(e => new RateGlobalDueCarrier { SNo = Convert.ToInt32(e["SNo"]), Airline = Convert.ToString(e["Airline"]), OriginAirPort = Convert.ToString(e["OriginAirPort"]), DestinationAirPort = Convert.ToString(e["DestinationAirport"]), OriginCountry = Convert.ToString(e["OriginCountry"]), DestinationCountry = Convert.ToString(e["DestinationCountry"]), OriginIATA = Convert.ToString(e["OriginIATA"]), DestinationIATA = Convert.ToString(e["DestinationIATA"]), Active = Convert.ToString(e["Active"]), }); ds.Dispose(); return(new DataSourceResult { Data = RateGlobalDueCarrierList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <IrregularityStatus>(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, "GetListIrregularityStatus", Parameters); var IrregularityStatusList = ds.Tables[0].AsEnumerable().Select(e => new IrregularityStatus { SNo = Convert.ToInt32(e["SNo"]), Status = e["Status"].ToString().ToUpper(), IsActive = Convert.ToBoolean(e["IsActive"]), Active = e["Active"].ToString().ToUpper(), //CreatedBy = e["CreatedBy"].ToString(), //CreatedOn = e["CreatedOn"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = IrregularityStatusList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } 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 <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <Ledger>(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, "GetListLedger", Parameters); var LedgerList = ds.Tables[0].AsEnumerable().Select(e => new Ledger { SNo = Convert.ToInt32(e["SNo"]), LedgerCode = e["LedgerCode"].ToString().ToUpper(), LedgerName = e["LedgerName"].ToString().ToUpper(), Payable = Convert.ToString(e["Payable"]), }); ds.Dispose(); return(new DataSourceResult { Data = LedgerList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)//(Exception ex) { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <FlightGridData>(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, "GetListFlightTransfer", Parameters); var FTList = ds.Tables[0].AsEnumerable().Select(e => new FlightGridData { FlightNo = e["FlightNo"].ToString().ToUpper(), FlightDate = e["FlightDate"].ToString().ToUpper(), ETDETA = e["ETDETA"].ToString().ToUpper(), Origin = e["Origin"].ToString(), Dest = e["Dest"].ToString(), Atype = e["Atype"].ToString(), Route = e["Route"].ToString(), TCapacity = e["TCapacity"].ToString().ToUpper(), ACapacity = e["ACapacity"].ToString(), UCapacity = e["UCapacity"].ToString(), FStatus = e["FStatus"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = FTList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { int UserSNo = CustomizedGrid.UserSNo; string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <UserGroup>(filter); // Change by akash bcz filter is not getting due to wrong class SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@UserSNo", UserSNo) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListUserGroup", Parameters); var pageList = ds.Tables[0].AsEnumerable().Select(e => new UserGroup { //MSNo = Convert.ToInt32(e["MSNo"]), SNo = Convert.ToInt32(e["SNo"]), UserName = e["UserName"].ToString(), GroupName = e["GroupName"].ToString(), UserSNo = Convert.ToInt32(e["UserSNo"].ToString()), GroupSNo = Convert.ToInt32(e["GroupSNo"].ToString()) }); ds.Dispose(); return(new DataSourceResult { Data = pageList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); }
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 GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <ApprovePaymentGridData>(filter); SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) }; DataSet ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListVerifyPayment", Parameters); var TaxRateList = ds.Tables[0].AsEnumerable().Select(e => new ApprovePaymentGridData { SNo = Convert.ToString(e["SNo"]), OfficeSNo = Convert.ToInt32(e["OfficeSNo"]), Office = e["Office"].ToString().ToUpper(), Agent = Convert.ToString(e["Agent"]).ToUpper(), Credit = Convert.ToString(e["Credit"]), Amount = Convert.ToString(e["Amount"]), UpdateType = Convert.ToString(e["UpdateType"]), Transaction = Convert.ToString(e["Transaction"]), RefNo = e["RefNo"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = TaxRateList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)//(Exception ex) { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <HoldType>(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, "GetListHoldType", Parameters); var HoldTypeList = ds.Tables[0].AsEnumerable().Select(e => new HoldType { SNo = Convert.ToInt32(e["SNo"]), Hold_Type = e["Hold_Type"].ToString().ToUpper(), HoldTypeCode = e["HoldTypeCode"].ToString().ToUpper(), AutoHold = e["AutoHold"].ToString(), HoldMessage = e["HoldMessage"].ToString().ToUpper(), UnHoldMessage = e["UnHoldMessage"].ToString().ToUpper(), RestrictChangeFinalization = e["RestrictChangeFinalization"].ToString().ToUpper(), Active = e["Active"].ToString().ToUpper(), Text_IsAutoUnhold = e["Text_IsAutoUnhold"].ToString().ToUpper(), }); ds.Dispose(); return(new DataSourceResult { Data = HoldTypeList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetOfficeData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <CargoFlash.Cargo.Model.Stock.AWBStockStatus>(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, "sp_AwbStockStatus_GetOfficeRecord", Parameters); var CommodityList = ds.Tables[0].AsEnumerable().Select(e => new CargoFlash.Cargo.Model.Stock.AWBStockStatus { CitySNo = Convert.ToInt32(e["CitySNo"].ToString()), Name = e["Name"].ToString().ToUpper(), TotalStockIssued = Convert.ToInt32(e["TotalStockIssued"]), StockUnused = Convert.ToInt32(e["StockUnused"]), StockIssuedToOffice = Convert.ToInt32(e["StockIssuedToOffice"]) }); ds.Dispose(); return(new DataSourceResult { Data = CommodityList.AsQueryable().ToList(), //Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <SummaryReport>(filter); SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@LoginUserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListSummaryReport", Parameters); var SummaryList = ds.Tables[0].AsEnumerable().Select(e => new SummaryReport { SNo = Convert.ToInt32(e["SNo"]), CashierId = e["CashierId"].ToString().ToUpper(), CashierName = e["CashierName"].ToString(), CashRegisterDate = e["CashRegisterDate"].ToString() == String.Empty ? "" : DateTime.Parse(e["CashRegisterDate"].ToString()).ToString("dd-MMM-yyyy"), StartSession = e["StartSession"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["StartSession"]), DateTimeKind.Utc), EndSession = e["EndSession"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["EndSession"]), DateTimeKind.Utc), Startbalance = e["Startbalance"].ToString().ToUpper(), ClosingBalance = e["ClosingBalance"].ToString().ToUpper(), ShiftStart = e["StartShift"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["StartShift"]), DateTimeKind.Utc), ShiftEnd = e["EndShift"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["EndShift"]), DateTimeKind.Utc), CashierIDGroupSNo = e["CashierIDGroupSNo"].ToString(), cashregisterSNo = e["cashregisterSNo"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = SummaryList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)//(Exception ex) { throw ex; } }
/// <summary> /// Get list of the records to be shown in the grid /// </summary> /// <param name="skip">nos. of records to be Skipped</param> /// <param name="take">nos. of records to be Retrieved</param> /// <param name="page">page no</param> /// <param name="pageSize">Size of the page i.e. No of record to be displayed</param> /// <param name="sort">column no according to which records to be ordered</param> /// <param name="filter">values/parameter According to which record are filtered</param> /// <returns>List of the records</returns> public DataSourceResult GetGridData(int skip, int take, int page, int pagesize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <CityConnectionTime>(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, "GetListAirlineTimeZone", Parameters); var AirlineTimeZoneList = ds.Tables[0].AsEnumerable().Select(e => new AirlineTimeZone { SNo = Convert.ToInt32(e["SNo"].ToString()), TimeZoneName = e["TimeZoneName"].ToString().ToUpper(), TimeDifference = Convert.ToInt32(e["TimeDifference"]), prefix = Convert.ToString(e["Prefix"]), Hour = Convert.ToInt32(e["Hour"]), Minute = Convert.ToInt32(e["Minute"]), UpdatedBy = e["UpdatedBy"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = AirlineTimeZoneList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
// get data in grid public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <ApplicationEntityGrid>(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, "GetApplicationEntityList", Parameters); var ApplicationEntityList = ds.Tables[0].AsEnumerable().Select(e => new ApplicationEntityGrid { SNo = Convert.ToInt32(e["SNo"]), ApplicationCode = e["ApplicationCode"].ToString(), ApplicationName = e["ApplicationName"].ToString(), Remarks = e["Remarks"].ToString(), IsActive = e["IsActive"].ToString().ToString() }); ds.Dispose(); return(new DataSourceResult { Data = ApplicationEntityList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()), FilterCondition = filters, SortCondition = sorts, StoredProcedure = "GetApplicationEntityList" }); } catch (Exception ex)// { throw ex; } }
/// <summary> /// Get the list of records to be shown n the database /// </summary> /// <param name="skip">no. of records to be Skipped</param> /// <param name="take">no. of records to be Retrieved</param> /// <param name="page">page no</param> /// <param name="pageSize">size of the page i.e. No of record to be displayed at once</param> /// <param name="sort">column no according to which records are to be Ordered</param> /// <param name="filter">values/parameter according to which record are to be Filtered</param> /// <returns></returns> public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <HandOverCutOffTime>(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, "GetListHandOverCutOffTime", Parameters); var HandOverCutOffTimeList = ds.Tables[0].AsEnumerable().Select(e => new HandOverCutOffTime { SNo = Convert.ToInt32(e["SNo"]), BucketClassSNo = e["BucketClassSNo"].ToString(), Text_BucketClassSNo = e["Name"].ToString(), CityCode = e["CityCode"].ToString(), Text_CityCode = e["CityCode"].ToString(), HandOverCutoffTime = Convert.ToInt32(e["HandOverCutoffTime"]), Name = e["Name"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = HandOverCutOffTimeList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <IssueConsumables>(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, "GetListIssueConsumables", Parameters); var IssueConsumablesList = ds.Tables[0].AsEnumerable().Select(e => new IssueConsumables { SNo = e["SNo"].ToString(), Item = e["Item"].ToString(), IssuedType = e["IssuedType"].ToString(), IssuedTo = e["IssuedTo"].ToString(), NoOfItem = Convert.ToInt32(e["NoOfItem"].ToString()), // IssuedDate=e["IssuedDate"].ToString(), IssuedDate = e["IssuedDate"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["IssuedDate"]), DateTimeKind.Utc), Type = e["Type"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = IssueConsumablesList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridUserGroupsData2(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { int UserSNo = CustomizedGrid.UserSNo; string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <Groups>(filter); SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts), new SqlParameter("@UserSNo", UserSNo) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListUserGroups2", Parameters); var userList = ds.Tables[0].AsEnumerable().Select(e => new Groups { //MSNo = Convert.ToInt32(e["MSNo"]), SNo = Convert.ToInt32(e["SNo"]), GroupName = e["GroupName"].ToString(), IsActive = Convert.ToBoolean(e["IsActive"].ToString()), Active = e["Active"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = userList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); }
/* ***************************************************************************** * I Name: EmailAlert * Purpose: * Company: CargoFlash Infotech Pvt Ltd. * Author: Sushant Kumar Nayak * Created On: 22-01-2018 * Updated By: * Updated On: * Approved By: * Approved On: ***************************************************************************** */ public DataSourceResult GetGridData(int EmailAlertSNo, int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <EmailAlert>(filter); string connectionString = ConfigurationManager.AppSettings["DBMSClientString"].ToString(); SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition", filters), new SqlParameter("@OrderBy", sorts) }; DataSet ds = SqlHelper.ExecuteDataset(CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Get_EmailAlert", Parameters); var EmailAlert = ds.Tables[0].AsEnumerable().Select(e => new EmailAlert { SNo = Convert.ToInt32(e["SNo"]), AirlineName = e["AirlineName"].ToString(), Process = e["Process"].ToString(), CityCountry = e["CityCountry"].ToString(), frequency = e["frequency"].ToString().ToUpper(), intervals = e["intervals"].ToString(), }); ds.Dispose(); return(new DataSourceResult { Data = EmailAlert.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); }
public DataSourceResult GetActiveGroupGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <Groups>(filter); SqlParameter[] Parameters = { new SqlParameter("@PageNo", page), new SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo), new SqlParameter("@PageSize", pageSize), new SqlParameter("@WhereCondition",filters), new SqlParameter("@OrderBy", sorts) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListActiveGroups", Parameters); var userList = ds.Tables[0].AsEnumerable().Select(e => new Groups { //MSNo = Convert.ToInt32(e["MSNo"]), SNo = Convert.ToInt32(e["SNo"]), GroupName = e["GroupName"].ToString(), Active = e["Active"].ToString(), IsActive = Convert.ToBoolean(e["IsActive"].ToString()) }); ds.Dispose(); return(new DataSourceResult { Data = userList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); }
/// <summary> /// Get list of the records to be shown in the grid /// </summary> /// <param name="skip">nos. of records to be Skipped</param> /// <param name="take">nos. of records to be Retrieved</param> /// <param name="page">page no</param> /// <param name="pageSize">Size of the page i.e. No of record to be displayed</param> /// <param name="sort">column no according to which records to be ordered</param> /// <param name="filter">values/parameter According to which record are filtered</param> /// <returns>List of the records</returns> public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <DocumentMaster>(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, "GetListDocumentMaster", Parameters); var DocumentMasterList = ds.Tables[0].AsEnumerable().Select(e => new DocumentMaster { SNo = Convert.ToInt32(e["SNo"].ToString()), DocumentName = e["DocumentName"].ToString().ToUpper(), Description = e["Description"].ToString().ToUpper(), Active = e["Active"].ToString().ToUpper(), UpdatedBy = e["UpdatedUser"].ToString().ToUpper() }); ds.Dispose(); return(new DataSourceResult { Data = DocumentMasterList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
/// <summary> /// Get grid data /// Created By : Jasmine Kaur Sethi /// Created On : 29 APR 2013 /// </summary> /// <param name="skip"></param> /// <param name="take"></param> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="sort"></param> /// <param name="filter"></param> /// <returns></returns> public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <VehicleTypeGridData>(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, "GetListVehicleMake", Parameters); var VehicleMakeList = ds.Tables[0].AsEnumerable().Select(e => new VehicleMakeGridData { SNo = Convert.ToInt32(e["SNo"]), vehicletype = e["vehicletype"].ToString(), vehiclemake = e["vehiclemake"].ToString(), // Capacity = Convert.ToInt64(e["Capacity"]), Capacity = e["Capacity"].ToString(), Active = e["Active"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = VehicleMakeList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()), FilterCondition = filters, SortCondition = sorts, StoredProcedure = "GetListVehicleMake" }); }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <DueCarrier>(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, "GetListDueCarrier", Parameters); var DueCarrierList = ds.Tables[0].AsEnumerable().Select(e => new DueCarrier { SNo = Convert.ToInt32(e["SNo"]), Code = e["Code"].ToString().ToUpper(), Name = e["Name"].ToString().ToUpper(), TempFreightType = e["TempFreightType"].ToString().ToUpper(), Carrier = e["Carrier"].ToString().ToUpper(), Mandatory = e["Mandatory"].ToString().ToUpper(), Active = e["Active"].ToString().ToUpper(), Editable = e["Editable"].ToString().ToUpper(), ShowOnCSR = e["ShowOnCSR"].ToString().ToUpper(), }); ds.Dispose(); return(new DataSourceResult { Data = DueCarrierList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)//(Exception ex) { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <EDoxGrid>(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, "GetListEDox", Parameters); var EDoxList = ds.Tables[0].AsEnumerable().Select(e => new EDoxGrid { SNo = Convert.ToInt32(e["SNo"].ToString()), DocumentName = e["DocumentName"].ToString().ToUpper(), ApplicableInTxt = e["ApplicableInTxt"].ToString().ToUpper(), UpdatedBy = e["UpdatedBy"].ToString().ToUpper(), UpdatedOn = e["UpdatedOn"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["UpdatedOn"]), DateTimeKind.Utc), IsActiveTxt = e["IsActiveTxt"].ToString().ToUpper(), }); ds.Dispose(); return(new DataSourceResult { Data = EDoxList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <RateSurcharge>(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, "GetListRateSurcharge", Parameters); var RateSurchargeList = ds.Tables[0].AsEnumerable().Select(e => new RateSurcharge { SNo = Convert.ToInt32(e["SNo"]), SurchargeName = e["SurchargeName"].ToString().ToUpper(), Text_SurchargeTypeSNo = e["Text_SurchargeTypeSNo"].ToString().ToUpper(), Text_OriginSNo = e["Text_OriginSNo"].ToString().ToUpper(), Text_ProductSNo = e["Text_ProductSNo"].ToString().ToUpper(), ValidFrom = e["ValidFrom"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["ValidFrom"]), DateTimeKind.Utc), ValidTo = e["ValidTo"] == DBNull.Value ? (DateTime?)null : DateTime.SpecifyKind(Convert.ToDateTime(e["ValidTo"]), DateTimeKind.Utc) //Active = e["Active"].ToString().ToUpper(), }); ds.Dispose(); return(new DataSourceResult { Data = RateSurchargeList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
{/// <summary> /// Get list of the records to be shown in the grid /// </summary> /// <param name="skip">nos. of records to be Skipped</param> /// <param name="take">nos. of records to be Retrieved</param> /// <param name="page">page no</param> /// <param name="pageSize">Size of the page i.e. No of record to be displayed</param> /// <param name="sort">column no according to which records to be ordered</param> /// <param name="filter">values/parameter According to which record are filtered</param> /// <returns>List of the records</returns> public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <AccountType>(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, "GetListAccountType", Parameters); var AccountTypeList = ds.Tables[0].AsEnumerable().Select(e => new AccountType { SNo = Convert.ToInt32(e["SNo"].ToString()), AccountTypeName = e["AccountTypeName"].ToString().ToUpper(), //PrefixCode=e["PrefixCode"].ToString().ToUpper(), Text_ProductSNo = e["Text_ProductSNo"].ToString().ToUpper(), Active = e["Active"].ToString().ToUpper(),//foriegn key Airline = e["Airline"].ToString().ToUpper(), UpdatedBy = e["UpdatedUser"].ToString().ToUpper(), CreatedBy = e["CreatedUser"].ToString().ToUpper() }); ds.Dispose(); return(new DataSourceResult { Data = AccountTypeList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { try { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <RegistryControl>(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, "GetListTaskArea", Parameters); var TAList = ds.Tables[0].AsEnumerable().Select(e => new TaskArrea { SNo = Convert.ToInt32(e["SNo"].ToString()), TaskName = e["TaskName"].ToString().ToUpper(), AreaName = e["AreaName"].ToString().ToUpper(), TIsActive = true, }); ds.Dispose(); return(new DataSourceResult { Data = TAList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <Contacts>(filter); try { 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, "GetListContacts", Parameters); var ContactsList = ds.Tables[0].AsEnumerable().Select(e => new Contacts { SNo = Convert.ToInt32(e["SNo"]), ContactsTypeName = e["ContactsTypeName"].ToString(), ContactsTypeDis = e["ContactsTypeDis"].ToString(), Name = e["Name"].ToString(), DepartmentName = e["DepartmentName"].ToString().ToUpper(), PersonName = e["PersonName"].ToString(), Email = e["Email"].ToString(), Mobile = e["Mobile"].ToString(), Phone = e["Phone"].ToString(), Primary = e["Primary"].ToString(), Active = e["Active"].ToString() }); ds.Dispose(); return(new DataSourceResult { Data = ContactsList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); } catch (Exception ex)// { throw ex; } }
public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <Allocation>(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, "GetListAllocationAccount", Parameters); var AllocationList = ds.Tables[0].AsEnumerable().Select(e => new AllocationAccount { SNo = Convert.ToInt32(e["SNo"].ToString()), ProductSNo = e["ProductSNo"].ToString(), ProductName = e["ProductName"].ToString(), AccountSNo = e["AccountSNo"].ToString(), // Text_AccountSNo = e["Name"].ToString(), AccountAllocationCode = e["AccountAllocationCode"].ToString(), GrossWeight = Convert.ToDecimal(e["GrossWeight"]), VolumeWeight = Convert.ToDecimal(e["VolumeWeight"]), ReleaseTime = e["ReleaseTime"].ToString(), StartDate = Convert.ToDateTime(e["StartDate"]).ToString("dd-MMM-yyyy"), EndDate = Convert.ToDateTime(e["EndDate"]).ToString("dd-MMM-yyyy") }); ds.Dispose(); return(new DataSourceResult { Data = AllocationList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); }
public DataSourceResult GetGridChildData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <Pages>(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, "GetListModulePage", Parameters); var pageList = ds.Tables[0].AsEnumerable().Select(e => new Pages { MSNo = Convert.ToInt32(e["MSNo"]), SNo = Convert.ToInt32(e["SNo"]), PageName = e["PageName"].ToString(), Hyperlink = e["Hyperlink"].ToString(), MenuSNo = Convert.ToInt32(e["MenuSNo"].ToString()), DisplayOrder = Convert.ToInt32(e["DisplayOrder"].ToString()), Help = e["Help"].ToString(), Description = e["Description"].ToString(), IsActive = Convert.ToBoolean(e["IsActive"].ToString()) }); ds.Dispose(); return(new DataSourceResult { Data = pageList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()) }); }
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; } }
/// <summary> /// Get all records for grid data /// Created By :Devendra /// Created On :15 JAN 2019 /// </summary> /// <param name="skip"></param> /// <param name="take"></param> /// <param name="page"></param> /// <param name="pageSize"></param> /// <param name="sort"></param> /// <param name="filter"></param> /// <returns></returns> public DataSourceResult GetGridData(int skip, int take, int page, int pageSize, List <GridSort> sort, GridFilter filter) { string sorts = GridSort.ProcessSorting(sort); string filters = GridFilter.ProcessFilters <BannerGridData>(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, "GetListBanner", Parameters); var BannerList = ds.Tables[0].AsEnumerable().Select(e => new BannerGridData { SNo = Convert.ToInt32(e["SNo"]), BannerSubject = e["BannerSubject"].ToString(), Active = e["Active"].ToString(), Title = e["Title"].ToString(), BannerType = e["BannerType"].ToString(), CreatedUser = e["CreatedUser"].ToString(), UpdatedUser = e["UpdatedUser"].ToString(), }); ds.Dispose(); return(new DataSourceResult { Data = BannerList.AsQueryable().ToList(), Total = Convert.ToInt32(ds.Tables[1].Rows[0][0].ToString()), FilterCondition = filters, SortCondition = sorts, StoredProcedure = "GetListBanner" }); }
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; } }