public bool AddVendor(int productOwnerId, VendorsViewModel vendor) { bool success = false; int count = this._context .Vendor .Where(r => r.ProductOwnerId == productOwnerId && r.CompanyName.ToLower() == vendor.CompanyName.ToLower()) .Count(); if (count == 0) { success = true; Vendor theVendor = new Vendor { CompanyName = vendor.CompanyName, TaxId = vendor.TaxId, AddressLine1 = vendor.AddressLine1, City = vendor.City, State = vendor.State, Zip = vendor.Zip, ProductOwnerId = productOwnerId, CurrentUser = vendor.CurrentUser }; this._context.Vendor.Add(theVendor); this._context.SaveChanges(); } return(success); }
public ActionResult AddVendor(VendorsViewModel Vendor) { if (Vendor != null && ModelState.IsValid) { var loggedUser = this._userManager.Users.Where(r => r.UserName == User.Identity.Name).FirstOrDefault(); Vendor.CurrentUser = loggedUser.UserName; bool success = this._databaseService.AddVendor(loggedUser.ProductOwnerId, Vendor); if (!success) { ModelState.AddModelError("CompanyName", "Vendor Name already exists."); return(this.GetVendorViewResult(Vendor)); } else { IList <VendorsViewModel> model = this._databaseService.GetVendors(loggedUser.ProductOwnerId); return(this.Json( new { Success = true, Message = "Saved Successfully", Html = this.RenderPartialViewToString("_VendorList", model), Count = model.Count })); } } else { return(this.GetVendorViewResult(Vendor)); } }
public JsonResult AddVendor(VendorsViewModel vendor) { try { var vendorList = db.Vendors.ToList(); if (ModelState.IsValid) { if (vendor.VenderName == null) { return(Json(vendorList)); } var vendorModel = new Vendors(); vendorModel.VenderName = vendor.VenderName; vendorModel.Status = true; vendorModel.UserName = WebSecurity.CurrentUserName; vendorModel.ModifiedDate = DateTime.Now; UpdateModel(vendorModel); db.Vendors.Add(vendorModel); db.Entry(vendorModel).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); vendorList.Add(vendorModel); } return(Json(vendorList)); } catch (Exception ex) { logger.Log(LogLevel.Error, "Exception occurred in Settings -> AddVendor[HTTPGET]: " + ex.Message); throw; } }
public ActionResult VendorInfo(int vendorId) { VendorsViewModel model = new VendorsViewModel(); model = this._databaseService.GetVendorDetails(Convert.ToInt32(vendorId)); model.VendorTaskList = this._databaseService.GetVendorChecklist(Convert.ToInt32(vendorId)); return(View(model)); }
public ActionResult Index() { var model = new VendorsViewModel { FilterText = "" }; return(View(model)); }
public IActionResult Index(int?CategoryId, int?CountryId, int[] TypeId, int page = 1) { VendorsViewModel model = new VendorsViewModel(); var items = GetVendorItems(CategoryId, CountryId, TypeId, page); model.VendorCategories = GetCategories(); model.VendorTypes = GetTypes(CategoryId); model.VendorItems = items; return(View(model)); }
private JsonResult GetVendorViewResult(VendorsViewModel vendor) { return(this.Json( new { Success = false, Message = "Validation failed", Html = this.RenderPartialViewToString("_AddVendor", vendor) })); }
public VendorsViewModel PrepareVendorsVM() { var vendors = _vendorService.GetAll(); var model = new VendorsViewModel() { Vendors = vendors }; model.Vendors = model.Vendors.OrderByDescending(x => x.Id).ToList(); return(model); }
public IActionResult Index() { var vendors = _vendorRepo.GetAll(); var model = new VendorsViewModel() { Vendors = vendors }; return(View(model)); }
public IActionResult PrepareAddVendor() { VendorsViewModel viewModel = new VendorsViewModel(); return(this.Json( new { Success = true, Message = string.Empty, Html = this.RenderPartialViewToString("_AddVendor", viewModel) })); }
public ActionResult UpdateVendor(VendorsViewModel model) { this._databaseService.UpdateVendorDetails(model); VendorsViewModel updatedModel = this._databaseService.GetVendorDetails(model.VendorId); return(this.Json( new { Success = true, Message = "Saved Successfully", Html = this.RenderPartialViewToString("_VendorSummary", updatedModel) })); }
//public ObservableCollection<string> Items { get; set; } public VendorsPage() { BindingContext = new VendorsViewModel(Navigation); InitializeComponent(); //Items = new ObservableCollection<string> //{ // "Item 1", // "Item 2", // "Item 3", // "Item 4", // "Item 5" //}; //MyListView.ItemsSource = Items; }
public JsonResult EditVendor(int id) { try { var vendor = db.Vendors.Find(id); VendorsViewModel vendorViewModel = new VendorsViewModel(); vendorViewModel.Id = vendor.Id; vendorViewModel.VenderName = vendor.VenderName; return(Json(vendorViewModel, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { logger.Log(LogLevel.Error, "Exception occurred in Settings -> EditVendor[HTTPGET]: " + ex.Message); throw; } }
public IActionResult VendorDetails(string VendorId) { VendorsViewModel model = new VendorsViewModel(); if (!string.IsNullOrEmpty(VendorId)) { model = this._databaseService.GetVendorDetails(Convert.ToInt32(VendorId)); } return(this.Json( new { Success = true, Message = string.Empty, Html = this.RenderPartialViewToString("_VendorDetails", model) })); }
public IActionResult Index(int[] TypeId, int page = 1) { VendorsViewModel model = new VendorsViewModel(); model.VendorItems = GetVenues(TypeId, page); model.VendorCategories = GetCategories(); var VenueCategory = model.VendorCategories.Where(x => x.Title.ToLower().Contains("venu")).FirstOrDefault(); if (VenueCategory != null) { model.VendorTypes = GetTypes(VenueCategory.Id); } else { model.VendorTypes = new List <VendorType>(); } return(View(model)); }
public async Task <IActionResult> Create(VendorsViewModel model) { if (ModelState.IsValid) { var nameAlreadyExists = await _accountCtx.Vendors.AnyAsync(q => q.AccountId == CommonAccount.Id && q.Name == model.Name); if (nameAlreadyExists) { // Name must be unique. No Duplicates. ModelState.AddModelError(nameof(model.Name), "Name already exists."); return(View(model)); } var vendor = new Vendor(); vendor.AccountId = CommonAccount.Id; vendor.Email = model.Email; vendor.Name = model.Name; vendor.MobilePhone = model.MobilePhone; vendor.OfficePhone = model.OfficePhone; vendor.Address1 = model.Address1; vendor.Address2 = model.Address2; vendor.City = model.City; vendor.State = model.State; vendor.Zip = model.Zip; vendor.Disabled = model.Disabled; vendor.Actions = model.Actions; vendor.CreateUserId = LoggedInUser.Id; vendor.UpdateUserId = LoggedInUser.Id; //put dude in the database using (var tx = _accountCtx.Database.BeginTransaction()) { _accountCtx.Vendors.Add(vendor); await _accountCtx.SaveChangesAsync(); tx.Commit(); } return(RedirectToAction("Index")); } return(View(model)); }
public void UpdateVendorDetails(VendorsViewModel model) { Vendor vendor = this._context .Vendor .Where(r => r.VendorId == model.VendorId) .FirstOrDefault(); if (vendor != null) { vendor.CompanyName = model.CompanyName; vendor.AddressLine1 = model.AddressLine1; vendor.City = model.City; vendor.State = model.State; vendor.Zip = model.Zip; } VendorContact contact = this._context .Vendor_Contact .Where(r => r.VendorContactId == model.ContactId) .FirstOrDefault(); if (contact != null) { contact.Name = model.ContactName; contact.JobTitle = model.ContactTitle; contact.Email = model.ContactEmail; } VendorContact signatory = this._context .Vendor_Contact .Where(r => r.VendorContactId == model.SignatoryId) .FirstOrDefault(); if (contact != null) { signatory.Name = model.SignatoryName; signatory.JobTitle = model.SignatoryTitle; signatory.Email = model.SignatoryEmail; } this._context.SaveChanges(); }
public async Task <IActionResult> Edit(VendorsViewModel model) { if (ModelState.IsValid) { var nameAlreadyExists = await _accountCtx.Vendors.AsNoTracking().AnyAsync(q => q.AccountId == CommonAccount.Id && q.Name == model.Name && q.Id != model.Id); if (nameAlreadyExists) { // Name must be unique. No Duplicates. ModelState.AddModelError(nameof(model.Name), "Name already exists."); return(View(model)); } var vendorDetail = _accountCtx.Vendors.Where(q => q.AccountId == CommonAccount.Id && q.Id == model.Id).SingleOrDefault(); if (vendorDetail != null) { vendorDetail.Name = model.Name; vendorDetail.Email = model.Email; vendorDetail.MobilePhone = model.MobilePhone; vendorDetail.OfficePhone = model.OfficePhone; vendorDetail.Address1 = model.Address1; vendorDetail.Address2 = model.Address2; vendorDetail.City = model.City; vendorDetail.State = model.State; vendorDetail.Zip = model.Zip; vendorDetail.Disabled = model.Disabled; vendorDetail.Actions = model.Actions; //put dude in the database using (var tx = _accountCtx.Database.BeginTransaction()) { _accountCtx.Vendors.Update(vendorDetail); await _accountCtx.SaveChangesAsync(); tx.Commit(); } return(RedirectToAction("Index")); } } return(View(model)); }
public JsonResult DeleteVendor(VendorsViewModel vendor) { try { var vendorDetails = new VendorsViewModel(); var vendorList = db.Vendors.ToList(); var vendorToUpdate = new Vendors(); if (vendor == null || !ModelState.IsValid) { return(Json(vendor)); } vendorToUpdate = db.Vendors.Find(vendor.Id); if (vendorToUpdate == null) { return(Json(vendorList)); } vendorToUpdate.Status = false; vendorToUpdate.UserName = WebSecurity.CurrentUserName; vendorToUpdate.ModifiedDate = DateTime.Now; if (TryUpdateModel(vendorToUpdate, new string[] { "Status" })) { db.Entry(vendorToUpdate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); vendorList = db.Vendors.ToList(); } return(Json(vendorDetails)); } catch (Exception ex) { logger.Log(LogLevel.Error, "Exception occurred in Settings -> DeleteVendor[HTTPGET]: " + ex.Message); throw; } }
public async Task <IActionResult> Edit(Guid Id) { VendorsViewModel model = new VendorsViewModel(); var vendorDetail = await _accountCtx.Vendors.Where(q => q.AccountId == CommonAccount.Id && q.Id == Id).SingleOrDefaultAsync(); if (vendorDetail != null) { model.Id = vendorDetail.Id; model.Name = vendorDetail.Name; model.Email = vendorDetail.Email; model.MobilePhone = vendorDetail.MobilePhone; model.OfficePhone = vendorDetail.OfficePhone; model.Address1 = vendorDetail.Address1; model.Address2 = vendorDetail.Address2; model.City = vendorDetail.City; model.State = vendorDetail.State; model.Zip = vendorDetail.Zip; model.Disabled = vendorDetail.Disabled; model.Actions = vendorDetail.Actions; return(View(model)); } return(View(model)); }
public VendorsViewModel GetVendorDetails(int vendorId) { VendorsViewModel vendor = this._context .Vendor .Where(r => r.VendorId == vendorId) .Select(r => new VendorsViewModel { VendorId = r.VendorId, CompanyName = r.CompanyName, AddressLine1 = r.AddressLine1, AddressLine2 = r.AddressLine2, City = r.City, State = r.State, Zip = r.Zip, TaxId = r.TaxId }).FirstOrDefault(); vendor.ConsultantsCount = this._context.Enrollment.Where(r => r.VendorId == vendorId).Select(r => r.CandidateId).Distinct().Count(); //Vendor Contatct if (vendorId != 0) { var contact = this._context.Vendor_Contact.Where(r => r.VendorId == vendorId && r.IsSignatory != "Y").Select (r => new { Id = r.VendorContactId, ContactFirstName = r.Name, JobTitle = r.JobTitle, ContactEmail = r.Email, Phone = r.Phone }).ToList(); if (contact == null) { contact = this._context.Vendor_Contact.Where(r => r.VendorId == vendorId && r.IsSignatory == "Y").Select (r => new { Id = r.VendorContactId, ContactFirstName = r.Name, JobTitle = r.JobTitle, ContactEmail = r.Email, Phone = r.Phone }).ToList(); } foreach (var theContact in contact) { vendor.ContactId = theContact.Id; vendor.ContactName = theContact.ContactFirstName; vendor.ContactTitle = theContact.JobTitle; vendor.ContactEmail = theContact.ContactEmail; vendor.ContactPhone = theContact.Phone; } var signatory = this._context.Vendor_Contact.Where(r => r.VendorId == vendorId && r.IsSignatory == "Y").Select (r => new { Id = r.VendorContactId, ContactFirstName = r.Name, JobTitle = r.JobTitle, ContactEmail = r.Email, Phone = r.Phone }).ToList(); foreach (var theContact in signatory) { vendor.SignatoryId = theContact.Id; vendor.SignatoryName = theContact.ContactFirstName; vendor.SignatoryTitle = theContact.JobTitle; vendor.SignatoryEmail = theContact.ContactEmail; vendor.SignatoryPhone = theContact.Phone; } } return(vendor); }
public VendorsList() { InitializeComponent(); BindingContext = new VendorsViewModel(); }