public void CreateBusiness() { IService service = new Service(); Business b = new Business(); b.Id = 1; b.Name = "SKY"; b.Employees = new List <Person>(); Person p = new Person(); p.Id = 1; p.Name = "Sepehr"; b.Employees.Add(p); service.Add(b); Business sky = service.GetById(1); Assert.IsNotNull(sky); }
public ActionResult Create(RoleEntity entity, List <PermissionDescriptor> PermissionSet) { Service.Add(entity); var permissions = new List <Permission>(); PermissionSet.Where(m => m.Checked ?? false).Each(m => { permissions.Add(new Permission { RoleId = entity.ID, PermissionKey = m.Key, Module = m.Module, Title = m.Title, ActionType = ActionType.Create }); }); _permissionService.AddRange(permissions.ToArray()); return(RedirectToAction("Index")); }
public virtual HttpResponseMessage Follow(int entityTypeId, int entityId, [FromUri(BinderType = typeof(TypeConverterModelBinder))] string purposeKey = null) { /* * 4/23/2021 - Daniel * The weird BinderType thing allows the user to do ?purposeKey= * to pass a blank purpose key, otherwise it throws a required value * error even though it's not required. */ var person = GetPerson(); if (person == null) { throw new HttpResponseException(HttpStatusCode.Unauthorized); } SetProxyCreation(true); var following = new Following { EntityTypeId = entityTypeId, EntityId = entityId, PersonAliasId = GetPerson().PrimaryAliasId.Value, PurposeKey = purposeKey }; Service.Add(following); if (!following.IsValid) { return(ControllerContext.Request.CreateErrorResponse( HttpStatusCode.BadRequest, string.Join(",", following.ValidationResults.Select(r => r.ErrorMessage).ToArray()))); } System.Web.HttpContext.Current.AddOrReplaceItem("CurrentPerson", GetPerson()); Service.Context.SaveChanges(); var response = ControllerContext.Request.CreateResponse(HttpStatusCode.Created, following.Id); return(response); }
public JsonResult Save(string id, string title, string parentId) { MediaEntity entity = null; if (id.IsNotNullAndWhiteSpace() && title.IsNotNullAndWhiteSpace()) { var media = Service.Get(id); media.Title = title; Service.Update(media); entity = Service.Get(id); } else if (title.IsNotNullAndWhiteSpace()) { entity = new MediaEntity { Title = title, MediaType = (int)MediaType.Folder, ParentID = parentId }; Service.Add(entity); } return(Json(entity)); }
public ActionResult Index() { var TotalResult = client.Add(5, 8); ViewBag.Result1 = TotalResult; var TotalSubstract = client.Substract(5, 8); ViewBag.Result2 = TotalSubstract; var TotalMultiple = _clientInternal.Multiple(12, 12); ViewBag.Result3 = TotalMultiple; var TotalDivision = _clientInternal.Division(12, 0); ViewBag.Result4 = TotalDivision; return(View()); }
public ArticleVM Add(ArticleVM article) { Article service_result = service.Add(new Article { Author_ID = article.Author_ID, Category_ID = article.Category_ID, Created_Date = DateTime.Now, Is_Deleted = false, Post_Content = article.Post_Content, Tags = article.Tags, Title = article.Title, ViewCount = 0 }); service.Save(); ArticleVM api_result = Mapper.Map <Article, ArticleVM>(service_result); return(api_result); }
public IActionResult Put(LocaleResourceForm model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { foreach (var item in model.ResourceValues) { var source = new LocaleResource() { LanguageId = item.LanguageId, ResourceName = model.ResourceName, ResourceValue = string.IsNullOrWhiteSpace(item.Value) ? "" : item.Value, CreatedAt = DateTime.Now, CreatedBy = CurrentUser?.Id }; if (item.LocaleResourceId.HasValue) { var resource = Service.GetById(item.LocaleResourceId); resource.Update(source); resource.LastEditedBy = CurrentUser?.Id; resource.LastUpdateTime = DateTime.Now; Service.Update(resource); } else { Service.Add(source); } } return(Ok()); } catch (Exception e) { return(BadRequest(e.Message)); } }
public async Task <ActionResult <Category> > Post ( [FromBody] Category model ) { try { service.Add(model); if (await service.SaveChangesAsync()) { return(Created($"/api/category/{model.Id}", model)); } return(BadRequest()); } catch (Exception err) { return(StatusCode(StatusCodes.Status500InternalServerError, "Banco de dados falhou " + err.Message + " " + err.InnerException)); } }
public IHttpActionResult AddNewEvent() { try { var newEvent = new Event { Name = "Movie Logan", Description = "Logan Description", EventType = Enums.EventType.Cinema, StartDate = DateTime.UtcNow, ImageId = null }; Service.Add(newEvent); return(Ok()); } catch (Exception e) { return(BadRequest(e.Message)); } }
static void Main(string[] args) { Properties p = new Properties() { Name = "jarrik van camp", Email = "*****@*****.**" }; Service service = new Service(); service.Add(p); List<Properties> props = new List<Properties>(); props = service.GetAll(); foreach (var prop in props) { Console.WriteLine(prop.ToString()); } Console.Read(); }
public ActionResult Add(CompanyDto companydto) { ResultJsonInfo resultJsonInfo = new ResultJsonInfo() { Data = "", ErrorMsg = "", Success = true }; if (companydto != null) { companydto.CreateUser = ServiceHelper.GetCurrentUser().UserName; companydto.CredateTime = DateTime.Now; if (!Service.Add(companydto)) { resultJsonInfo.Success = false; resultJsonInfo.ErrorMsg = "添加失敗"; return(Content("<script>alert('添加失敗');history.go(-1);</script>")); } } //return Content("<script>alert('添加成功');</script>"); return(this.Ajax_JGClose()); }
public async Task <IActionResult> Upload(string parentId, string folder, long size) { if (Request.Form.Files.Count > 0) { if (folder.IsNotNullAndWhiteSpace()) { var parent = Service.Get(m => m.Title == folder && m.MediaType == (int)MediaType.Folder).FirstOrDefault(); if (parent == null) { parent = new MediaEntity { Title = folder, MediaType = (int)MediaType.Folder, ParentID = "#" }; Service.Add(parent); } parentId = parent.ID; } parentId = parentId ?? "#"; string fileName = Path.GetFileName(Request.Form.Files[0].FileName); var entity = new MediaEntity { ParentID = parentId, Title = fileName, Status = Request.Form.Files[0].Length == size ? (int)RecordStatus.Active : (int)RecordStatus.InActive }; string extension = Path.GetExtension(fileName).ToLower(); string fileId = new Easy.IDGenerator().CreateStringId(); entity.Url = await _storage.SaveFileAsync(Request.Form.Files[0].OpenReadStream(), $"{fileId}{extension}"); if (entity.Url.IsNotNullAndWhiteSpace()) { Service.Add(entity); entity.Url = Url.Content(entity.Url); } return(Json(entity)); } return(Json(false)); }
public ActionResult Create(AddEditBookModel model) { if (ModelState.IsValid) { var book = Mapper.Map <BookFullModel, Book>(model.Book); book.ImageFile = _fileService.SaveImage(model.Book.Image, null, model.IsImageChanged); Service.Add(book); return(RedirectToAction("Index", new { id = model.Book.GenreId })); } else { FillDicts(); return(View("CreateEdit", model)); } }
public void Run() { int var1 = 5; int var2 = 7; // instantiate the web service proxy Service theWebSvc = new Service(); // call the add method Console.WriteLine("{0} + {1} = {2}", var1, var2, theWebSvc.Add(var1, var2)); // build a table by repeatedly calling the pow method for (int i = 2; i < 10; i++) { for (int j = 1; j < 10; j++) { Console.WriteLine("{0} to the power of {1} = {2}", i, j, theWebSvc.Pow(i, j)); } } }
public async Task Test8() { MockServer server = new MockServer("test8"); var service = new Service(); service.Add( (ServiceContext context) => context.RemoteEndPoint.ToString(), "getAddress" ); service.Bind(server); var client = new Client("mock://test8"); var log = new Log(); client.Use(log.IOHandler).Use(log.InvokeHandler); Console.WriteLine(await client.InvokeAsync <string>("getAddress")); Console.WriteLine(await client.InvokeAsync <string>("getAddress")); await client.Abort(); Console.WriteLine(await client.InvokeAsync <string>("getAddress")); Console.WriteLine(await client.InvokeAsync <string>("getAddress")); server.Close(); }
public async Task Test8() { UdpClient server = new UdpClient(8422); var service = new Service(); service.Add( (ServiceContext context) => context.RemoteEndPoint.ToString(), "getAddress" ); service.Bind(server); var client = new Client("udp4://127.0.0.1:8422"); var log = new Log(); client.Use(log.IOHandler).Use(log.InvokeHandler); Console.WriteLine(await client.InvokeAsync <string>("getAddress").ConfigureAwait(false)); Console.WriteLine(await client.InvokeAsync <string>("getAddress").ConfigureAwait(false)); await client.Abort().ConfigureAwait(false); Console.WriteLine(await client.InvokeAsync <string>("getAddress").ConfigureAwait(false)); Console.WriteLine(await client.InvokeAsync <string>("getAddress").ConfigureAwait(false)); server.Close(); }
public void GetEstimations_ShouldReturnShapesDescriptionAndEstimationsAsStringCollection() { AbstractShape shape = new Circle() { Name = "CircleName", Surface = 12 }; string expectedEstimation = string.Format("{0} - {1} - {2}{3} - Estimation cout : {4}€", shape.GetShapeType(), shape.Name, shape.Surface, shape.GetSurfaceUnit(), 2 * shape.Surface); var pricerMock = new Mock <IPricer>(); pricerMock .Setup(x => x.Price(It.IsAny <int>())) .Returns <int>((b) => b * 2); Service service = new Service(); service.Add(shape); IEnumerable <string> actualeShapesEstimations = service.GetEstimations(pricerMock.Object); Assert.IsNotNull(actualeShapesEstimations.SingleOrDefault(x => x == expectedEstimation)); }
private static void Add() { //get the existing list of players _playerList = _playerService.GetAll(); //instantiate the new player object Player player = new Player(); //for each property get info from the user player = ConsoleInput.GetUserInput <Player>(); //get the current date and time for DateAdded player.DateAdded = DateTime.Now; //call the player service and add the player player = _playerService.Add(player); //give the user feed back--pause for one second on screen string message = $"Success: Added a new player ID: {player.Player_Id}"; ConsoleMessage.ShowMessage(message); }
protected override void OnStart() { base.OnStart(); InitService(); var button1 = FindViewById <Button> (Resource.Id.buttonCalc); button1.Click += (sender, e) => { if (IsBound) { var text1 = FindViewById <EditText> (Resource.Id.value1); var text2 = FindViewById <EditText> (Resource.Id.value2); var result = FindViewById <TextView> (Resource.Id.result); int v1; int v2; int v3; if (Int32.TryParse(text2.Text, out v2) && Int32.TryParse(text1.Text, out v1)) { v3 = Service.Add(v1, v2); } else { v3 = 0; var builder = new AlertDialog.Builder(this); builder.SetMessage("Spaces or special character are not allowed"); builder.SetNeutralButton("OK", (source, eventArgs) => {}); builder.Show(); } result.Text = v3.ToString(); } else { Log.Warn(Tag, "The AdditionService is not bound"); } }; }
public virtual HttpResponseMessage Follow(int entityTypeId, int entityId) { var person = GetPerson(); if (person == null) { throw new HttpResponseException(HttpStatusCode.Unauthorized); } SetProxyCreation(true); var following = new Following { EntityTypeId = entityTypeId, EntityId = entityId, PersonAliasId = GetPerson().PrimaryAliasId.Value }; Service.Add(following); if (!following.IsValid) { return(ControllerContext.Request.CreateErrorResponse( HttpStatusCode.BadRequest, string.Join(",", following.ValidationResults.Select(r => r.ErrorMessage).ToArray()))); } if (!System.Web.HttpContext.Current.Items.Contains("CurrentPerson")) { System.Web.HttpContext.Current.Items.Add("CurrentPerson", GetPerson()); } Service.Context.SaveChanges(); var response = ControllerContext.Request.CreateResponse(HttpStatusCode.Created, following.Id); return(response); }
public IActionResult AddMovie(MovieDetailModel movieDetailModel, IFormFile file) { log.Info("Adding a movie started...."); try { movieDetailModel.Poster = Path.GetExtension(file.FileName); Service.Add(movieDetailModel); } catch (Exception ex) { log.Error(ex); } if (file != null) { string ImageName = movieDetailModel.Id + Path.GetExtension(file.FileName); string SavePath = Path.Combine(_configuration["ImagesFolder"], ImageName); using (var stream = new FileStream(SavePath, FileMode.Create)) { file.CopyTo(stream); } } return(RedirectToAction("Index")); }
public JsonResult Save(string id, string title, string parentId) { MediaEntity entity = null; if (id.IsNotNullAndWhiteSpace() && title.IsNotNullAndWhiteSpace()) { DataFilter filter = new DataFilter(new List <string> { "Title" }); Service.Update(new MediaEntity { Title = title }, filter.Where("ID", OperatorType.Equal, id)); entity = Service.Get(id); } else if (title.IsNotNullAndWhiteSpace()) { entity = new MediaEntity { Title = title, MediaType = (int)MediaType.Folder, ParentID = parentId }; Service.Add(entity); } return(Json(entity)); }
public ActionResult Add(UserDto userDto) { ResultJsonInfo resultJsonInfo = new ResultJsonInfo() { Data = "", ErrorMsg = "", Success = true }; if (ModelState.IsValid) { } if (userDto != null) { userDto.CreateUser = ServiceHelper.GetCurrentUser().LoginName; userDto.CredateTime = DateTime.Now.Date; if (!Service.Add(userDto)) { resultJsonInfo.Success = false; resultJsonInfo.ErrorMsg = "添加失败!"; } } return(this.Ajax_JGClose()); // return Json(new { resultJsonInfo }, JsonRequestBehavior.AllowGet); }
public ActionResult Add(Model.Dto.MenuTree menuDto) { ResultJsonInfo resultJsonInfo = new ResultJsonInfo() { Data = "", ErrorMsg = "", Success = true }; if (ModelState.IsValid) { menuDto.CreateUser = ServiceHelper.GetCurrentUser().LoginName; menuDto.CredateTime = DateTime.Now.Date; if (Service.Add(menuDto)) { return(this.Ajax_JGClose()); } else { resultJsonInfo.Success = false; resultJsonInfo.ErrorMsg = "添加失败!"; } } return(View()); }
protected override void Save() { if (!Validate()) { return; } IsObjectLoading = true; if (Object.ID == 0) { IObservable <T> addObs = Observable.FromAsync(() => Service.Add(Mapper.Map <TDetailViewModel, T>(Object))); addObs.Select((o) => Mapper.Map <TDetailViewModel>(o)).Subscribe((res) => { Object = res; OnAdd(); EditMode = EditMode.ReadOnly; IsObjectLoading = false; }, (e) => { ShowMessageBox("Error occured while adding data.", "Error", System.Windows.MessageBoxButton.OK); IsObjectLoading = false; }); } else { IObservable <T> updateObs = Observable.FromAsync(() => Service.Update(Mapper.Map <TDetailViewModel, T>(Object))); updateObs.Subscribe((res) => { editableObject.EndEdit(); editableObject = null; Object = Mapper.Map <TDetailViewModel>(res); OnSave(); EditMode = EditMode.ReadOnly; IsObjectLoading = false; }, (e) => { ShowMessageBox("Error occured while saving data.", "Error", System.Windows.MessageBoxButton.OK); IsObjectLoading = false; }); } }
/// <summary> /// В случае отсутствия Псалма с таким номером в БД добавляет его /// </summary> /// <param name="currentPsalm"></param> private void InsertOrUpdatePsalm(Psalm currentPsalm) { var response = Service.Get(new GetPsalmRequest() { Number = currentPsalm.Number }); currentPsalm.Definition = GetDefinition(currentPsalm); if (response.Psalm == null) { Service.Add(new AddPsalmRequest() { Psalm = currentPsalm }); } else { Service.Update(new UpdatePsalmRequest() { Psalm = currentPsalm }); } }
public async Task <IActionResult> Post([FromBody] ITechnologyViewModel technology) { try { var data = await Service.Add(technology); return(Ok(new OneDATApiResponse("Inserted Successfully", data))); } catch (OneDATException ex) { if (ex.Code == OneDATExceptionCode.AlreadyExists) { return(Conflict(new OneDATApiResponse("Data AlreadyExists", false))); } else { return(BadRequest(new OneDATApiResponse(ex.Message, false))); } } catch (Exception ex) { return(ServerError("Error Adding Records in technology", false, ex)); } }
public ActionResult Add(ButtonDto buttonDto) { ResultJsonInfo resultJsonInfo = new ResultJsonInfo() { Data = "", ErrorMsg = "", Success = true }; if (ModelState.IsValid) { buttonDto.CreateUser = ServiceHelper.GetCurrentUser().LoginName; buttonDto.CredateTime = DateTime.Now.Date; if (!Service.Add(buttonDto)) { resultJsonInfo.Success = false; resultJsonInfo.ErrorMsg = "添加失败!"; } return(this.Ajax_JGCloseAndMessage("保存成功")); } else { return(View()); } // return Json(new { resultJsonInfo }, JsonRequestBehavior.AllowGet); }
public ActionResult Create(commentaire c, int id, int idemp) { IUnitOfWork Uok = new UnitOfWork(Factory); IService <commentaire> jbService = new Service <commentaire>(Uok); List <commentaire> appo = new List <commentaire>(); appo = jbService.GetAll().ToList(); for (int i = appo.Count - 1; i >= 0; i--) { if (appo[i].commentaireEvzl360_id == id && appo[i].employecommentaire_id == idemp) { return(View("Exist")); } } c.commentaireEvzl360_id = id; c.employecommentaire_id = idemp; jbService.Add(c); jbService.Commit(); String y = (string)System.Web.HttpContext.Current.Session["id"].ToString(); int x = int.Parse(y); ViewBag.idemploye = x; return(RedirectToAction("IndexByEmp", new { idemploye = x })); }
public override IActionResult Edit(string id, RecoveryForm model) { if (ModelState.IsValid) { var User = _userHelper.GetUser(id); if (User != null) { // Insert Vacancy var NewVacancy = new VacancyList(); NewVacancy.AccountNameId = model.AccountNameId; NewVacancy.ApproverOneId = model.ApproverOneId; NewVacancy.ApproverTwoId = model.SourcingId; NewVacancy.CostCodeId = model.CostCodeId; NewVacancy.CreatedAt = DateTime.Now; NewVacancy.DepartmentId = model.DepartmentId; NewVacancy.DepartmentSubId = model.DepartmentSubId; NewVacancy.JobStageId = model.JobStageId; NewVacancy.JoinDate = model.JoinDate; NewVacancy.NetworkId = model.NetworkId; NewVacancy.NoarmalRate = model.NoarmalRate; NewVacancy.OtLevel = model.OtLevel; NewVacancy.RequestBy = _userHelper.GetUserProfile(model.ApproverOneId); NewVacancy.PackageTypeId = model.PackageTypeId; NewVacancy.ServicePackCategoryId = model.ServicePackCategoryId; NewVacancy.ServicePackId = model.ServicePackId; //NewVacancy.Status = VacanStatusFive.Done; NewVacancy.VacancyStatus = ApproverStatus.Completed; NewVacancy.isHrms = model.isHrms; NewVacancy.isLaptop = model.isLaptop == 1 ? true : false; NewVacancy.isManager = model.isManager; NewVacancy.isUsim = model.isUsim; NewVacancy.StatusOne = SrfApproveStatus.Approved; NewVacancy.StatusTwo = SrfApproveStatus.Approved; NewVacancy.StatusThree = SrfApproveStatus.Approved; NewVacancy.StatusFourth = SrfApproveStatus.Approved; _vacancy.Add(NewVacancy); if (NewVacancy.Id != null) { // Insert Candidate var UserProfile = _profileService.GetByUserId(id); var GetCandidate = _candidate.GetAll().Where(x => x.AccountId == UserProfile.Id).FirstOrDefault(); if (GetCandidate == null) { var Candidate = new CandidateInfo(); Candidate.Account = UserProfile; Candidate.Address = UserProfile.Address; Candidate.AgencyId = model.AgencyId; Candidate.AgencyType = AgencyType.Agency; Candidate.ApproveOneDate = DateTime.Now; Candidate.ApproveOneStatus = ApproverStatus.Selected; Candidate.ApproveTwoeDate = DateTime.Now; Candidate.CreatedAt = DateTime.Now; Candidate.Email = User.Email; Candidate.Gender = UserProfile.Gender.Value; Candidate.HomePhoneNumber = UserProfile.HomePhoneNumber; Candidate.IdNumber = UserProfile.IdNumber; Candidate.IsCandidate = false; Candidate.IsContractor = true; Candidate.IsUser = true; Candidate.Martial = Martial.M1; Candidate.MobilePhoneNumber = UserProfile.MobilePhoneNumber; Candidate.Name = UserProfile.Name; Candidate.Nationality = "Indonesia"; Candidate.NickName = UserProfile.Name; Candidate.PlaceOfBirth = UserProfile.Birthplace; Candidate.DateOfBirth = UserProfile.Birthdate.Value; Candidate.RequestBy = _userHelper.GetUserProfile(model.AgencyId); Candidate.ApproveTwoStatus = ApproverStatus.Completed; Candidate.Vacancy = NewVacancy; GetCandidate = _candidate.Add(Candidate); } if (GetCandidate != null) { var Department = _department.GetById(model.DepartmentId); var Network = _network.GetById(model.NetworkId); // Insert SRF SrfRequest NewSrf = new SrfRequest(); NewSrf.CreatedAt = DateTime.Now; NewSrf.Number = "0000"; NewSrf.Type = SrfType.New; NewSrf.ApproveStatusOne = SrfApproveStatus.Approved; NewSrf.ApproveStatusTwo = SrfApproveStatus.Approved; NewSrf.ApproveStatusThree = SrfApproveStatus.Approved; NewSrf.ApproveStatusFour = SrfApproveStatus.Approved; NewSrf.ApproveStatusFive = SrfApproveStatus.Approved; NewSrf.ApproveStatusSix = SrfApproveStatus.Approved; NewSrf.RequestBy = _userHelper.GetUserProfile(model.ApproverOneId).Name; NewSrf.SrfBegin = model.SrfBegin; NewSrf.SrfEnd = model.SrfEnd; NewSrf.ServiceLevel = model.OtLevel; NewSrf.isWorkstation = model.isLaptop == 1 ? true : false; NewSrf.isCommunication = model.isUsim; NewSrf.IsHrms = model.isHrms; NewSrf.IsOps = Department.OperateOrNon == 1 ? true : false; NewSrf.IsManager = false; NewSrf.RateType = Domain.Models.Enum.RateType.Normal; NewSrf.IsExtended = false; NewSrf.IsLocked = false; NewSrf.Status = Domain.Models.Enum.SrfStatus.Done; NewSrf.SpectValue = 0; NewSrf.IsActive = false; NewSrf.ServicePackId = model.ServicePackId; NewSrf.NetworkId = model.NetworkId; NewSrf.CostCenterId = model.CostCodeId; NewSrf.LineManagerId = model.ApproverOneId; NewSrf.ActivityCode = _activity.GetAll().OrderBy(x => Guid.NewGuid()).FirstOrDefault(); NewSrf.DepartmentId = model.DepartmentId; NewSrf.DepartmentSubId = model.DepartmentSubId; NewSrf.ProjectManagerId = Network.ProjectManagerId; NewSrf.ApproveOneId = model.ApproverOneId; NewSrf.ApproveTwoId = model.ApproveTwoId; NewSrf.ApproveThreeId = model.ApproveThreeId; NewSrf.ApproveFourId = model.ApproveFourId; NewSrf.ApproveSixId = model.ApproveSixId; NewSrf.Candidate = GetCandidate; NewSrf.AccountId = model.AccountNameId; NewSrf.IsLocked = false; NewSrf.IsActive = true; var AnnualLeave = MonthDistance(model.SrfBegin, model.SrfEnd); NewSrf.AnnualLeave = AnnualLeave; Service.Add(NewSrf); if (NewSrf.Id != null) { TempData["Success"] = true; } } } } } return(RedirectToAction("Index")); }
public async Task <IActionResult> Import(IFormFile file) { int TOTAL_INSERT = 0; int TOTAL_UPDATE = 0; var uploads = System.IO.Path.Combine(_environment.WebRootPath, "temp"); file = Request.Form.Files[0]; using (var fileStream = new FileStream(System.IO.Path.Combine(uploads, file.FileName), FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite)) { await file.CopyToAsync(fileStream); try { using (var Stream = new FileStream(System.IO.Path.Combine(uploads, file.FileName), FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite)) { using (ExcelPackage package = new ExcelPackage(Stream)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; int rowCount = worksheet.Dimension.Rows; int ColCount = worksheet.Dimension.Columns; for (int row = 2; row <= rowCount; row++) { if (worksheet.Cells[row, 1].Value != null && worksheet.Cells[row, 2].Value != null && worksheet.Cells[row, 3].Value != null && worksheet.Cells[row, 4].Value != null && worksheet.Cells[row, 5].Value != null && worksheet.Cells[row, 6].Value != null) { var NetworkNumber = worksheet.Cells[row, 1].Value.ToString(); var Project = worksheet.Cells[row, 2].Value.ToString(); var Department = worksheet.Cells[row, 3].Value.ToString(); var LineManager = worksheet.Cells[row, 4].Value.ToString(); var ProjectManager = worksheet.Cells[row, 5].Value.ToString(); var AccountName = worksheet.Cells[row, 6].Value.ToString(); var Description = (worksheet.Cells[row, 7].Value != null) ? worksheet.Cells[row, 7].Value.ToString() : ""; NetworkNumber NetWorkFind = Service .GetAll() .FirstOrDefault(x => _excel.TruncateString(x.Code) == _excel.TruncateString(NetworkNumber)); Projects ProjectFind = projects .GetAll() .FirstOrDefault(x => _excel.TruncateString(x.Name) == _excel.TruncateString(Project)); Departement DepartmentFind = departement .GetAll() .FirstOrDefault(x => _excel.TruncateString(x.Name) == _excel.TruncateString(Department)); UserProfile LineManagerUser = await FindUserByRole(LineManager, "Project Manager"); UserProfile ProjectManagerUser = await FindUserByRole(ProjectManager, "Project Manager"); AccountName AccountFind = accountName .GetAll() .FirstOrDefault(x => _excel.TruncateString(x.Name) == _excel.TruncateString(AccountName.ToString())); if (ProjectFind == null) { Projects pj = new Projects { Name = Project }; ProjectFind = projects.Add(pj); } if (LineManagerUser != null && ProjectManagerUser != null && DepartmentFind != null && AccountName != null) { if (NetWorkFind == null) { NetworkNumber nt = new NetworkNumber { Code = NetworkNumber, Project = ProjectFind, Departement = DepartmentFind, LineManager = LineManagerUser, ProjectManager = ProjectManagerUser, AccountName = AccountFind, Description = Description }; Service.Add(nt); TOTAL_INSERT++; } else { NetworkNumber nt = Service.GetById(NetWorkFind.Id); nt.Project = ProjectFind; nt.Departement = DepartmentFind; nt.LineManager = LineManagerUser; nt.ProjectManager = ProjectManagerUser; nt.AccountName = AccountFind; nt.Description = Description; Service.Update(nt); TOTAL_UPDATE++; } } } } } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } } TempData["Messages"] = "Total Inserted = " + TOTAL_INSERT + " , Total Updated = " + TOTAL_UPDATE; System.IO.File.Delete(System.IO.Path.Combine(uploads, file.FileName)); return(RedirectToAction("Index")); }