public List <TVItemUserAuthorizationModel> GetTVItemUserAuthorizationModelListWithTVItemID1DB(int TVItemID1)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
List <TVItemUserAuthorizationModel> tvItemUserAuthorizationModelList = (from c in db.TVItemUserAuthorizations
let tvItemID1TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID1 select cl.TVText).FirstOrDefault <string>()
let tvItemID2TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID2 select cl.TVText).FirstOrDefault <string>()
let tvItemID3TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID3 select cl.TVText).FirstOrDefault <string>()
let tvItemID4TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID4 select cl.TVText).FirstOrDefault <string>()
let tvPath1 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID1 select ct.TVPath).FirstOrDefault <string>()
let tvPath2 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID2 select ct.TVPath).FirstOrDefault <string>()
let tvPath3 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID3 select ct.TVPath).FirstOrDefault <string>()
let tvPath4 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID4 select ct.TVPath).FirstOrDefault <string>()
where c.TVItemID1 == TVItemID1
select new TVItemUserAuthorizationModel
{
Error = "",
TVItemUserAuthorizationID = c.TVItemUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVItemID1 = c.TVItemID1,
TVText1 = tvItemID1TVText,
TVPath1 = tvPath1,
TVItemID2 = c.TVItemID2,
TVText2 = tvItemID2TVText,
TVPath2 = tvPath2,
TVItemID3 = c.TVItemID3,
TVText3 = tvItemID3TVText,
TVPath3 = tvPath3,
TVItemID4 = c.TVItemID4,
TVText4 = tvItemID4TVText,
TVPath4 = tvPath4,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).ToList <TVItemUserAuthorizationModel>();
foreach (TVItemUserAuthorizationModel tvItemUserAuthorizationModel in tvItemUserAuthorizationModelList)
{
tvItemUserAuthorizationModel.TVLevel1 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath1);
if (tvItemUserAuthorizationModel.TVPath2 != null)
{
tvItemUserAuthorizationModel.TVLevel2 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath2);
}
if (tvItemUserAuthorizationModel.TVPath3 != null)
{
tvItemUserAuthorizationModel.TVLevel3 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath3);
}
if (tvItemUserAuthorizationModel.TVPath4 != null)
{
tvItemUserAuthorizationModel.TVLevel4 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath4);
}
}
return(tvItemUserAuthorizationModelList.OrderBy(c => c.TVLevel1).ThenBy(c => c.TVLevel2).ToList <TVItemUserAuthorizationModel>());
}
public TVTypeUserAuthorizationModel GetTVTypeUserAuthorizationModelWithTVTypeUserAuthorizationIDDB(int TVTypeUserAuthorizationID)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
TVTypeUserAuthorizationModel tvTypeUserAuthorizationModel = (from c in db.TVTypeUserAuthorizations
where c.TVTypeUserAuthorizationID == TVTypeUserAuthorizationID
select new TVTypeUserAuthorizationModel
{
Error = "",
TVTypeUserAuthorizationID = c.TVTypeUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVType = (TVTypeEnum)c.TVType,
TVPath = "",
TVLevel = -1,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <TVTypeUserAuthorizationModel>();
if (tvTypeUserAuthorizationModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, BaseEnumServiceRes.TVTypeUserAuthorization, BaseEnumServiceRes.TVTypeUserAuthorizationID, TVTypeUserAuthorizationID)));
}
tvTypeUserAuthorizationModel.TVPath = tvTypeNamesAndPathList.Where(c => c.Index == (int)tvTypeUserAuthorizationModel.TVType).FirstOrDefault().TVPath;
tvTypeUserAuthorizationModel.TVLevel = tvItemService.GetTVLevel(tvTypeUserAuthorizationModel.TVPath);
return(tvTypeUserAuthorizationModel);
}
public List <TVTypeUserAuthorizationModel> GetTVTypeUserAuthorizationModelListWithContactTVItemIDDB(int ContactTVItemID)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
List <TVTypeUserAuthorizationModel> tvTypeUserAuthorizationModelList = (from c in db.TVTypeUserAuthorizations
where c.ContactTVItemID == ContactTVItemID
select new TVTypeUserAuthorizationModel
{
Error = "",
TVTypeUserAuthorizationID = c.TVTypeUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVType = (TVTypeEnum)c.TVType,
TVPath = "",
TVLevel = -1,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).ToList <TVTypeUserAuthorizationModel>();
foreach (TVTypeUserAuthorizationModel tvTypeUserAuthorizationModel in tvTypeUserAuthorizationModelList)
{
tvTypeUserAuthorizationModel.TVPath = tvTypeNamesAndPathList.Where(c => c.Index == (int)tvTypeUserAuthorizationModel.TVType).FirstOrDefault().TVPath;
tvTypeUserAuthorizationModel.TVLevel = tvItemService.GetTVLevel(tvTypeUserAuthorizationModel.TVPath);
}
return(tvTypeUserAuthorizationModelList.OrderBy(c => c.TVLevel).ToList <TVTypeUserAuthorizationModel>());
}
public TVItemUserAuthorizationModel GetTVItemUserAuthorizationModelWithContactTVItemIDTVItemID1TVItemID2TVItemID3TVItemID4DB(int ContactTVItemID, int TVItemID1, int?TVItemID2, int?TVItemID3, int?TVItemID4)
{
TVItemService tvItemService = new TVItemService(this.LanguageRequest, this.User);
TVItemUserAuthorizationModel tvItemUserAuthorizationModel = (from c in db.TVItemUserAuthorizations
let tvItemID1TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID1 select cl.TVText).FirstOrDefault <string>()
let tvItemID2TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID2 select cl.TVText).FirstOrDefault <string>()
let tvItemID3TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID3 select cl.TVText).FirstOrDefault <string>()
let tvItemID4TVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID4 select cl.TVText).FirstOrDefault <string>()
let tvPath1 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID1 select ct.TVPath).FirstOrDefault <string>()
let tvPath2 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID2 select ct.TVPath).FirstOrDefault <string>()
let tvPath3 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID3 select ct.TVPath).FirstOrDefault <string>()
let tvPath4 = (from ct in db.TVItems where ct.TVItemID == c.TVItemID4 select ct.TVPath).FirstOrDefault <string>()
where c.ContactTVItemID == ContactTVItemID &&
c.TVItemID1 == TVItemID1 &&
c.TVItemID2 == TVItemID2 &&
c.TVItemID3 == TVItemID3 &&
c.TVItemID4 == TVItemID4
select new TVItemUserAuthorizationModel
{
Error = "",
TVItemUserAuthorizationID = c.TVItemUserAuthorizationID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactTVItemID = c.ContactTVItemID,
TVItemID1 = c.TVItemID1,
TVText1 = tvItemID1TVText,
TVPath1 = tvPath1,
TVItemID2 = c.TVItemID2,
TVText2 = tvItemID2TVText,
TVPath2 = tvPath2,
TVItemID3 = c.TVItemID3,
TVText3 = tvItemID3TVText,
TVPath3 = tvPath3,
TVItemID4 = c.TVItemID4,
TVText4 = tvItemID4TVText,
TVPath4 = tvPath4,
TVAuth = (TVAuthEnum)c.TVAuth,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <TVItemUserAuthorizationModel>();
if (tvItemUserAuthorizationModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.TVItemUserAuthorization, ServiceRes.ContactTVItemID
+ "," + ServiceRes.TVItemID1 + ","
+ ServiceRes.TVItemID2 ?? "" + ","
+ ServiceRes.TVItemID3 ?? "" + ","
+ ServiceRes.TVItemID4 ?? "",
ContactTVItemID.ToString() + ","
+ TVItemID1.ToString() + ","
+ TVItemID2 ?? "" + ","
+ TVItemID3 ?? "" + ","
+ TVItemID4 ?? ""
)));
}
tvItemUserAuthorizationModel.TVLevel1 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath1);
if (tvItemUserAuthorizationModel.TVPath2 != null)
{
tvItemUserAuthorizationModel.TVLevel2 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath2);
}
if (tvItemUserAuthorizationModel.TVPath3 != null)
{
tvItemUserAuthorizationModel.TVLevel3 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath3);
}
if (tvItemUserAuthorizationModel.TVPath4 != null)
{
tvItemUserAuthorizationModel.TVLevel4 = tvItemService.GetTVLevel(tvItemUserAuthorizationModel.TVPath4);
}
return(tvItemUserAuthorizationModel);
}