예제 #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if ((string)Session["allow"] != "1")
            {
                Response.Redirect("/Pages/Forbidden.aspx");
            }
            else
            {
                if (Request["did"] != null)
                {
                    CountriesDropDownList.DataSource     = Countries.GetAllCountries();
                    CountriesDropDownList.DataValueField = "CountryID";
                    CountriesDropDownList.DataTextField  = "Country";
                    CountriesDropDownList.DataBind();

                    Director d1 = Directors.GetDirectorByID(Request["did"]);

                    FirstNameTextBox.Text = d1.GetFirstName();
                    LastNameTextBox.Text  = d1.GetLastName();
                    BornYearTextBox.Text  = d1.GetBornYear().ToString();
                    CountriesDropDownList.SelectedValue = d1.GetBornCountry().ToString();

                    DirectorPhoto.ImageUrl = "/Pictures/Directors/" + d1.GetDirectorPhoto();
                }
            }
        }
    }
예제 #2
0
        /// <summary>
        /// Initializes a new instance of the <see cref="ListLogsModule"/> class.
        /// </summary>
        /// <param name="director">The director.</param>
        public ListLogsModule(Directors.IListLogsDirector director)
            : base("/runtime/Logs")
        {
            _director = director;

            Post["/ListFiles/{clientId}", runAsync: true] = ListLogFilesAsync;
        }
예제 #3
0
    protected void UpdateDirectorButton_Click(object sender, EventArgs e)
    {
        string firstName = FirstNameTextBox.Text.Trim();
        string lastName  = LastNameTextBox.Text.Trim();

        if (firstName != "" && lastName != "")
        {
            int country = int.Parse(CountriesDropDownList.SelectedValue);
            int bYear   = int.Parse(BornYearTextBox.Text.Trim());

            string pic = "";
            if (PhotoFileUpload.PostedFile != null)
            {
                if (PhotoFileUpload.PostedFile.FileName.Trim().Length > 0 && PhotoFileUpload.PostedFile.ContentLength > 0)
                {
                    pic = Path.GetFileName(PhotoFileUpload.PostedFile.FileName.Trim());

                    string dir  = Server.MapPath("~/Pictures/Directors/");
                    string file = Path.GetFileName(PhotoFileUpload.PostedFile.FileName.Trim());

                    PhotoFileUpload.PostedFile.SaveAs(dir + file);
                }
            }

            int DirectorID = int.Parse(Request["did"]);

            Director d1 = new Director(DirectorID, firstName, lastName, bYear, country, pic);

            Directors.UpdateDirector(d1);

            Response.Redirect("/Pages/OneDirector.aspx?did=" + DirectorID);
        }
    }
예제 #4
0
        /// <summary>
        /// Initializes a new instance of the <see cref="RecycleClientModule"/> class.
        /// </summary>
        /// <param name="director">The director.</param>
        public RecycleClientModule(Directors.IRecycleClientDirector director)
            : base("/runtime")
        {
            _director = director;

            Post["/RecycleClient/{clientId}", runAsync: true] = RecycleClientAsync;
        }
예제 #5
0
        public async Task <IActionResult> Create([Bind("Id,Name,Gender,Info,Photo,Age,Citizenship,Ethnicity,Educationlevel,Placeofeducation,Fieldofstudies,Fieldofstudies2,Titledarjah,Familytiesone,Familytiestwo,Professionalbody,Voluntarybody,Cweplc,Cwenonplc,Cwegovt,Cweacademic,Yearofbirth")] Directors directors)
        {
            if (ModelState.IsValid)
            {
                _context.Add(directors);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            ViewData["Citizenship"]      = new SelectList(_context.Citizenshiptable, "Id", "Citizentype", directors.Citizenship);
            ViewData["Cweacademic"]      = new SelectList(_context.Cweacadtable, "Id", "Positiontype", directors.Cweacademic);
            ViewData["Cwegovt"]          = new SelectList(_context.Cwegovtable, "Id", "Positiontype", directors.Cwegovt);
            ViewData["Cwenonplc"]        = new SelectList(_context.Cwenonplctable, "Id", "Positiontype", directors.Cwenonplc);
            ViewData["Cweplc"]           = new SelectList(_context.Cweplctable, "Id", "Positiontype", directors.Cweplc);
            ViewData["Educationlevel"]   = new SelectList(_context.Educationlevel, "Id", "Edulevel", directors.Educationlevel);
            ViewData["Ethnicity"]        = new SelectList(_context.Ethnicitytable, "Id", "Race", directors.Ethnicity);
            ViewData["Familytiesone"]    = new SelectList(_context.Familytiesonetable, "Id", "Id", directors.Familytiesone);
            ViewData["Familytiestwo"]    = new SelectList(_context.Familytiestwotable, "Id", "Id", directors.Familytiestwo);
            ViewData["Fieldofstudies"]   = new SelectList(_context.Fieldofstudiestable, "Id", "Fieldname", directors.Fieldofstudies);
            ViewData["Fieldofstudies2"]  = new SelectList(_context.Fieldofstudiestable, "Id", "Fieldname", directors.Fieldofstudies2);
            ViewData["Gender"]           = new SelectList(_context.Gendertable, "Id", "Gendertype", directors.Gender);
            ViewData["Placeofeducation"] = new SelectList(_context.Placeofeducationtable, "Id", "Place", directors.Placeofeducation);
            ViewData["Professionalbody"] = new SelectList(_context.Professionalbodytable, "Id", "Id", directors.Professionalbody);
            ViewData["Titledarjah"]      = new SelectList(_context.Titletable, "Id", "Id", directors.Titledarjah);
            ViewData["Voluntarybody"]    = new SelectList(_context.Voluntarybodytable, "Id", "Id", directors.Voluntarybody);
            return(View(directors));
        }
예제 #6
0
        public Task <Film[]> GetAllFilmsAsync(bool includeActors = false, bool includeDirector = false)
        {
            return(Task.Run(() =>
            {
                var result = Films.ToArray();
                if (includeActors && result != null && result.Count() > 0)
                {
                    foreach (var film in result)
                    {
                        if (film.Cast != null)
                        {
                            foreach (var actorFilm in film.Cast)
                            {
                                actorFilm.Actor = Actors.Where(a => a.Id == actorFilm.ActorId).SingleOrDefault();
                            }
                        }

                        if (includeDirector && result != null)
                        {
                            film.Director = Directors.Where(d => d.Id == film.DirectorId).SingleOrDefault();
                        }
                    }
                }

                return result;
            }));
        }
예제 #7
0
        private void updateObservableListings() /* call whenever adding/removing a movie from static list */
        {
            Genres.Clear();
            Directors.Clear();
            Actors.Clear();

            foreach (Genre genre in NeoSingleton._allGenres())
            {
                if (!Genres.Contains(genre.Name))
                {
                    Genres.Add(genre.Name);
                }
            }

            foreach (Director director in NeoSingleton._allDirectors())
            {
                if (!Directors.Contains(director.Name))
                {
                    Directors.Add(director.Name);
                }
            }

            foreach (Actor actor in NeoSingleton._allActors())
            {
                if (!Actors.Contains(actor.Name))
                {
                    Actors.Add(actor.Name);
                }
            }
        }
        public ActionResult InsertDirector(Directors dirDTO)
        {
            int row = mediaManager.InsertDirector(dirDTO.DirectorName);

            ViewDirectors();
            return(View("ViewDirectors"));
        }
예제 #9
0
        /// <summary>
        /// Copies the contained series information into MediaItemAspect.
        /// </summary>
        /// <param name="aspectData">Dictionary with extracted aspects.</param>
        public bool SetMetadata(IDictionary <Guid, MediaItemAspect> aspectData)
        {
            if (!IsCompleteMatch)
            {
                return(false);
            }

            MediaItemAspect.SetAttribute(aspectData, SeriesAspect.ATTR_SERIESNAME, Series);
            MediaItemAspect.SetAttribute(aspectData, SeriesAspect.ATTR_EPISODENAME, Episode);
            MediaItemAspect.SetAttribute(aspectData, SeriesAspect.ATTR_SEASON, SeasonNumber);
            MediaItemAspect.SetCollectionAttribute(aspectData, SeriesAspect.ATTR_EPISODE, EpisodeNumbers);

            if (!string.IsNullOrEmpty(Summary))
            {
                MediaItemAspect.SetAttribute(aspectData, VideoAspect.ATTR_STORYPLOT, Summary);
            }
            if (Directors.Count > 0)
            {
                MediaItemAspect.SetAttribute(aspectData, VideoAspect.ATTR_DIRECTOR, Directors.First());
            }
            if (Actors.Count > 0)
            {
                MediaItemAspect.SetCollectionAttribute(aspectData, VideoAspect.ATTR_ACTORS, Actors);
            }
            if (Genres.Count > 0)
            {
                MediaItemAspect.SetCollectionAttribute(aspectData, VideoAspect.ATTR_GENRES, Genres);
            }
            return(true);
        }
        public ActionResult UpdateDirector(Directors directorDTO)
        {
            int row = mediaManager.UpdateDirector(directorDTO.DirectorName, directorDTO.DID);

            ViewDirectors();
            return(View("ViewDirector"));
        }
예제 #11
0
        public async Task <IActionResult> Edit(int id, [Bind("ID,RoleDescription,Email,FirstName,LastName,TitleID, Biography")] Directors directors)
        {
            if (id != directors.ID)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(directors);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!DirectorsExists(directors.ID))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction("Index"));
            }
            ViewData["TitleID"] = new SelectList(_context.Title, "TitleID", "jobTitle");
            return(View(directors));
        }
예제 #12
0
        public async Task <IActionResult> Create([Bind("ID,RoleDescription,Email,FirstName,LastName,TitleID,Biography")] Directors directors)/* , ICollection<IFormFile> files)*/
        {
            if (ModelState.IsValid)
            {
                //var profilepics = Path.Combine(_environment.WebRootPath, "profilepics");
                //foreach (var file in files)
                //{
                //    if (file.Length > 0)
                //    {
                //        using (var fileStream = new FileStream(Path.Combine(profilepics, file.FileName), FileMode.Create))
                //        {
                //            await file.CopyToAsync(fileStream);
                //            directors.Image = file.FileName;
                //        }
                //    }
                //}



                _context.Add(directors);
                await _context.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            ViewData["TitleID"] = new SelectList(_context.Title, "TitleID", "jobTitle", directors.TitleID);
            return(View(directors));
        }
예제 #13
0
 private void FilmViewModel_PropertyChanged(object sender, PropertyChangedEventArgs e)
 {
     if (e.PropertyName == this.GetPropertyName(() => CurrentFilm))
     {
         if (CurrentFilm != null && CurrentFilm.FilmId != Guid.Empty)
         {
             FilmEdit        = new Film();
             FilmEdit.FilmId = CurrentFilm.FilmId;
             FilmEdit.Name   = CurrentFilm.Name;
             DirectorEdit    = Directors.Where(x => x.DirectorId == CurrentFilm.DirectorId).First();
             RaisePropertyChanged("DirectorEdit");
             FilmEdit.ReleaseDate = CurrentFilm.ReleaseDate;
             FilmEdit.Evaluation  = CurrentFilm.Evaluation;
             FilmEdit.RegisterPropertyChanged(Film_PropertyChanged);
         }
     }
     else if (e.PropertyName == this.GetPropertyName(() => DirectorEdit))
     {
         if (DirectorEdit != null)
         {
             FilmEdit.Director = new Director()
             {
                 DirectorId = DirectorEdit.DirectorId,
                 Name       = DirectorEdit.Name,
                 Firstname  = DirectorEdit.Firstname
             };
             FilmEdit.DirectorId = DirectorEdit.DirectorId;
         }
     }
     CheckCanDeleteFilm();
 }
예제 #14
0
        public OpenLogFileModule(Directors.IOpenLogFileDirector director)
            : base("/runtime/Logs")
        {
            _director = director;

            Post["/OpenLog/{clientId}", runAsync: true] = OpenLogFileAsync;
        }
예제 #15
0
        // GET: Directors/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Directors directors = db.Directors.Find(id);

            if (directors == null)
            {
                return(HttpNotFound());
            }
            var model = new DirectorsModel()
            {
                Id          = directors.Id,
                Name        = directors.Name,
                Surname     = directors.Surname,
                RetiredText = directors.Retired ? "Yes" : "No"
            };

            var viewModel = new DirectorsDetailsViewModel()
            {
                Director = model,
                Title    = _detailTitle
            };

            return(View(viewModel));
        }
예제 #16
0
        private void CreateAndReloadMovieDirectors()
        {
            foreach (var person in DirectorsEditList)
            {
                if (person.IsDirectorChecked)
                {
                    var director = Directors.FirstOrDefault(x => x.Id == person.Id);
                    if (director == null)
                    {
                        var movieDirector = new PersonDirectorDetailModel()
                        {
                            Id         = Guid.NewGuid(),
                            MovieId    = EditDetailModel.Id,
                            DirectorId = person.Id
                        };

                        _movieDirectorRepository.Create(movieDirector);
                        Directors.Add(person);
                    }
                }
                else
                {
                    var director = Directors.FirstOrDefault(x => x.Id == person.Id);
                    if (director != null)
                    {
                        _movieDirectorRepository.TryDeleteDirectorMovieRelation(EditDetailModel.Id, person.Id);
                        DeleteDirectorInDirectorListById(person.Id);
                    }
                }
            }
        }
예제 #17
0
        // GET: Directors/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Directors directors = db.Directors.Find(id);

            if (directors == null)
            {
                return(HttpNotFound());
            }
            var model = new DirectorsModel()
            {
                Id          = directors.Id,
                Name        = directors.Name,
                Surname     = directors.Surname,
                RetiredText = directors.Retired ? "Yes" : "No"
            };
            // _detailsTitle = "Mert"; // const kullanımı için örnek: Değişken const olarak tanımlandığı için hiç bir şekilde değiştirilemez...
            var viewModel = new DirectorsDetailsViewModel()
            {
                Director = model,
                Title    = _detailTitle // const kullanımı için örnek
            };

            return(View(viewModel));
        }
        public Directors PostDirector(Directors directors)
        {
            _dbContext.Directors.Add(directors);
            _dbContext.SaveChanges();

            return(directors);
        }
예제 #19
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string id = Request["did"];

        if (Request["ddid"] != null)
        {
            if (Request["ddid"] == "1")
            {
                Directors.DeleteDirector(id);
                Response.Redirect("/Pages/AllDirectors.aspx");
            }
        }

        d1 = Directors.GetDirectorByID(id);

        Page.Title             = d1.GetName();
        NameLabel1.Text        = d1.GetName();
        NameLabel2.Text        = d1.GetName();
        bornYear.Text          = d1.GetBornYear().ToString();
        bornCountry.Text       = Countries.GetCountryByID(d1.GetBornCountry().ToString()).GetCountryName();
        DirectorPhoto.ImageUrl = "../Pictures/Directors/" + d1.GetDirectorPhoto();
        ContryFlag.ImageUrl    = "../Pictures/CountryFlag/" + Countries.GetCountryByID(d1.GetBornCountry().ToString()).GetFlag();
        moviesLinks.Text       = Movies.GetMoviesLinkByDirectorID(id);

        if ((string)Session["allow"] == "1")
        {
            UpdateHyperLink.Visible     = true;
            SlashLabel.Visible          = true;
            DeleteHyperLink.Visible     = true;
            UpdateHyperLink.NavigateUrl = "/Admin/UpdateDirector.aspx?did=" + d1.GetID();
            DeleteHyperLink.NavigateUrl = "/Pages/OneDirector.aspx?did=" + d1.GetID() + "&ddid=1";
        }
    }
예제 #20
0
파일: Movie.cs 프로젝트: testerez/mymovies
        public Movie(String file, JsonMainDetails.Data infos, String coverFileName) : this()
        {
            TimeAdded = DateTime.Now.ToUnixTimestamp();

            Title = infos.title;
            try
            {
                Year = int.Parse(infos.year);
            }
            catch { }
            if (infos.plot != null)
            {
                Plot = infos.plot.outline;
            }
            ImdbId = infos.tconst;
            Principals.AddRange(infos.cast_summary.NoNull().Select(p => p.name.name));
            Directors.AddRange(infos.directors_summary.NoNull().Select(p => p.name.name));
            Writers.AddRange(infos.writers_summary.NoNull().Select(p => p.name.name));
            Genres.AddRange(infos.genres.NoNull());
            ImdbRating = infos.rating;
            if (infos.runtime != null)
            {
                Duration = infos.runtime.time;
            }

            Files.Add(file);
            Cover = coverFileName;
        }
예제 #21
0
        public async Task <IActionResult> PutDirectors(int id, Directors directors)
        {
            if (id != directors.Id)
            {
                return(BadRequest());
            }

            _context.Entry(directors).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!DirectorsExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
예제 #22
0
        public async Task <IActionResult> Edit(int id, [Bind("Did,Name,Gender")] Directors directors)
        {
            if (id != directors.Did)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(directors);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!DirectorsExists(directors.Did))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(directors));
        }
예제 #23
0
        public static void BonificationCalc()
        {
            BonificationManager bm = new BonificationManager();

            Designers Diego = new Designers("833.222.048-39");

            Diego.Name = "Diego arruda";
            bm.Registry(Diego);

            Directors maria = new Directors("159.753.398-04");

            maria.Name = "Maria Ana Soares";
            bm.Registry(maria);

            AccountManagers michael = new AccountManagers("326.985.628-89");

            michael.Name = "Michael Hoffman";
            bm.Registry(michael);

            Auxiliar mirta = new Auxiliar("325.541.654-99");

            mirta.Name = "Mirta Roberta silva";
            bm.Registry(mirta);



            Console.WriteLine("Total bonifications " + bm.GetBonifications());
        }
예제 #24
0
        public async Task <IActionResult> Edit(int id, [Bind("DirectorsID,MovieID,PeopleID")] Directors directors)
        {
            if (id != directors.DirectorsID)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(directors);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!DirectorsExists(directors.DirectorsID))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["MovieID"]  = new SelectList(_context.movies, "MovieID", "Title", directors.MovieID);
            ViewData["PeopleID"] = new SelectList(_context.people, "PeopleID", "Name", directors.PeopleID);
            return(View(directors));
        }
예제 #25
0
        private void ClearGUI()
        {
            // Recommended for identification
            seriesTitle.Clear();
            seriesIMDB.Clear();
            seriesTVDB.Clear();
            seasonIndex.Clear();
            episodeIndexList.Clear();
            episodeAired.Clear();

            // additional series infos
            seriesFirstAired.Clear();
            seriesSummary.Clear();
            seriesGenre.Clear();
            seriesActors.Clear();
            Certification.Clear();
            Network.Clear();
            seriesKeywords.Clear();
            // additional episode infos
            episodeIMDB.Clear();
            episodeTitle.Clear();
            episodeSummary.Clear();
            GuestStars.Clear();
            Directors.Clear();
            Writers.Clear();
            episodeKeywords.Clear();
        }
예제 #26
0
    private void Awake()
    {
        if (instance == null)
        {
            instance = FindObjectOfType <Directors>();
        }
        else
        {
            if (instance.gameObject == null)
            {
                instance = FindObjectOfType <Directors>();
            }
            else
            {
                Destroy(this.gameObject);
                return;
            }
        }
        DontDestroyOnLoad(this.gameObject);

        battleState = BattleState.Prepare;
        PrefabsManager.ClearPool();
        PrepareManagers();
        InitManagers();
    }
예제 #27
0
        private void RefreshFromMetadata(MovieMetadata metadata)
        {
            Certification   = metadata.Certification;
            FileInformation = metadata.FileInformation;
            Id               = metadata.Id;
            OriginalTitle    = metadata.OriginalTitle;
            Outline          = metadata.Outline;
            PlayCount        = metadata.PlayCount;
            Plot             = metadata.Plot;
            PremieredDate    = metadata.Premiered;
            Rating           = metadata.Rating;
            RuntimeInMinutes = metadata.RuntimeInMinutes;
            Country          = metadata.Country;
            SetName.Value    = metadata.SetName;
            SetName.Save();
            Studio      = metadata.Studio;
            Tagline     = metadata.Tagline;
            Title.Value = metadata.Title;
            Title.Save();
            Year = metadata.Year;
            Poster.RefreshImage(metadata.ImagePosterPath);
            Fanart.RefreshImage(metadata.ImageFanartPath);

            Credits.ReplaceWith(metadata.Credits);
            Directors.ReplaceWith(metadata.Directors);
            Genres.ReplaceWith(metadata.Genres);
            ActorManager.Initialize(TransformActors(metadata.Actors));
        }
예제 #28
0
        public void DeleteDirector(int id)
        {
            Directors obj = ctx.Directors.Where(q => q.Id == id).FirstOrDefault();

            ctx.Directors.Remove(obj);
            ctx.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
            ctx.SaveChanges();
        }
예제 #29
0
        private DirectorDto CreateDirectorElementDto(Directors directors)
        {
            var dto = _mapper.Map <DirectorDto>(directors);

            dto.Url = Url.Link(nameof(GetDirector), new { id = directors.DirectorId.Trim() }); //trim to fix id whitespace in urls

            return(dto);
        }
예제 #30
0
 public static void DeleteMovie(string id)
 {
     Genres.DeleteMovieGenres(id);
     Actors.DeleteMovieActors(id);
     Directors.DeleteMovieDirectors(id);
     Writers.DeleteMovieWriters(id);
     Awards.DeleteMovieAwards(id);
     DBConn.RunNonQuerySQL("delete from Movies where MovieID=" + id);
 }
예제 #31
0
        private void DeleteDirectorInDirectorListById(Guid id)
        {
            var item  = Directors.FirstOrDefault(a => a.Id == id);
            var index = Directors.IndexOf(item);

            if (index != -1)
            {
                Directors.RemoveAt(index);
            }
        }
예제 #32
0
        public void UpdateDirector(Directors obj)
        {
            var newObj = ctx.Directors.Where(q => q.Id == obj.Id).FirstOrDefault();

            newObj.FirstName = obj.FirstName;
            newObj.LastName  = obj.LastName;
            newObj.Education = obj.Education;
            newObj.Phone     = obj.Phone;
            newObj.Email     = obj.Email;
            ctx.SaveChanges();
        }
예제 #33
0
        public async Task <IActionResult> Create([Bind("Did,Name,Gender")] Directors directors)
        {
            if (ModelState.IsValid)
            {
                _context.Add(directors);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(directors));
        }
예제 #34
0
 public ListLogsController(Directors.IListLogsDirector director)
 {
     _director = director;
 }
예제 #35
0
 public OpenLogFileController(Directors.IOpenLogFileDirector director)
 {
     _director = director;
 }
예제 #36
0
 public RecycleClientController(Directors.IRecycleClientDirector director)
 {
     _director = director;
 }
예제 #37
0
            /// <summary>
            /// Description  : Get Directors Details from database.
            /// Created By   : Pavan
            /// Created Date : 31 July 2014
            /// Modified By  :
            /// Modified Date:
            /// </summary>
            /// <returns></returns>
            public static DirectorsInfo GetDirectorsDetails(string SearchType, string SearchKeyWord, string SearchRole, int WOID, string NatureAppoint, int ClassOfShare)
            {
                var data = new DirectorsInfo();

                System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
                System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
                log.Debug("Start: " + methodBase.Name);
                try
                {
                    SqlParameter[] sqlParams = new SqlParameter[6];
                    sqlParams[0] = new SqlParameter("@SearchType", SearchType);
                    sqlParams[1] = new SqlParameter("@WOID", WOID);
                    sqlParams[2] = new SqlParameter("@SearchRole", SearchRole);
                    sqlParams[3] = new SqlParameter("@SearchKeyWord", SearchKeyWord);
                    sqlParams[4] = new SqlParameter("@NatureAppoint", NatureAppoint);
                    sqlParams[5] = new SqlParameter("@ClassOfShare", ClassOfShare);
                    var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetAllDirectorDetails]", sqlParams);
                    var safe = new SafeDataReader(reader);
                    while (reader.Read())
                    {
                        var directors = new Directors();
                        directors.FetchDirectorsDetails(directors, safe);
                        data.DirectorsList.Add(directors);
                    }
                    return data;
                }
                catch (Exception ex)
                {
                    log.Error("Error: " + ex);
                    return data;
                }
                finally
                {
                    log.Debug("End: " + methodBase.Name);
                }
            }
예제 #38
0
 private Directors FetchDirectorsDetails(Directors Directors, SafeDataReader dr)
 {
     Directors.ID = dr.GetInt32("ID");
     Directors.Name = dr.GetString("Name");
     Directors.SourceCode = dr.GetString("SourceCode");
     Directors.RowId = dr.GetInt32("RowId");
     return Directors;
 }