void AddTypeToCache(FilmType type)
{
if (!_types.ContainsKey(type.Type))
{
_types[type.Type] = type;
}
}
public PartialViewResult FilmTypeDetail(int id)
{
FilmType flm = new FilmType();
flm = _serviceFilmType.GetById(id);
flm.TypeName = flm.TypeName;
flm.Movies = flm.Movies;
return PartialView("Partial/_FilmTypeDetail", flm);
}
public Movie(string name, string genre, int minPrice, string imagePath, FilmType type)
{
this.name = name;
this.genre = genre;
this.minPrice = minPrice;
this.minAge = 0;
this.imagePath = imagePath;
this.type = type;
}
public PartialViewResult FilmTypeDetail(int id)
{
FilmType flm = new FilmType();
flm = _serviceFilmType.GetById(id);
flm.TypeName = flm.TypeName;
flm.Movies = flm.Movies;
return(PartialView("Partial/_FilmTypeDetail", flm));
}
public static int CreateNewBonus(FilmType type)
{
switch (type)
{
case FilmType.NewRelease:
return(2);
default:
return(1);
}
}
public ActionResult FilmTypeAdd(FilmType FilmType)
{
if (Session["account"] != null)
{
_serviceFilmType.Insert(FilmType);
return RedirectToAction("FilmTypeListele", "FilmType");
}
else
return RedirectToAction("Login", "User");
}
public ActionResult Create([Bind(Include = "Id,Name")] FilmType filmType)
{
if (ModelState.IsValid)
{
db.FilmTypes.Add(filmType);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
return(View(filmType));
}
private void SetBonuses(User user, FilmType type, bool paidWithBonuses, int discountedDays)
{
if (paidWithBonuses)
{
user.AvailableBonus -= discountedDays * 25;
}
user.AvailableBonus += Calculation.CreateNewBonus(type);
rProxy.Set <User>(user);
}
public int CalculatePrice(FilmType filmType, int rentDaysCount)
{
if (rentDaysCount <= 0)
{
throw new WrongDaysCountException();
}
var calculation = this.priceCalculationFactory.CreateCalculation(filmType, rentDaysCount);
var price = calculation.Perform();
return(price);
}
private static Payment ProcessPayment(string customerName, FilmType filmType, int rentDaysCount)
{
if (domainService.CanCustomerPayByBonuses(customerName, filmType, rentDaysCount))
{
return(rentService.CreateBonusesRentPayment(filmType, rentDaysCount));
}
else
{
domainService.GainBonusPoints(customerName, filmType);
return(rentService.CreateEURRentPayment(filmType, rentDaysCount));
}
}
public Payment CreateEURRentPayment(FilmType filmType, int rentDaysCount)
{
if (rentDaysCount <= 0)
{
throw new WrongDaysCountException();
}
var price = CalculatePrice(filmType, rentDaysCount);
var payment = this.entityFactory.CreatePayment(price, Currency.EUR);
return(payment);
}
public ActionResult FilmTypeAdd(FilmType FilmType)
{
if (Session["account"] != null)
{
_serviceFilmType.Insert(FilmType);
return(RedirectToAction("FilmTypeListele", "FilmType"));
}
else
{
return(RedirectToAction("Login", "User"));
}
}
public Film CreateFilm(string name, FilmType type)
{
if (String.IsNullOrEmpty(name))
{
throw new RequiredFieldNotSpecified();
}
var film = this.entityFactory.CreateFilm(name, type);
this.filmRepository.Save(film);
return(film);
}
public ActionResult FilmType(int id)
{
checkLogin();
FilmType filmType = db.FilmTypes.Where(ft => ft.ID == id).SingleOrDefault();
ViewBag.FilmType = filmType.Name;
List <Film> listFilm = filmType.Films.ToList();;
listFilm.Reverse();
return(View(listFilm));
}
public Film ChangeFilmType(string name, FilmType type)
{
var film = GetFilmByName(name);
if (film == null)
{
throw new FilmWithSpecifiedNameDoesNotExistException();
}
film.ChangeType(type);
this.filmRepository.Save(film);
return(film);
}
public bool CanCustomerPayByBonuses(string customerName, FilmType filmType, int rentDaysCount)
{
if (filmType != FilmType.NewReleases)
{
return(false);
}
if (rentDaysCount <= 0)
{
throw new WrongDaysCountException();
}
var customer = this.customerRepository.Load(customerName);
return(customer.HasEnoughtBonusPoints(rentDaysCount));
}
public Payment CreateBonusesRentPayment(FilmType filmType, int rentDaysCount)
{
if (rentDaysCount <= 0)
{
throw new WrongDaysCountException();
}
if (filmType != FilmType.NewReleases)
{
throw new CannotPayWithBonusesForNonNewRelaeseFilmsException();
}
var price = Consts.BONUSPOINTS_PRICE * rentDaysCount;
var payment = this.entityFactory.CreatePayment(price, Currency.BonusPoints);
return(payment);
}
public static String GetDutchString(this FilmType ft)
{
switch (ft)
{
case FilmType.Children: return(Resources.Global.FilmOverView_Gerne_Children); // 0
case FilmType.Action: return(Resources.Global.FilmOverView_Gerne_Action); // 1
case FilmType.Comedy: return(Resources.Global.FilmOverView_Gerne_Comedy); // 2
case FilmType.Drama: return("Drama"); // 3
case FilmType.Horror: return("Horror"); // 4
default: return("ERROR");
}
}
public PriceCalculation CreateCalculation(FilmType filmType, int rentDaysCount)
{
switch (filmType)
{
case FilmType.NewReleases:
return(new NewReleasesCalculation(rentDaysCount));
case FilmType.RegularFilms:
return(new RegularFilmsCalculation(rentDaysCount));
case FilmType.OldFilms:
return(new OldFilmsCalculation(rentDaysCount));
default:
return(new RegularFilmsCalculation(rentDaysCount));
}
}
public Customer GainBonusPoints(string customerName, FilmType filmType)
{
var customer = this.customerRepository.Load(customerName);
if (filmType == FilmType.NewReleases)
{
customer.AddBonusPoints(2);
}
else
{
customer.AddBonusPoints(1);
}
this.customerRepository.Save(customer);
return(customer);
}
public ActionResult FilmTypeEdit(FilmType FilmType)
{
if (Session["account"] != null)
{
if (ModelState.IsValid)
{
FilmType guncellenenFilmType = _serviceFilmType.GetById(FilmType.Id);
guncellenenFilmType.TypeName = FilmType.TypeName;
guncellenenFilmType.Movies = FilmType.Movies;
_serviceFilmType.Update(guncellenenFilmType);
}
return(RedirectToAction("FilmTypeListele", "FilmType"));
}
else
{
return(RedirectToAction("Login", "User"));
}
}
public static decimal GetPrice(FilmType type, int durationDays, int daysDiscounted, bool useBonuses)
{
int tempDays;
if (durationDays == 0)
{
throw new Exception();
}
durationDays = useBonuses ? durationDays - daysDiscounted : durationDays;
if (durationDays < 1)
{
return(0);
}
switch (type)
{
case FilmType.NewRelease:
return(40M * durationDays);
case FilmType.Regular:
if (durationDays <= 3)
{
return(30M);
}
tempDays = durationDays - 3;
return((tempDays * 30) + 30);
default:
if (durationDays <= 5)
{
return(30M);
}
tempDays = durationDays - 5;
return((tempDays * 30) + 30);
}
}
public Film(string name, FilmType type)
{
this.Name = name;
this.Type = type;
}
private void frmMain_Load(object sender, EventArgs e)
{
Random rd = new Random();
string[] types = { "Korku", "Macera", "Gerilim", "Drama", "Polisiye", "Romantik", "Komedi" };
List <Film> LSTFilm = new List <Film>();
for (int i = 0; i < 10; i++)
{
Film Newfilm = new Film();
Newfilm.Name = FakeData.NameData.GetCompanyName();
Newfilm.PublishDate = FakeData.DateTimeData.GetDatetime();
Newfilm.ImdbPoint = FakeData.NumberData.GetNumber(1, 9);
Newfilm.PosterImgPath = "../../images/r" + FakeData.TextData.GetNumeric(1) + ".jpg";
Newfilm.Website = FakeData.NetworkData.GetDomain();
List <FilmType> LSTFlmtyp = new List <FilmType>();
for (int k = 0; k < 6; k++)
{
FilmType newflmtyp = new FilmType();
newflmtyp.TypeName = types[k];
newflmtyp.Movies = LSTFilm;
LSTFlmtyp.Add(newflmtyp);
_serviceFilmType.Insert(newflmtyp);
}
Newfilm.FilmTypes = LSTFlmtyp;
List <Actor> LSTActr = new List <Actor>();
for (int k = 0; k < 5; k++)
{
Actor act = new Actor();
act.Name = FakeData.NameData.GetFirstName();
act.Surname = FakeData.NameData.GetSurname();
act.BirthDate = FakeData.DateTimeData.GetDatetime();
act.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
act.Movies = LSTFilm;
LSTActr.Add(act);
_serviceActor.Insert(act);
}
Newfilm.Actors = LSTActr;
List <Director> LSTDrt = new List <Director>();
for (int m = 0; m < 5; m++)
{
Director drt = new Director();
drt.Name = FakeData.NameData.GetFirstName();
drt.Surname = FakeData.NameData.GetSurname();
drt.BirthDate = FakeData.DateTimeData.GetDatetime();
drt.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
drt.Movies = LSTFilm;
LSTDrt.Add(drt);
_serviceDirector.Insert(drt);
}
Newfilm.Directors = LSTDrt;
List <Writer> LSTWrt = new List <Writer>();
for (int m = 0; m < 5; m++)
{
Writer wrt = new Writer();
wrt.Name = FakeData.NameData.GetFirstName();
wrt.Surname = FakeData.NameData.GetSurname();
wrt.BirthDate = FakeData.DateTimeData.GetDatetime();
wrt.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
wrt.Movies = LSTFilm;
LSTWrt.Add(wrt);
_serviceWriter.Insert(wrt);
}
Newfilm.Writers = LSTWrt;
List <Producer> LSTPrd = new List <Producer>();
for (int m = 0; m < 5; m++)
{
Producer prd = new Producer();
prd.ChairManName = FakeData.NameData.GetFullName();
prd.CompanyName = FakeData.NameData.GetCompanyName();
prd.FormDate = FakeData.DateTimeData.GetDatetime();
prd.CompanyAddress = FakeData.PlaceData.GetAddress();
prd.WebSite = FakeData.NetworkData.GetDomain();
prd.Movies = LSTFilm;
LSTPrd.Add(prd);
_serviceProducer.Insert(prd);
}
Newfilm.Producers = LSTPrd;
LSTFilm.Add(Newfilm);
_serviceFilm.Insert(Newfilm);
}
for (int i = 0; i < 5; i++)
{
User usr = new User();
usr.Name = FakeData.NameData.GetFirstName();
usr.Surname = FakeData.NameData.GetSurname();
usr.BirthDate = FakeData.DateTimeData.GetDatetime();
usr.Email = FakeData.NetworkData.GetEmail();
usr.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
usr.Password = "******";
usr.Role = (ProjectTemplate.Core.Enums.Role)(rd.Next(0, 1));
_serviceUser.Insert(usr);
}
MessageBox.Show("Veri Eklendi");
dataGridView1.DataSource = _serviceFilm.GetAll();
}
public async Task <SearchResult> FindFilmsAsync(string name, TimeSpan timeout, string year = null, FilmType type = FilmType.movie, CancellationToken cancellation = default)
{
var queryString = HttpUtility.ParseQueryString(string.Empty);
queryString.Add("name", name);
queryString.Add("year", year);
queryString.Add("type", type.ToString());
var request = new HttpRequestMessage(HttpMethod.Get, $"/Films/FindByPrefix?{queryString}");
request.Headers.Add("Timeout", timeout.Ticks.ToString());
var response = await httpClient.SendAsync(request, cancellation).ConfigureAwait(false);
response.EnsureSuccessStatusCode();
return(await response.Content.ReadAsAsync <SearchResult>(cancellation).ConfigureAwait(false));
}
private void frmMain_Load(object sender, EventArgs e)
{
Random rd = new Random();
string[] types = { "Korku", "Macera", "Gerilim", "Drama", "Polisiye", "Romantik", "Komedi" };
List<Film> LSTFilm = new List<Film>();
for (int i = 0; i < 10; i++)
{
Film Newfilm = new Film();
Newfilm.Name = FakeData.NameData.GetCompanyName();
Newfilm.PublishDate = FakeData.DateTimeData.GetDatetime();
Newfilm.ImdbPoint = FakeData.NumberData.GetNumber(1, 9);
Newfilm.PosterImgPath = "../../images/r" + FakeData.TextData.GetNumeric(1) + ".jpg";
Newfilm.Website = FakeData.NetworkData.GetDomain();
List<FilmType> LSTFlmtyp = new List<FilmType>();
for (int k = 0; k < 6; k++)
{
FilmType newflmtyp = new FilmType();
newflmtyp.TypeName = types[k];
newflmtyp.Movies = LSTFilm;
LSTFlmtyp.Add(newflmtyp);
_serviceFilmType.Insert(newflmtyp);
}
Newfilm.FilmTypes = LSTFlmtyp;
List<Actor> LSTActr = new List<Actor>();
for (int k = 0; k < 5; k++)
{
Actor act = new Actor();
act.Name = FakeData.NameData.GetFirstName();
act.Surname = FakeData.NameData.GetSurname();
act.BirthDate = FakeData.DateTimeData.GetDatetime();
act.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
act.Movies = LSTFilm;
LSTActr.Add(act);
_serviceActor.Insert(act);
}
Newfilm.Actors = LSTActr;
List<Director> LSTDrt = new List<Director>();
for (int m = 0; m < 5; m++)
{
Director drt = new Director();
drt.Name = FakeData.NameData.GetFirstName();
drt.Surname = FakeData.NameData.GetSurname();
drt.BirthDate = FakeData.DateTimeData.GetDatetime();
drt.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
drt.Movies = LSTFilm;
LSTDrt.Add(drt);
_serviceDirector.Insert(drt);
}
Newfilm.Directors = LSTDrt;
List<Writer> LSTWrt = new List<Writer>();
for (int m = 0; m < 5; m++)
{
Writer wrt = new Writer();
wrt.Name = FakeData.NameData.GetFirstName();
wrt.Surname = FakeData.NameData.GetSurname();
wrt.BirthDate = FakeData.DateTimeData.GetDatetime();
wrt.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
wrt.Movies = LSTFilm;
LSTWrt.Add(wrt);
_serviceWriter.Insert(wrt);
}
Newfilm.Writers = LSTWrt;
List<Producer> LSTPrd = new List<Producer>();
for (int m = 0; m < 5; m++)
{
Producer prd = new Producer();
prd.ChairManName = FakeData.NameData.GetFullName();
prd.CompanyName = FakeData.NameData.GetCompanyName();
prd.FormDate = FakeData.DateTimeData.GetDatetime();
prd.CompanyAddress = FakeData.PlaceData.GetAddress();
prd.WebSite = FakeData.NetworkData.GetDomain();
prd.Movies = LSTFilm;
LSTPrd.Add(prd);
_serviceProducer.Insert(prd);
}
Newfilm.Producers = LSTPrd;
LSTFilm.Add(Newfilm);
_serviceFilm.Insert(Newfilm);
}
for (int i = 0; i < 5; i++)
{
User usr = new User();
usr.Name = FakeData.NameData.GetFirstName();
usr.Surname = FakeData.NameData.GetSurname();
usr.BirthDate = FakeData.DateTimeData.GetDatetime();
usr.Email = FakeData.NetworkData.GetEmail();
usr.ImagePath = "../../images/gridallbum" + FakeData.TextData.GetNumeric(1) + ".jpg";
usr.Password = "******";
usr.Role = (ProjectTemplate.Core.Enums.Role)(rd.Next(0, 1));
_serviceUser.Insert(usr);
}
MessageBox.Show("Veri Eklendi");
dataGridView1.DataSource = _serviceFilm.GetAll();
}
public async Task GetSingleFilm_ShouldParseTvShow(int filmId, string nameRu, string nameOriginal, FilmType type)
{
using (_vcr.UseCassette($"{GetMethodName()}_{filmId}", RecordMode.NewEpisodes))
{
var apiClient = new KinopoiskApiClient(ApiToken, _loggerFactory.CreateLogger <KinopoiskApiClient>(), _clientFactoryMock.Object);
var res = await apiClient.GetSingleFilm(filmId);
Assert.NotNull(res);
Assert.Equal(type, res.Type);
Assert.Equal(nameRu, res.NameRu);
Assert.Equal(nameOriginal, res.NameOriginal);
}
}
public async Task <SearchResult> FindByNameAsync(string prefix, TimeSpan timeout, string year = null, FilmType type = FilmType.movie, CancellationToken cancellation = default)
{
var result = new SearchResult {
Films = Array.Empty <FilmData>()
};
var page = 1;
do
{
var queryString = HttpUtility.ParseQueryString(string.Empty);
queryString.Add("apikey", apikey);
queryString.Add("s", prefix);
queryString.Add("year", year);
queryString.Add("type", type.ToString());
queryString.Add("page", page++.ToString());
var request = new HttpRequestMessage(HttpMethod.Get, "?" + queryString);
request.Headers.Add("Timeout", timeout.Ticks.ToString());
var response = await httpClient.SendAsync(request, cancellation).ConfigureAwait(false);
response.EnsureSuccessStatusCode();
var content = await response.Content.ReadAsAsync <SearchResult>(cancellation).ConfigureAwait(false);
content.Films = content.Films?.Union(result.Films).ToArray();
result = content;
} while (result.Films.Length < result.TotalResults);
return(result);
}
public void SaveType(string filmId, string mode)
{
if (filmId == string.Empty)
{
return;
}
//放映模式下拉框所选择的模式内容
Array Array = mode.Replace(" ", "").Split(',');
foreach (string str in Array)
{
if (str == string.Empty)
{
continue;
}
//查找对应的模式记录
FilmType filmType = de.FilmType.Where(p => p.FilmTypeName == str).FirstOrDefault();
if (filmType != null)
{
Film_FilmType film_FilmType = de.Film_FilmType.Where(p => p.FilmId == filmId && p.FilmTypeId == filmType.FilmTypeId).FirstOrDefault();
//如果不存在，则进行新增操作
if (film_FilmType == null)
{
if (tmpFilm_FilmTypeList.Where(p => p.FilmId == filmId && p.FilmTypeId == filmType.FilmTypeId).FirstOrDefault() == null &&
de.Film_FilmType.Where(p => p.FilmId == filmId && p.FilmTypeId == filmType.FilmTypeId).FirstOrDefault() == null)
{
film_FilmType = new Film_FilmType();
film_FilmType.FilmTypeId = filmType.FilmTypeId;
film_FilmType.FilmId = filmId;
film_FilmType.Created = DateTime.Now;
film_FilmType.Updated = DateTime.Now;
film_FilmType.ActiveFlag = true;
film_FilmType.Film_FilmTypeId = MaxTypeId();
// de.Film_FilmMode.AddObject(film_FilmMode);
tmpFilm_FilmTypeList.Add(film_FilmType);
}
}
}
}
//找出该影片的所有模式关系记录
var list = de.Film_FilmType.Where(p => p.FilmId == filmId).ToList();
list.AddRange(tmpFilm_FilmTypeList);
//所有的放映模式
var filmFilmTypeList = de.FilmType.ToList();
foreach (var tmp in list)
{
//是否删除标志
bool del = true;
var obj = filmFilmTypeList.Find(p => p.FilmTypeId == tmp.FilmTypeId);
if (obj != null)
{
foreach (string str in Array)
{
if (obj.FilmTypeName == str)
{
del = false;
break;
}
}
if (del == true)
{
var deltmp = de.Film_FilmType.Where(p => p.Film_FilmTypeId == tmp.Film_FilmTypeId).FirstOrDefault();
if (deltmp != null)
{
de.Film_FilmType.DeleteObject(deltmp);
}
}
}
}
}
public void ChangeType(FilmType newType)
{
this.Type = newType;
}
public async Task <FilmFullData> GetByNameAsync(string name, TimeSpan timeout, string year = null, FilmType type = FilmType.movie, CancellationToken cancellation = default)
{
var queryString = HttpUtility.ParseQueryString(string.Empty);
queryString.Add("apikey", apikey);
queryString.Add("t", name);
queryString.Add("y", year);
queryString.Add("type", type.ToString());
var request = new HttpRequestMessage(HttpMethod.Get, "?" + queryString);
request.Headers.Add("Timeout", timeout.Ticks.ToString());
var response = await httpClient.SendAsync(request, cancellation).ConfigureAwait(false);
response.EnsureSuccessStatusCode();
return(await response.Content.ReadAsAsync <FilmFullData>(cancellation).ConfigureAwait(false));
}
public Film CreateFilm(string name, FilmType type)
{
return(new Film(name, type));
}
protected override void Seed(Context context)
{
Excel.Application ObjWorkExcel = new Excel.Application();
//string path = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"Spectare.xlsx");
Excel.Workbook ObjWorkBook = ObjWorkExcel.Workbooks.Open("D:/Ñ#/Spectare.UI/Spectare.Classes/Data/Spectare.xlsx", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Excel.Worksheet ObjWorkSheet1 = (Excel.Worksheet)ObjWorkBook.Sheets[1];
var lastCell1 = ObjWorkSheet1.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell);
int lastRow1 = (int)lastCell1.Row;
string[,] list1 = new string[lastCell1.Column, lastCell1.Row];
for (int i = 0; i < (int)lastCell1.Column; i++)
{
for (int j = 0; j < (int)lastCell1.Row; j++)
{
list1[i, j] = ObjWorkSheet1.Cells[j + 1, i + 1].Text.ToString();
}
}
Excel.Worksheet ObjWorkSheet2 = (Excel.Worksheet)ObjWorkBook.Sheets[2];
var lastCell2 = ObjWorkSheet2.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell);
int lastRow2 = (int)lastCell2.Row;
int lastColumn2 = (int)lastCell2.Column;
string[,] list2 = new string[lastCell2.Column, lastCell2.Row];
for (int i = 0; i < (int)lastCell2.Column; i++)
{
for (int j = 0; j < (int)lastCell2.Row; j++)
{
list2[i, j] = ObjWorkSheet2.Cells[j + 1, i + 1].Text.ToString();
}
}
Excel.Worksheet ObjWorkSheet3 = (Excel.Worksheet)ObjWorkBook.Sheets[3];
var lastCell3 = ObjWorkSheet3.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell);
int lastColumn3 = (int)lastCell3.Column;
int lastRow3 = (int)lastCell3.Row;
string[,] list3 = new string[lastCell3.Column, lastCell3.Row];
for (int i = 0; i < (int)lastCell3.Column; i++)
{
for (int j = 0; j < (int)lastCell3.Row; j++)
{
list3[i, j] = ObjWorkSheet3.Cells[j + 1, i + 1].Text.ToString();
}
}
Excel.Worksheet ObjWorkSheet4 = (Excel.Worksheet)ObjWorkBook.Sheets[4];
var lastCell4 = ObjWorkSheet4.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell);
int lastColumn4 = (int)lastCell4.Column;
int lastRow4 = (int)lastCell4.Row;
string[,] list4 = new string[lastCell4.Column, lastCell4.Row];
for (int i = 0; i < (int)lastCell4.Column; i++)
{
for (int j = 0; j < (int)lastCell4.Row; j++)
{
list4[i, j] = ObjWorkSheet4.Cells[j + 1, i + 1].Text.ToString();
}
}
ObjWorkBook.Close(false, Type.Missing, Type.Missing);
ObjWorkExcel.Quit();
GC.Collect();
for (int i = 0; i < lastRow1; i++)
{
User user = new User
{
Name = list1[0, i],
Email = list1[1, i],
Password = DbMethods.GetHash(list1[2, i]),
};
context.Users.AddOrUpdate(u => u.Name, user);
}
List <Film> films = new List <Film>();
List <Actor> actors = new List <Actor>();
List <FilmType> types = new List <FilmType>();
for (int j = 0; j < lastRow2; j++)
{
Film film = new Film
{
Title = list2[0, j],
Description = list2[1, j],
PosterLink = list2[2, j],
TrailerLink = list2[3, j],
WebLink = list2[4, j],
PhotoLink1 = list2[5, j],
PhotoLink2 = list2[6, j],
PhotoLink3 = list2[7, j],
Actors = new List <Actor>(),
Types = new List <FilmType>(),
};
films.Add(film);
}
for (int j = 0; j < lastRow3; j++)
{
Actor actor = new Actor
{
Name = list3[0, j],
Films = new List <Film>()
};
string FilmName;
for (int i = 0; i < lastColumn3 - 1; i++)
{
FilmName = list3[i + 1, j];
if (FilmName != "")
{
int k = 0;
while (k < films.Count && FilmName != films[k].Title)
{
k++;
}
if (k < films.Count)
{
actor.Films.Add(films[k]);
films[k].Actors.Add(actor);
}
}
}
actors.Add(actor);
}
for (int j = 0; j < lastRow4; j++)
{
FilmType type = new FilmType
{
Name = list4[0, j],
Films = new List <Film>()
};
string FilmName;
for (int i = 0; i < lastColumn4 - 1; i++)
{
FilmName = list4[i + 1, j];
if (FilmName != "")
{
int k = 0;
while (k < films.Count && FilmName != films[k].Title)
{
k++;
}
if (k < films.Count)
{
type.Films.Add(films[k]);
films[k].Types.Add(type);
}
}
}
types.Add(type);
}
for (int i = 0; i < films.Count; i++)
{
context.Films.AddOrUpdate(d => d.Title, films[i]);
}
for (int i = 0; i < actors.Count; i++)
{
context.Actors.AddOrUpdate(d => d.Name, actors[i]);
}
for (int i = 0; i < types.Count; i++)
{
context.Types.AddOrUpdate(d => d.Name, types[i]);
}
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
}
public ActionResult FilmTypeEdit(FilmType FilmType)
{
if (Session["account"] != null)
{
if (ModelState.IsValid)
{
FilmType guncellenenFilmType = _serviceFilmType.GetById(FilmType.Id);
guncellenenFilmType.TypeName = FilmType.TypeName;
guncellenenFilmType.Movies = FilmType.Movies;
_serviceFilmType.Update(guncellenenFilmType);
}
return RedirectToAction("FilmTypeListele", "FilmType");
}
else
return RedirectToAction("Login", "User");
}
