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