public List <ClsProducerTrackAndBeatList> GetProducerTrackAndBeatList(Int64 ProducersID, Int64 UserID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@ProducersID", ProducersID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@UserID", UserID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet User = objDbHelper.ExecuteDataSet(Constant.GetProducerTrackAndBeatList, ObJParameterCOl, CommandType.StoredProcedure); List <ClsProducerTrackAndBeatList> objProducerTrackAndBeat = new List <ClsProducerTrackAndBeatList>(); if (User != null) { if (User.Tables[0].Rows.Count > 0) { objProducerTrackAndBeat = User.Tables[0].AsEnumerable().Select(Row => new ClsProducerTrackAndBeatList { ProducerName = Row.Field <string>("ProducerName"), ProfilePhoto = Row.Field <string>("ProfilePhoto"), ProducerBio = Row.Field <string>("ProducerBio"), ProducerFrom = Row.Field <string>("ProducerFrom"), Followed = Row.Field <string>("Followed"), Followers = Row.Field <Int64>("Followers"), Following = Row.Field <Int64>("Following"), Plays = Row.Field <Int64>("Plays"), TrackAndBeat = User.Tables[1].AsEnumerable().Select(Row1 => new ClsTrackAndBeatList { Ref_Track_ID = Row1.Field <Int64>("Ref_Track_ID"), CategoryName = Row1.Field <string>("CategoryName"), TrackName = Row1.Field <string>("TrackName"), TrackType = Row1.Field <string>("TrackType"), Bio = Row1.Field <string>("Bio"), Duration = Row1.Field <string>("Duration"), Price = Row1.Field <decimal>("Price"), BMP = Row1.Field <int>("BMP"), Plays = Row1.Field <Int64>("Plays"), ThumbnailImageUrl = Row1.Field <string>("Thumbnail"), TrackStatus = Row1.Field <string>("TrackStatus"), Favourite = Row1.Field <string>("Favourite"), IsTrack = Row1.Field <string>("IsTrack"), SoldOut = Row1.Field <string>("SoldOut"), }).ToList(), }).ToList(); } } return(objProducerTrackAndBeat); } catch (Exception ex) { throw ex; } }
public List <ClsCategoryDetails> GetCategoryList(string Flag, Int64 Ref_Category_ID, string AliasName) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Flag", Flag, DbType.String); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@Ref_Category_ID", Ref_Category_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@AliasName", AliasName, DbType.String); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetCategoryList, ObJParameterCOl, CommandType.StoredProcedure); List <ClsCategoryDetails> objCategoryList = new List <ClsCategoryDetails>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { objCategoryList = ds.Tables[0].AsEnumerable().Select(Row => new ClsCategoryDetails { Ref_Category_ID = Row.Field <Int64>("Ref_Category_ID"), Ref_Parent_ID = Row.Field <Int64>("Ref_Parent_ID"), CategoryName = Row.Field <string>("CategoryName"), AliasName = Row.Field <string>("AliasName"), CategoryUseBy = Row.Field <Int64>("CategoryUseBy"), Description = Row.Field <string>("Description"), IsActive = Row.Field <Boolean>("IsActive"), MetaTitle = Row.Field <string>("MetaTitle"), MetaKeywords = Row.Field <string>("MetaKeywords"), MetaDescription = Row.Field <string>("MetaDescription"), FileManager = ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("ModuleID") == Row.Field <Int64>("Ref_Category_ID")).Select(Row1 => new ClsFileManager { FileManagerID = Row1.Field <Int64>("Ref_FileManager_ID"), FileIdentifier = Row1.Field <string>("FileIdentifier"), FileName = Row1.Field <string>("FileName"), FilePath = Row1.Field <string>("FilePath"), FileExtension = Row1.Field <string>("FileExtension"), FileSize = Row1.Field <Int64>("FileSize"), FileType = Row1.Field <string>("FileType"), Sequence = Row1.Field <int>("Sequence"), }).ToList(), }).ToList(); } } return(objCategoryList); } catch (Exception ex) { throw ex; } }
public List <ClsCustomServiceDetails> GetCustomServiceDetails(Int64 ServiceID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@ServiceID", ServiceID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetCustomServiceDetails, ObJParameterCOl, CommandType.StoredProcedure); List <ClsCustomServiceDetails> objService = new List <ClsCustomServiceDetails>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { IList <ClsCustomServiceDetails> List = ds.Tables[0].AsEnumerable().Select(Row => new ClsCustomServiceDetails { Ref_Service_ID = Row.Field <Int64>("Ref_Service_ID"), CategoryName = Row.Field <string>("CategoryName"), ServiceTitle = Row.Field <string>("ServiceTitle"), Description = Row.Field <string>("Description"), Revision = Row.Field <int>("Revision"), Price = Row.Field <decimal>("Price"), PriceWithProjectFiles = Row.Field <decimal>("PriceWithProjectFiles"), FAQList = ds.Tables[1].AsEnumerable().Select(Row1 => new ClsFAQList { Questions = Row1.Field <string>("Question"), Answer = Row1.Field <string>("Answer") }).ToList(), FileManager = ds.Tables[2].AsEnumerable().Select(Row2 => new ClsFileManager { FileManagerID = Row2.Field <Int64>("Ref_FileManager_ID"), FileIdentifier = Row2.Field <string>("FileIdentifier"), FileName = Row2.Field <string>("FileName"), FilePath = Row2.Field <string>("FilePath"), FileExtension = Row2.Field <string>("FileExtension"), FileSize = Row2.Field <Int64>("FileSize"), FileType = Row2.Field <string>("FileType"), Sequence = Row2.Field <int>("Sequence"), }).ToList(), }).ToList(); objService.AddRange(List); } } return(objService); } catch (Exception ex) { throw ex; } }
//====================== private void LoadData() { DataTable dt1 = dbClass.Execute_Proc("dbo.GetTags"); foreach (DataRow Row1 in dt1.Rows) { Tag tag = new Tag ( Row1.Field <int?>("TagID"), Row1.Field <int?>("ParentCategoryID"), Row1.Field <string>("Name"), Row1.Field <string>("ColorID"), Row1.Field <bool?>("IsUserCreated"), Row1.Field <bool?>("IsFeelingGoodBad") ); if (tag.ParentCategoryID == null) { TagViewModel.CategoryTagList.Add(tag); } else { TagViewModel.SubcategoryTagList.Add(tag); } } DataTable dt2 = dbClass.Execute_Proc("dbo.GetFoodEntrys"); foreach (DataRow Row2 in dt2.Rows) { FoodEntry foodEntry = new FoodEntry ( Row2.Field <int?>("FoodEntryId"), Row2.Field <string>("Picture"), Row2.Field <DateTime>("DateTime"), Row2.Field <string>("Description"), Row2.Field <bool?>("IsFeelingGoodBad") ); DataTable dt3 = dbClass.GetFoodEntry_Tags("dbo.GetFoodEntry_Tags", (int)foodEntry.FoodEntryID); foreach (DataRow Row3 in dt3.Rows) { int TagID = Row3.Field <int>("TagID"); Tag foundTag = TagViewModel.SubcategoryTagList.Where(tag => TagID == tag.TagID).FirstOrDefault(); foodEntry.FoodEntry_TagList.Add(foundTag); } EntryViewModel.FoodEntryList.Add(foodEntry); } }
public List <ClsModuleList> GetUserModuleAccess(Int64 UserID, Int64 ModuleID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@UserID", UserID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@ModuleID", ModuleID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetUserModuleAccess, ObJParameterCOl, CommandType.StoredProcedure); List <ClsModuleList> objModuleList = new List <ClsModuleList>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { IList <ClsModuleList> List = ds.Tables[0].AsEnumerable().Select(Row => new ClsModuleList { Ref_Module_ID = Row.Field <Int64>("Ref_Module_ID"), ModuleIdentifier = Row.Field <string>("ModuleIdentifier"), ModuleName = Row.Field <string>("ModuleName"), ModuleType = Row.Field <string>("ModuleType"), ModuleFor = Row.Field <string>("ModuleFor"), ImageUrl = Row.Field <string>("ImageUrl"), ModuleUrl = Row.Field <string>("ModuleUrl"), DisplayOrder = Row.Field <int>("DisplayOrder"), ModuleAccess = ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("Ref_Module_ID") == Row.Field <Int64>("Ref_Module_ID")).Select(Row1 => new ClsModuleAccess { View = Row1.Field <Boolean>("ViewAccess"), Edit = Row1.Field <Boolean>("EditAccess"), Delete = Row1.Field <Boolean>("DeleteAccess"), Approval = Row1.Field <Boolean>("ApprovalAccess") }).ToList() }).ToList(); objModuleList.AddRange(List); } } return(objModuleList); } catch (Exception ex) { throw ex; } }
public List <ClsBannerDetails> GetBannersList(Int64 BannerID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_Banner_ID", BannerID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetBannersList, ObJParameterCOl, CommandType.StoredProcedure); List <ClsBannerDetails> objUserMaster = new List <ClsBannerDetails>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { IList <ClsBannerDetails> List = ds.Tables[0].AsEnumerable().Select(Row => new ClsBannerDetails { Ref_Banner_ID = Row.Field <Int64>("Ref_Banner_ID"), BannerTitle = Row.Field <string>("BannerTitle"), BannerPageName = Row.Field <string>("BannerPageName"), Descripation = Row.Field <string>("Descripation"), IsActive = Row.Field <Boolean>("IsActive"), CreatedBy = Row.Field <string>("CreatedBy"), FileManager = ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("ModuleID") == Row.Field <Int64>("Ref_Banner_ID")).Select(Row1 => new ClsFileManager { FileManagerID = Row1.Field <Int64>("Ref_FileManager_ID"), FileIdentifier = Row1.Field <string>("FileIdentifier"), FileName = Row1.Field <string>("FileName"), FilePath = Row1.Field <string>("FilePath"), FileExtension = Row1.Field <string>("FileExtension"), FileSize = Row1.Field <Int64>("FileSize"), FileType = Row1.Field <string>("FileType"), Sequence = Row1.Field <int>("Sequence"), }).ToList(), }).ToList(); objUserMaster.AddRange(List); } } return(objUserMaster); } catch (Exception ex) { throw ex; } }
public List <ClsCouponDetails> GetCouponCodeList() { try { DBHelper objDbHelper = new DBHelper(); DataSet Ds = objDbHelper.ExecuteDataSet(Constant.GetCouponCodeList, CommandType.StoredProcedure); List <ClsCouponDetails> ObjCouponDetails = new List <ClsCouponDetails>(); if (Ds != null) { if (Ds.Tables.Count > 0) { if (Ds.Tables[0].Rows.Count > 0) { IList <ClsCouponDetails> List = Ds.Tables[0].AsEnumerable().Select(Row => new ClsCouponDetails { Ref_Coupon_ID = Row.Field <Int64>("Ref_Coupon_ID"), CouponCode = Row.Field <string>("CouponCode"), Description = Row.Field <string>("Description"), CouponUseBy = Row.Field <string>("CouponUseBy"), DiscountInMax = Row.Field <Decimal>("DiscountInMax"), DiscountInPercentage = Row.Field <Decimal>("DiscountInPercentage"), StartDate = Row.Field <DateTime>("StartDate"), EndDate = Row.Field <DateTime>("EndDate"), OneTimeUse = Row.Field <Boolean>("OneTimeUse"), OnlyForNewUsers = Row.Field <Boolean>("OnlyForNewUsers"), AudienceCount = Row.Field <int>("AudienceCount"), IsActive = Row.Field <Boolean>("IsActive"), CouponObject = Ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("Ref_Coupon_ID") == Row.Field <Int64>("Ref_Coupon_ID")).Select(Row1 => new ClsCouponObject { ObjectType = Row1.Field <string>("ObjectType"), Ref_Object_ID = Row1.Field <Int64>("Ref_Object_ID") }).ToList() }).ToList(); ObjCouponDetails.AddRange(List); } } } return(ObjCouponDetails); } catch (Exception ex) { throw ex; } }
public List <ClsAuthority> GetAuthorityDetails(Int64 AuthorityID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@AuthorityID", AuthorityID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetAuthorityDetails, ObJParameterCOl, CommandType.StoredProcedure); List <ClsAuthority> objUserMasterData = new List <ClsAuthority>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { IList <ClsAuthority> List = ds.Tables[0].AsEnumerable().Select(Row => new ClsAuthority { Ref_Authority_ID = Row.Field <Int64>("Ref_Authority_ID"), AuthorityName = Row.Field <string>("AuthorityName"), AuthorityType = Row.Field <string>("AuthorityType"), Description = Row.Field <string>("Description"), MasterDataIDs = Row.Field <string>("MasterDataIDs"), ModuleAccess = ds.Tables[1].AsEnumerable().Select(Row1 => new ClsModuleAccess { Ref_Module_ID = Row1.Field <Int64>("Ref_Module_ID"), View = Row1.Field <Boolean>("ViewAccess"), Edit = Row1.Field <Boolean>("EditAccess"), Delete = Row1.Field <Boolean>("DeleteAccess"), Approval = Row1.Field <Boolean>("ApprovalAccess") }).ToList() }).ToList(); objUserMasterData.AddRange(List); } } return(objUserMasterData); } catch (Exception ex) { throw ex; } }
public List <ClsParentUserMaster> GetParentUserMasterList(Int64 UserMasterID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_UserMaster_ID", UserMasterID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetParentUserMasterList, ObJParameterCOl, CommandType.StoredProcedure); List <ClsParentUserMaster> objUserMasterData = new List <ClsParentUserMaster>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { IList <ClsParentUserMaster> List = ds.Tables[0].AsEnumerable().Select(Row => new ClsParentUserMaster { Ref_UserMaster_ID = Row.Field <Int64>("Ref_UserMaster_ID"), UserMaster = Row.Field <string>("MasterName"), ControlName = Row.Field <string>("ControlName"), IsMandatory = Row.Field <Boolean>("IsMandatory"), userMasterData = ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("Ref_UserMaster_ID") == Row.Field <Int64>("Ref_UserMaster_ID")).Select(Row1 => new ClsUserMasterData { Ref_UserMasterData_ID = Row1.Field <Int64>("Ref_UserMasterData_ID"), UserMasterData = Row1.Field <string>("MasterDataName") }).ToList() }).ToList(); objUserMasterData.AddRange(List); } } return(objUserMasterData); } catch (Exception ex) { throw ex; } }
public List <ClsTrackDetails> GetTrackDetails(Int64 TrackID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@TrackID", TrackID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetTrackDetails, ObJParameterCOl, CommandType.StoredProcedure); List <ClsTrackDetails> objUserMasterData = new List <ClsTrackDetails>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { IList <ClsTrackDetails> List = ds.Tables[0].AsEnumerable().Select(Row => new ClsTrackDetails { Ref_Track_ID = Row.Field <Int64>("Ref_Track_ID"), Ref_Category_ID = Row.Field <Int64>("Ref_Category_ID"), TrackName = Row.Field <string>("TrackName"), TrackType = Row.Field <string>("TrackType"), Bio = Row.Field <string>("Bio"), Mood = Row.Field <string>("Mood"), Key = Row.Field <string>("TrackKey"), Tag = Row.Field <string>("Tag"), Duration = Row.Field <string>("Duration"), Price = Row.Field <decimal>("Price"), PriceWithProjectFiles = Row.Field <decimal>("PriceWithProjectFiles"), BMP = Row.Field <int>("BMP"), DAW = Row.Field <string>("DAW"), TrackStatus = Row.Field <string>("TrackStatus"), Reason = Row.Field <string>("Reason"), IsVocals = Row.Field <Boolean>("IsVocals"), IsTrack = Row.Field <Boolean>("IsTrack"), IsActive = Row.Field <Boolean>("IsActive"), CreatedBy = Row.Field <String>("CreatedBy"), FileManager = ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("ModuleID") == Row.Field <Int64>("Ref_Track_ID")).Select(Row1 => new ClsFileManager { FileManagerID = Row1.Field <Int64>("Ref_FileManager_ID"), FileIdentifier = Row1.Field <string>("FileIdentifier"), FileName = Row1.Field <string>("FileName"), FilePath = Row1.Field <string>("FilePath"), FileExtension = Row1.Field <string>("FileExtension"), FileSize = Row1.Field <Int64>("FileSize"), FileType = Row1.Field <string>("FileType"), Sequence = Row1.Field <int>("Sequence"), }).ToList(), }).ToList(); objUserMasterData.AddRange(List); } } return(objUserMasterData); } catch (Exception ex) { throw ex; } }
public List <ClsTrackAndBeatDetails> GetTrackAndBeatDetails(Int64 UserID, Int64 TrackID) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@UserID", UserID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@TrackID", TrackID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet Ds = objDbHelper.ExecuteDataSet(Constant.GetTrackAndBeatDetails, ObJParameterCOl, CommandType.StoredProcedure); List <ClsTrackAndBeatDetails> objTrackAndBeatDetails = new List <ClsTrackAndBeatDetails>(); if (Ds != null) { if (Ds.Tables.Count > 0) { if (Ds.Tables[0].Rows.Count > 0) { IList <ClsTrackAndBeatDetails> List = Ds.Tables[0].AsEnumerable().Select(Row => new ClsTrackAndBeatDetails { Ref_Track_ID = Row.Field <Int64>("Ref_Track_ID"), CategoryName = Row.Field <string>("CategoryName"), TrackName = Row.Field <string>("TrackName"), TrackType = Row.Field <string>("TrackType"), Bio = Row.Field <string>("Bio"), Mood = Row.Field <string>("Mood"), Key = Row.Field <string>("TrackKey"), Tag = Row.Field <string>("Tag"), Duration = Row.Field <string>("Duration"), Price = Row.Field <decimal>("Price"), PriceWithProjectFiles = Row.Field <decimal>("PriceWithProjectFiles"), BMP = Row.Field <int>("BMP"), DAW = Row.Field <string>("DAW"), IsVocals = Row.Field <string>("IsVocals"), IsTrack = Row.Field <string>("IsTrack"), Favourite = Row.Field <string>("Favourite"), SoldOut = Row.Field <string>("SoldOut"), FileManager = Ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("ModuleID") == Row.Field <Int64>("Ref_Track_ID")).Select(Row1 => new ClsFileManager { FileManagerID = Row1.Field <Int64>("Ref_FileManager_ID"), FileIdentifier = Row1.Field <string>("FileIdentifier"), FileName = Row1.Field <string>("FileName"), FilePath = Row1.Field <string>("FilePath"), FileExtension = Row1.Field <string>("FileExtension"), FileSize = Row1.Field <Int64>("FileSize"), FileType = Row1.Field <string>("FileType"), Sequence = Row1.Field <int>("Sequence"), }).ToList(), RelatedTrack = Ds.Tables[2].AsEnumerable().Select(Row2 => new ClsRelatedTrackList { Ref_Track_ID = Row2.Field <Int64>("Ref_Track_ID"), CategoryName = Row2.Field <string>("CategoryName"), TrackName = Row2.Field <string>("TrackName"), Bio = Row2.Field <string>("Bio"), Price = Row2.Field <decimal>("Price"), IsTrack = Row2.Field <string>("IsTrack"), PlayUrl = Row2.Field <string>("PlayUrl"), Favourite = Row2.Field <string>("Favourite"), SoldOut = Row2.Field <string>("SoldOut"), ThumbnailImageUrl = Row2.Field <string>("Thumbnail"), }).ToList(), }).ToList(); objTrackAndBeatDetails.AddRange(List); } } } return(objTrackAndBeatDetails); } catch (Exception ex) { throw ex; } }
public List <ClsServiceDetails> GetServiceDetails(Int64 Ref_Service_ID, string AliasName) { try { DBParameterCollection ObJParameterCOl = new DBParameterCollection(); DBParameter objDBParameter = new DBParameter("@Ref_Service_ID", Ref_Service_ID, DbType.Int64); ObJParameterCOl.Add(objDBParameter); objDBParameter = new DBParameter("@AliasName", AliasName, DbType.String); ObJParameterCOl.Add(objDBParameter); DBHelper objDbHelper = new DBHelper(); DataSet ds = objDbHelper.ExecuteDataSet(Constant.GetServiceDetails, ObJParameterCOl, CommandType.StoredProcedure); List <ClsServiceDetails> objServiceList = new List <ClsServiceDetails>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { objServiceList = ds.Tables[0].AsEnumerable().Select(Row => new ClsServiceDetails { Ref_Service_ID = Row.Field <Int64>("Ref_Service_ID"), Ref_Category_ID = Row.Field <Int64>("Ref_Category_ID"), ServiceTitle = Row.Field <string>("ServiceTitle"), AliasName = Row.Field <string>("AliasName"), Description = Row.Field <string>("Description"), Price = Row.Field <decimal>("Price"), PriceWithProjectFiles = Row.Field <decimal>("PriceWithProjectFiles"), Revision = Row.Field <int>("Revision"), DeliveryDate = Row.Field <string>("DeliveryDate"), IsActive = Row.Field <Boolean>("IsActive"), IsDeleted = Row.Field <Boolean>("IsDeleted"), CreatedBy = Row.Field <Int64>("CreatedBy"), CreatedName = Row.Field <string>("CreatedName"), CreatedDateTime = Row.Field <DateTime?>("CreatedDateTime"), MetaTitle = Row.Field <string>("MetaTitle"), MetaKeywords = Row.Field <string>("MetaKeywords"), MetaDescription = Row.Field <string>("MetaDescription"), FAQDetails = ds.Tables[1].AsEnumerable().Where(x => x.Field <Int64>("Ref_Service_ID") == Row.Field <Int64>("Ref_Service_ID")).Select(Row1 => new ClsFAQDetails { Ref_Service_ID = Row1.Field <Int64>("Ref_Service_ID"), Questions = Row1.Field <string>("Question"), Answer = Row1.Field <string>("Answer") }).ToList(), FileManager = ds.Tables[2].AsEnumerable().Where(x => x.Field <Int64>("ModuleID") == Row.Field <Int64>("Ref_Service_ID")).Select(Row2 => new ClsFileManager { FileManagerID = Row2.Field <Int64>("Ref_FileManager_ID"), FileIdentifier = Row2.Field <string>("FileIdentifier"), FileName = Row2.Field <string>("FileName"), FilePath = Row2.Field <string>("FilePath"), FileExtension = Row2.Field <string>("FileExtension"), FileSize = Row2.Field <Int64>("FileSize"), FileType = Row2.Field <string>("FileType"), Sequence = Row2.Field <int>("Sequence"), }).ToList(), }).ToList(); } } return(objServiceList); } catch (Exception ex) { throw ex; } }