public static List <Director> GetAllDirectors()
{
using (IMDBContext db = new IMDBContext())
{
return(db.Director.ToList());
}
}
public static List <Entity.Model.Type> GetAllTypes()
{
using (IMDBContext db = new IMDBContext())
{
return(db.Type.ToList());
}
}
public static string GetDocLocation(string engNum, double docNum)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDBContext())
{
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 Film GetFilm(int id)
{
using (IMDBContext db = new IMDBContext())
{
return(db.Film.Find(id));
}
}
public static Director GetDirector(int id)
{
using (IMDBContext db = new IMDBContext())
{
return(db.Director.Find(id));
}
}
public static void DeleteFilm(int id)
{
using (IMDBContext db = new IMDBContext())
{
db.Film.Remove(db.Film.Find(id));
db.SaveChanges();
}
}
public static void AddDirector(Director _director)
{
using (IMDBContext db = new IMDBContext())
{
db.Director.Add(_director);
db.SaveChanges();
}
}
public static void AddType(Entity.Model.Type _type)
{
using (IMDBContext db = new IMDBContext())
{
db.Type.Add(_type);
db.SaveChanges();
}
}
public static void DeleteDirector(int id)
{
using (IMDBContext db = new IMDBContext())
{
db.Director.Remove(db.Director.Find(id));
db.SaveChanges();
}
}
public static void UpdateDirector(Director _director)
{
using (IMDBContext db = new IMDBContext())
{
var result = db.Director.Find(_director.DirectorID);
result.DirectorName = _director.DirectorName;
db.SaveChanges();
}
}
public static void GiveVote(int id, double point)
{
using (IMDBContext db = new IMDBContext())
{
var result = db.Film.Find(id);
result.PointCount += 1;
result.Point = ((result.Point * (result.PointCount - 1)) + point) / (result.PointCount);
db.SaveChanges();
}
}
public static void UpdateFilm(Film _film)
{
using (IMDBContext db = new IMDBContext())
{
var result = db.Film.Find(_film.FilmID);
result.Description = _film.Description;
result.DirectorID = _film.DirectorID;
result.FilmName = _film.FilmName;
result.TypeID = _film.TypeID;
db.SaveChanges();
}
}
public static List <VMFilm> GetFilmsByType(int id)
{
using (IMDBContext db = new IMDBContext())
{
return(db.Film.Where(f => f.TypeID == id).Select(f => new VMFilm()
{
DirectorName = f.Director.DirectorName,
FilmName = f.FilmName,
FilmID = f.FilmID,
Point = f.Point,
TypeName = f.Type.TypeName
}).ToList());
}
}
public static List <VMFilm> GetFilteredFilms(int directorID, int typeID)
{
using (IMDBContext db = new IMDBContext())
{
return(db.Film.Where(f => f.DirectorID == directorID && f.TypeID == typeID).Select(f => new VMFilm()
{
DirectorName = f.Director.DirectorName,
FilmID = f.FilmID,
FilmName = f.FilmName,
Point = f.Point,
TypeName = f.Type.TypeName
}).ToList());
}
}
public static List <Entity.Model.ViewModel.VMFilm> GetAllFilms()
{
using (IMDBContext db = new IMDBContext())
{
return(db.Film.OrderByDescending(f => f.Point).Select(f => new Entity.Model.ViewModel.VMFilm()
{
DirectorName = f.Director.DirectorName,
FilmID = f.FilmID,
FilmName = f.FilmName,
Point = f.Point,
TypeName = f.Type.TypeName
}).ToList());
}
}
public static void AddFilm(Film _film)
{
using (IMDBContext db = new IMDBContext())
{
db.Film.Add(_film);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
//Exception - Tarih seçilmedi!
}
}
}
public static void AddUserInC6(IManUser manager)
{
using (var db = new IMDBContext())
{
db.CUSTOM6.Add(new CUSTOM6
{
CUSTOM_ALIAS = manager.Custom1,
C_DESCRIPT = manager.FullName,
EDITWHEN = KConfig.GetKDateTimeUTC,
ENABLED = "Y",
IS_HIPAA = "N"
});
db.SaveChanges();
}
}
public static void AddEngInC2(string num, string engDescription, string clientId)
{
using (var db = new IMDBContext())
{
db.CUSTOM2.Add(new CUSTOM2
{
CPARENT_ALIAS = clientId,
CUSTOM_ALIAS = num,
C_DESCRIPT = engDescription,
EDITWHEN = KConfig.GetKDateTimeUTC,
ENABLED = "Y",
IS_HIPAA = "N"
});
db.SaveChanges();
}
}
public ActionResult AddNewActor(String name, String sex, String dob, String bio)
{
Actor actor = new Actor();
actor.Name = name;
actor.Sex = sex;
actor.DOB = Convert.ToDateTime(dob);
actor.Bio = bio;
try
{
using (IMDBContext db = new IMDBContext())
{
db.Actors.Add(actor);
db.SaveChanges();
}
}
catch (Exception e)
{
}
return(Json(new { Success = true }));
}
public WatchListController(IMDBContext context, IMemoryCache memoryCache) : base(context, memoryCache)
{
_context = context;
}
public BaseController(IMDBContext context)
{
_context = context;
}
public AdminLoginController(IMDBContext blogcontext)
{
_context = blogcontext;
}
public Repository(IMDBContext context)
{
this.context = context;
}
public static string GetUserIdFromC1Alias(string c1Alias)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDBContext())
{
var result = db.DOCUSERS.Where(x => x.CUSTOM1.Equals(c1Alias, StringComparison.OrdinalIgnoreCase)).Select(x => x.USERID).FirstOrDefault();
return result;
}
}
}
public WatchListController(IMDBContext context) : base(context)
{
_context = context;
}
public GenerosController(IMDBContext context)
{
_context = context;
}
public BaseController(IMDBContext context, IMemoryCache memoryCache)
{
_context = context;
_memoryCache = memoryCache;
}
public UnitOfWork(IMDBContext context)
{
_context = context;
}
public IMDBRepositoryTwo(IMDBContext Context)
{
this._imdbContext = Context;
}
public static bool IsEngInC2(string num, string clientId)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDBContext())
{
var result = db.CUSTOM2.Where(x => x.CPARENT_ALIAS.Equals(clientId, StringComparison.OrdinalIgnoreCase) && x.CUSTOM_ALIAS.Equals(num, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
return result != null;
}
}
}
public static bool IsPartnerInC4(string partnerEmpId)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDBContext())
{
var result = db.CUSTOM4.Where(x => x.CUSTOM_ALIAS.Equals(partnerEmpId, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
return result != null;
}
}
}
public static void SetCOMINDEXtoY(double num)
{
using (var db = new IMDBContext())
{
var original = db.DOCMASTERs.Find(num, 1 );
original.COMINDEX = "Y";
db.SaveChanges();
}
}
public UserController(IMDBContext context) : base(context)
{
_context = context;
}
public ProductRepository(IMDBContext context) => _context = context;
public AdminController(IMDBContext context, IMemoryCache memoryCache) : base(context, memoryCache)
{
_context = context;
}
public CommentController(IMDBContext context, IMemoryCache memoryCache) : base(context, memoryCache)
{
_context = context;
}
public static double? GetPrjIdForEng(string num)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted }))
{
using (var db = new IMDBContext())
{
var result = db.Set<PROJECT>().Include("DOCMASTER")
.Where(x => x.DOCMASTER.C2ALIAS.Equals(num, StringComparison.OrdinalIgnoreCase)
&& x.DOCMASTER.C_ALIAS.Equals("WEBDOC", StringComparison.OrdinalIgnoreCase)
&& x.DOCMASTER.DOCNAME.Equals(string.Empty, StringComparison.OrdinalIgnoreCase)
).FirstOrDefault();
if (result == null)
return null;
else
return result.PRJ_ID;
}
}
}
public FilmeGeneroesController(IMDBContext context)
{
_context = context;
}
