public static Director GetDirector(int id)
{
using (IMDbContext db = new IMDbContext())
{
return(db.Director.Find(id));
}
}
private static dynamic GetWsId(IMInstance iMInstance, List <string> engNums)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions {
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (var db = new IMDbContext(iMInstance))
{
var result = (
from dm in db.Set <DOCMASTER>()
join prj in db.Set <PROJECT>() on
dm.DOCNUM equals prj.DOCNUM
where
engNums.Contains(dm.C2ALIAS) &&
dm.C_ALIAS.Equals("WEBDOC", StringComparison.OrdinalIgnoreCase) &&
dm.DOCNAME.Equals("", StringComparison.OrdinalIgnoreCase)
select new { EngNum = dm.C2ALIAS, EngId = prj.PRJ_ID }).ToList();
return(result);
}
}
}
private static string GetDocLocation(IMInstance iMInstance, string docLoc)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions {
IsolationLevel = IsolationLevel.ReadUncommitted
}))
{
using (var db = new IMDbContext(iMInstance))
{
var sp_docLoc = docLoc.Split(':');
var p1 = sp_docLoc[0].Trim();
var srvLoc =
db.Set <DOCSERVER>().
Where(x => x.DOCSERVER1.Equals(p1, StringComparison.OrdinalIgnoreCase)
).Select(y => y.LOCATION).ToList().FirstOrDefault();
var result = string.Format("{0}{1}", srvLoc, sp_docLoc[1]);
return(result);
}
}
}
public static Movie GetMovie(int id)
{
using (IMDbContext db = new IMDbContext())
{
return(db.Movie.Find(id));
}
}
public static string GetDocLocation(IMInstance iMInstance, string engNum, double docNum)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDbContext(iMInstance))
{
var docLoc = db.Set<DOCMASTER>().
Where(x => x.C2ALIAS.Equals(engNum, StringComparison.OrdinalIgnoreCase) && x.DOCNUM == docNum && x.VERSION == 1
).Select(y => y.DOCLOC).ToList().FirstOrDefault();
var sp_docLoc = docLoc.Split(':');
var p1 = sp_docLoc[0].Trim();
var srvLoc =
db.Set<DOCSERVER>().
Where(x => x.DOCSERVER1.Equals(p1, StringComparison.OrdinalIgnoreCase)
).Select(y => y.LOCATION).ToList().FirstOrDefault();
var result = string.Format("{0}{1}", srvLoc, sp_docLoc[1]);
return result;
}
}
}
public static Genre GetGenre(int id)
{
using (IMDbContext db = new IMDbContext())
{
return(db.Genre.Find(id));
}
}
public static List <Genre> GetAllGenres()
{
using (IMDbContext db = new IMDbContext())
{
return(db.Genre.Where(g => g.IsDeleted == false).OrderBy(g => g.GenreName).ToList());
}
}
public static List <Director> GetAllDirectors()
{
using (IMDbContext db = new IMDbContext())
{
return(db.Director.Where(d => d.IsDeleted == false).ToList());
}
}
public static void DeleteDirector(int id)
{
using (IMDbContext db = new IMDbContext())
{
var result = db.Director.Find(id);
result.IsDeleted = true;
db.SaveChanges();
}
}
public static void UpdateDirector(int id, string name)
{
using (IMDbContext db = new IMDbContext())
{
var result = db.Director.Find(id);
result.DirectorName = name;
db.SaveChanges();
}
}
public static void AddDirector(Director director)
{
using (IMDbContext db = new IMDbContext())
{
if (db.Director.SingleOrDefault(d => d.DirectorName == director.DirectorName) == null)
{
db.Director.Add(director);
db.SaveChanges();
}
}
}
public static void UpdateMovieScore(Movie movie)
{
using (IMDbContext db = new IMDbContext())
{
var uptadedMovie = db.Movie.Find(movie.MovieID);
uptadedMovie.Score = movie.Score;
uptadedMovie.totalScore = movie.totalScore;
uptadedMovie.ScoreCounter = movie.ScoreCounter;
db.SaveChanges();
}
}
public static void AddGenre(Genre genre)
{
using (IMDbContext db = new IMDbContext())
{
var result = db.Genre.FirstOrDefault(g => g.GenreName == genre.GenreName);
if (result == null)
{
db.Genre.Add(genre);
db.SaveChanges();
}
}
}
public static List <ViewMovie> GetAllMoviesByDirector(int directorID)
{
using (IMDbContext db = new IMDbContext())
{
return(db.Movie
.Where(m => m.DirectorID == directorID && m.IsDeleted == false).
Select(m => new ViewMovie
{
DirectorID = m.DirectorID,
DirectorName = m.Director.DirectorName,
MovieID = m.MovieID,
MovieName = m.MovieName,
ReleaseDate = m.ReleaseDate,
}).ToList());
}
}
public static ViewMovie GetViewMovie(int id)
{
using (IMDbContext db = new IMDbContext())
{
return(db.Movie.Where(m => m.MovieID == id)
.Select(m => new ViewMovie
{
MovieID = m.MovieID,
MovieName = m.MovieName,
Description = m.Description,
ReleaseDate = m.ReleaseDate,
Score = m.Score,
ScoreCounter = m.ScoreCounter,
GenreName = m.Genre.GenreName,
DirectorName = m.Director.DirectorName,
}).FirstOrDefault());
}
}
public static void AddMovie(ViewMovie vm)
{
using (IMDbContext db = new IMDbContext())
{
Movie newMovie = new Movie()
{
MovieName = vm.MovieName,
Description = vm.Description,
ReleaseDate = vm.ReleaseDate,
Score = vm.Score,
ScoreCounter = vm.ScoreCounter,
totalScore = vm.TotalScore,
GenreID = db.Genre.FirstOrDefault(g => g.GenreName == vm.GenreName).GenreID,
DirectorID = db.Director.FirstOrDefault(d => d.DirectorName == vm.DirectorName).DirectorID
};
db.Movie.Add(newMovie);
db.SaveChanges();
}
}
public static void UpdateMovie(ViewMovie vm)
{
using (IMDbContext db = new IMDbContext())
{
var uptadedMovie = db.Movie.Find(vm.MovieID);
uptadedMovie.MovieName = vm.MovieName;
uptadedMovie.DirectorID = db.Director.FirstOrDefault(d => d.DirectorName == vm.DirectorName).DirectorID;
uptadedMovie.GenreID = db.Genre.FirstOrDefault(g => g.GenreName == vm.GenreName).GenreID;
uptadedMovie.Description = vm.Description;
uptadedMovie.ReleaseDate = vm.ReleaseDate;
uptadedMovie.Score = vm.Score;
uptadedMovie.totalScore = vm.TotalScore;
uptadedMovie.ScoreCounter = vm.ScoreCounter;
db.SaveChanges();
}
}
public static List <ViewMovie> GetAllMoviesByDescYear()
{
using (IMDbContext db = new IMDbContext())
{
return(db.Movie
.Where(m => m.IsDeleted == false)
.OrderByDescending(m => m.ReleaseDate)
.Select(m => new ViewMovie
{
MovieID = m.MovieID,
MovieName = m.MovieName,
DirectorID = m.DirectorID,
DirectorName = m.Director.DirectorName,
GenreID = m.GenreID,
GenreName = m.Genre.GenreName,
Score = m.Score,
ReleaseDate = m.ReleaseDate,
}).ToList());
}
}
public static List <ViewMovie> GetAllMovies()
{
using (IMDbContext db = new IMDbContext())
{
return(db.Movie
.Where(m => m.IsDeleted == false)
.Select(m => new ViewMovie
{
MovieID = m.MovieID,
MovieName = m.MovieName,
Description = m.Description,
ReleaseDate = m.ReleaseDate,
Score = m.Score,
ScoreCounter = m.ScoreCounter,
DirectorID = m.DirectorID,
GenreID = m.GenreID,
GenreName = m.Genre.GenreName,
DirectorName = m.Director.DirectorName,
})
.ToList());
}
}
public BaseRepository(IMDbContext context, AuthenticatedUser user)
{
_context = context;
_dbSet = context.Set <TEntity>();
_user = user;
}
public VotoRepository(IMDbContext db) : base(db)
{
}
public MovieRepository(IMDbContext context, AuthenticatedUser user) : base(context, user)
{
_context = context;
}
public UnitOfWork(IMDbContext context)
{
_context = context;
}
public UsuarioRepository(IMDbContext db) : base(db)
{
}
public static int? Upload(IMInstance iMInstance, string engNum, string fileNameWithLocalPath, string iMFolderPath)
{
if (!File.Exists(fileNameWithLocalPath))
return null;
var projectIdForEngNum = GetWsId(iMInstance, new List<string> { engNum });
if (projectIdForEngNum.Count == 0)
return null;
var iMSession = new IMSession(iMInstance);
var wsId = IM.Wrapper.Utility.IMUtility.GetWsObjectID(iMInstance, iMSession, IMWSObjectType.Workspace, (double)projectIdForEngNum[0].EngId);
IManWorkspace imWs = iMInstance.UseAdmin.GetValueOrDefault(false) ?
(IManWorkspace)iMSession.AdminSession().DMS.GetObjectByID(wsId) :
(IManWorkspace)iMSession.UserSession().DMS.GetObjectByID(wsId);
if (iMFolderPath.StartsWith("/") || iMFolderPath.StartsWith("\\"))
{
iMFolderPath = iMFolderPath.Substring(1);
}
IManDocumentFolder imFldr = GetIMDocFolder(imWs, iMFolderPath);
if (imFldr == null)
return null;
IManDocument imDoc = imFldr.Database.CreateDocument();
imDoc.SetAttributeByID(imProfileAttributeID.imProfileDescription, Path.GetFileName(fileNameWithLocalPath));
imDoc.SetAttributeByID(imProfileAttributeID.imProfileType, GetIMDocType(imWs, Convert.ToString(imDoc.GetAttributeValueByID(imProfileAttributeID.imProfileDescription))));
//imDoc.SetAttributeByID(imProfileAttributeID.imProfileAuthor, imWs.Owner.Name);
//imDoc.SetAttributeByID(imProfileAttributeID.imProfileOperator, imWs.Owner.Name);
imDoc.SetAttributeByID(imProfileAttributeID.imProfileAuthor, iMInstance.UserId);
imDoc.SetAttributeByID(imProfileAttributeID.imProfileOperator, iMInstance.UserId);
//imDoc.SetAttributeByID(imProfileAttributeID.imProfileLastUser, iMInstance.UserId);
imDoc.SetAttributeByID(imProfileAttributeID.imProfileClass, IMConst.CONST_IMPROFILECLASS);
imDoc.SetAttributeByID(imProfileAttributeID.imProfileCustom7, IMConst.CONST_IMPROFILECUSTOM7);
imDoc.SetAttributeByID(imProfileAttributeID.imProfileCustom1,
imWs.Profile.GetAttributeValueByID(imProfileAttributeID.imProfileCustom1).ToString());
imDoc.SetAttributeByID(imProfileAttributeID.imProfileCustom2,
imWs.Profile.GetAttributeValueByID(imProfileAttributeID.imProfileCustom2).ToString());
var engFunction = imWs.Profile.GetAttributeValueByID(imProfileAttributeID.imProfileCustom3).ToString();
if (!string.IsNullOrWhiteSpace(engFunction))
{
imDoc.SetAttributeByID(imProfileAttributeID.imProfileCustom3, engFunction);
}
else
{
imDoc.SetAttributeByID(imProfileAttributeID.imProfileCustom3, IMConst.CONST_IMPROFILECUSTOM3);
}
foreach (IManAdditionalProperty imAddProp in imFldr.AdditionalProperties)
{
if (imAddProp == null)
continue;
int attID = Convert.ToInt32(imAddProp.Name.Substring(imAddProp.Name.LastIndexOf('_') + 1));
imProfileAttributeID imProfAttr = (imProfileAttributeID)attID;
if (imProfAttr != imProfileAttributeID.imProfileAuthor && imProfAttr != imProfileAttributeID.imProfileAuthorDescription &&
imProfAttr != imProfileAttributeID.imProfileOperator && imProfAttr != imProfileAttributeID.imProfileOperatorDescription &&
imProfAttr != imProfileAttributeID.imProfileLastUser && imProfAttr != imProfileAttributeID.imProfileLastUserDescription)
{
}
else
{
continue;
}
if (imAddProp.Value != IMConst.CONST_WORKSPACE_VALUE)
{
//Date
if (imProfAttr == imProfileAttributeID.imProfileCustom21 ||
imProfAttr == imProfileAttributeID.imProfileCustom22 ||
imProfAttr == imProfileAttributeID.imProfileCustom23 ||
imProfAttr == imProfileAttributeID.imProfileCustom24)
{
DateTime parsedTime;
if (DateTime.TryParse(imAddProp.Value, out parsedTime))
{
imDoc.SetAttributeByID(imProfAttr, parsedTime);
}
else
{
imDoc.SetAttributeByID(imProfAttr, null);
}
}
//Boolean
else if (imProfAttr == imProfileAttributeID.imProfileCustom25 ||
imProfAttr == imProfileAttributeID.imProfileCustom26 ||
imProfAttr == imProfileAttributeID.imProfileCustom27 ||
imProfAttr == imProfileAttributeID.imProfileCustom28)
{
if (imAddProp.Value != null && imAddProp.Value.ToLower() == "true")
{
imDoc.SetAttributeByID(imProfAttr, true);
}
else
{
imDoc.SetAttributeByID(imProfAttr, false);
}
}
else
{
imDoc.SetAttributeByID(imProfAttr, imAddProp.Value);
}
}
else
{
imDoc.SetAttributeByID(imProfAttr, imFldr.Workspace.Profile.GetAttributeValueByID(imProfAttr));
}
}
IManCheckinResult checkInResult = imDoc.CheckInWithResults(fileNameWithLocalPath, imCheckinDisposition.imCheckinNewDocument, imCheckinOptions.imDontKeepCheckedOut);
if (checkInResult.Succeeded)
{
AddSecurityToDoc(imDoc, imFldr);
IManDocuments imDocs = (IManDocuments)imFldr.Contents;
if (null != imDocs)
{
imDocs.AddDocumentReference(checkInResult.Result);
}
if (iMInstance.UseAdmin.GetValueOrDefault(false))
{
using (var db = new IMDbContext(iMInstance))
{
var original = db.DOCMASTER.Find(imDoc.Number, 1);
//original.OPERATOR = iMInstance.UserId;
//original.AUTHOR = iMInstance.UserId;
original.LASTUSER = iMInstance.UserId;
db.SaveChanges();
}
}
return imDoc.Number;
}
else
{
return null;
}
}
public UserRepository(IMDbContext iMDbContext)
{
_iMDbContext = iMDbContext;
}
protected Repository(IMDbContext db)
{
_db = db;
_dbSet = _db.Set <TEntity>();
}
public AdministradorRepository(IMDbContext db) : base(db)
{
}
public Repository(IMDbContext repositoryContext)
{
this.RepositoryContext = repositoryContext;
}
public BatchRepository(IMDbContext dbContext)
{
this.dbContext = dbContext;
}
public AssetRepository(ILogger <AssetRepository> logger, IMDbContext imDbContext, IAssetPropertySetter assetPropertySetter)
{
this.logger = logger;
this.imDbContext = imDbContext;
this.assetPropertySetter = assetPropertySetter;
}
public MovieRepository(IMDbContext iMDbContext)
{
_iMDbContext = iMDbContext;
}
private static dynamic GetWsId(IMInstance iMInstance, List<string> engNums)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDbContext(iMInstance))
{
var result = (
from dm in db.Set<DOCMASTER>()
join prj in db.Set<PROJECT>() on
dm.DOCNUM equals prj.DOCNUM
where
engNums.Contains(dm.C2ALIAS) &&
dm.C_ALIAS.Equals("WEBDOC", StringComparison.OrdinalIgnoreCase) &&
dm.DOCNAME.Equals("", StringComparison.OrdinalIgnoreCase)
select new { EngNum = dm.C2ALIAS, EngId = prj.PRJ_ID }).ToList();
return result;
}
}
}
