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();
}
