public ActionResult EditPortfolioItem([Bind(Include = "Id,TCid,StageId,NextMoveId,NextMoveDate,ResponsibleEmail,ResponsibleName,OpportunityDate,Comment")] PortfolioItem portfolioItem, long portfolioId)
{
if (!ModelState.IsValid)
{
return(EditPortfolioItem(portfolioItem.Id, portfolioItem.TCid, portfolioId));
}
if (!Utilities.IsEmailValid(portfolioItem.ResponsibleEmail))
{
ViewBag.Message = "Invalid email address";
return(View("EditPortfolioItem", new PortfolioItemViewModel
{
TcBasicInfo = _techCompanyService.GetTcWithChildren(portfolioItem.TCid),
PortfolioItem = portfolioItem,
Stages = GetStages()
}));
}
using (var db = new InnosixEntities())
{
db.Entry(portfolioItem).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("PortfolioItems", new { id = portfolioId }));
}
private IEnumerable <int> GetTagsInLevelRenge(int[] tagIds, int levelRange)
{
var tagIdsInRange = new HashSet <int>();
using (var db = new InnosixEntities())
{
var relationTable = db.GetTagHierarchy().ToList();
foreach (var tagId in tagIds)
{
var nodes = relationTable.Where(x => x.Node.Contains($"/{tagId}/") || (x.TagId == tagId && x.Level > 0));
foreach (var node in nodes)
{
var nodeTagIds = node.Node.Split(new[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
var tagIndex = nodeTagIds.IndexOf(tagId.ToString());
var indexStart = tagIndex - levelRange;
indexStart = indexStart > 0 ? indexStart : 0;
var indexEnd = tagIndex + levelRange;
indexEnd = indexEnd < nodeTagIds.Length - 1 ? indexEnd : nodeTagIds.Length - 1;
for (var i = indexStart; i <= indexEnd; i++)
{
tagIdsInRange.Add(int.Parse(nodeTagIds[i]));
}
}
}
}
return(tagIdsInRange);
}
public ActionResult DeleteAccount()
{
var userId = User.Identity.GetUserId();
using (var db = new InnosixEntities())
{
var user = UserManager.FindById(userId);
var userToTc = db.AspNetUsersToTC
.FirstOrDefault(tc => tc.AspNetUserId == userId);
if (userToTc != null)
{
var tcBasicInfo = db.TCBasicInfo
.Include(x => x.TCActive)
.First(x => x.Id == userToTc.TCid);
tcBasicInfo.TCActive.IsActive = false;
db.Entry(tcBasicInfo).State = EntityState.Modified;
db.AspNetUsersToTC.Remove(userToTc);
db.SaveChanges();
}
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
UserManager.Delete(user);
}
return(View("DeleteAccountMessage"));
}
public ActionResult PassOwnerShipAccept()
{
using (var db = new InnosixEntities())
using (var transaction = db.Database.BeginTransaction())
{
try
{
var userId = User.Identity.GetUserId();
var tcId = db.AspNetUsersToTC.First(x => x.AspNetUserId == userId).TCid;
var usersToTc = db.AspNetUsersToTC.First(x => x.AspNetUserId == userId && x.TCid == tcId);
var claim = db.AspNetUsersTcClaim.First(x => x.TCid == tcId);
if (claim == null)
{
return(RedirectToAction("Index", "Manage"));
}
usersToTc.AspNetUserId = claim.AspNetUserId;
db.AspNetUsersTcClaim.Remove(claim);
db.Entry(usersToTc).State = EntityState.Modified;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
return(RedirectToAction("Index", "Manage"));
}
public ActionResult EditIdealPartner(TCIdealPartner tcIdealPartner)
{
if (!ModelState.IsValid)
{
return(View(tcIdealPartner));
}
using (var db = new InnosixEntities())
{
db.TCGeneral.Find(tcIdealPartner.TCid).LastUpdated = DateTime.Now;
var tcIdealPartnerExists = db.TCIdealPartner.Any(x => x.TCid == tcIdealPartner.TCid);
if (tcIdealPartnerExists)
{
db.Entry(tcIdealPartner).State = EntityState.Modified;
}
else
{
db.TCIdealPartner.Add(tcIdealPartner);
}
db.SaveChanges();
}
return(RedirectToAction("EditIdealPartner"));
}
public ActionResult EditContact(TCContact tcContact)
{
if (!ModelState.IsValid)
{
return(View(tcContact));
}
if (!Utilities.IsEmailValid(tcContact.ContactPersonEmail))
{
ViewBag.Message = "Invalid email address";
return(View("EditContact", tcContact));
}
using (var db = new InnosixEntities())
{
db.TCGeneral.Find(tcContact.TCid).LastUpdated = DateTime.Now;
var tcContactExists = db.TCContact.Any(x => x.TCid == tcContact.TCid);
if (tcContactExists)
{
db.Entry(tcContact).State = EntityState.Modified;
}
else
{
db.TCContact.Add(tcContact);
}
db.SaveChanges();
}
return(RedirectToAction("EditContact"));
}
public ActionResult Edit([Bind(Include = "Id,Address1,Address2,Address3,Zip,City,CountryId,CompanyEmail,CompanyName,CompanyPhone,LegalSuffix,CompanyWebsite,LogoUrl,RegistrationNumber")] TCBasicInfo tcBasicInfo)
{
if (!ModelState.IsValid)
{
return(View(tcBasicInfo));
}
if (!Utilities.IsEmailValid(tcBasicInfo.CompanyEmail))
{
ViewBag.Message = "Invalid email address";
PopulateCountryDropDownList(tcBasicInfo.CountryId);
return(View("Edit", tcBasicInfo));
}
if (!Utilities.ValidUrl(tcBasicInfo.CompanyWebsite))
{
ViewBag.Message = "Invalid website url";
PopulateCountryDropDownList(tcBasicInfo.CountryId);
return(View("Edit", tcBasicInfo));
}
tcBasicInfo.CompanyWebsite = Utilities.CreateValidUrl(tcBasicInfo.CompanyWebsite);
using (var db = new InnosixEntities())
{
db.TCGeneral.Find(tcBasicInfo.Id).LastUpdated = DateTime.Now;
db.Entry(tcBasicInfo).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Edit"));
}
public ActionResult EditTagUnlinkGridViewPartialUnlink(int id, int unlinkTagId)
{
using (var db = new InnosixEntities())
{
var tagRelations = db.TechTagParents.Where(t =>
(t.TechTagId == id && t.ParentTechTagId == unlinkTagId) ||
(t.TechTagId == unlinkTagId && t.ParentTechTagId == id));
try
{
if (tagRelations.Any())
{
db.TechTagParents.RemoveRange(tagRelations);
db.SaveChanges();
var updatedTag = UpdateRelationsCount(id);
var updatedUnlinkTag = UpdateRelationsCount(unlinkTagId);
if (!updatedTag || !updatedUnlinkTag)
{
throw new ArgumentNullException();
}
}
}
catch (Exception ex)
{
ViewData["EditError"] = ex.Message;
}
var tag = db.TechTag.Find(id);
return(tag == null?View("Index") : View("EditTag", tag));
}
}
private TCBasicInfo GetTcTechnology()
{
using (var db = new InnosixEntities())
{
var tcId = GetUserTc();
if (tcId == null)
{
return(null);
}
var tcBasicInfo = db.TCBasicInfo
.Include(x => x.TCTechnology)
.Include(x => x.TCTechnology.TechSector)
.Include(x => x.TechDomainToTC.Select(s => s.TechDomain))
.Include(x => x.TechTagToTC.Select(s => s.TechTag))
.First(t => t.Id == tcId);
if (tcBasicInfo.TCTechnology == null)
{
tcBasicInfo.TCTechnology = new TCTechnology {
TCid = (long)tcId
}
}
;
return(tcBasicInfo);
}
}
public TCBasicInfo GetTcWithChildren(long id)
{
TCBasicInfo tcBasicInfo;
using (var db = new InnosixEntities())
{
tcBasicInfo = db.TCBasicInfo
.Include(x => x.Country)
.Include(x => x.TCBusinessInfo)
.Include(x => x.TCBusinessInfo.Maturity)
.Include(x => x.TCBusinessInfo.Employees)
.Include(x => x.TCBusinessInfo.Revenue)
.Include(x => x.TCBusinessInfo.Nace)
.Include(x => x.TCTechnology.TechSector)
.Include(x => x.BusinessModelToTC.Select(bm => bm.BusinessModel))
.Include(x => x.TechDomainToTC.Select(td => td.TechDomain))
.Include(x => x.TechTagToTC.Select(tt => tt.TechTag))
.Include(x => x.ServicesToTC.Select(s => s.Services))
.Include(x => x.ProductToTC.Select(p => p.Product))
.Include(x => x.TCContact)
.Include(x => x.TCGeneral)
.Include(x => x.TCRating)
.FirstOrDefault(t => t.Id == id);
}
return(tcBasicInfo);
}
private long?TcExists(string companyWebsite)
{
using (var db = new InnosixEntities())
{
return(db.TCBasicInfo.FirstOrDefault(x => x.CompanyWebsite == companyWebsite)?.Id);
}
}
private IEnumerable <TechDomain> GetTechDomainList()
{
using (var db = new InnosixEntities())
{
return(db.TechDomain.ToList());
}
}
private IEnumerable <Country> GetCountryList()
{
using (var db = new InnosixEntities())
{
return(db.Country.ToList());
}
}
private bool HasTc(string id)
{
using (var db = new InnosixEntities())
{
return(db.AspNetUsersToTC.Any(x => x.AspNetUserId == id));
}
}
public ActionResult EditBusinessInfo(TCBusinessInfo tcBusinessInfo)
{
if (!ModelState.IsValid)
{
return(View(tcBusinessInfo));
}
using (var db = new InnosixEntities())
{
db.TCGeneral.Find(tcBusinessInfo.TCid).LastUpdated = DateTime.Now;
var tcBusinessInfoExists = db.TCBusinessInfo.Any(x => x.TCid == tcBusinessInfo.TCid);
if (tcBusinessInfoExists)
{
db.Entry(tcBusinessInfo).State = EntityState.Modified;
}
else
{
db.TCBusinessInfo.Add(tcBusinessInfo);
}
db.SaveChanges();
}
return(RedirectToAction("EditBusinessInfo"));
}
public ActionResult EditUser(AspNetUsers aspNetUsers, string role)
{
if (!ModelState.IsValid)
{
return(View(aspNetUsers));
}
if (!Utilities.IsEmailValid(aspNetUsers.Email))
{
ViewBag.Message = "Invalid email address";
return(View("EditUser", aspNetUsers));
}
using (var db = new InnosixEntities())
{
var oldUserRoleId = UserManager.FindById(aspNetUsers.Id).Roles.SingleOrDefault()?.RoleId;
if (role != oldUserRoleId)
{
var oldUserRole = db.AspNetRoles.Single(x => x.Id == oldUserRoleId).Name;
UserManager.RemoveFromRole(aspNetUsers.Id, oldUserRole);
var newRole = db.AspNetRoles.Single(x => x.Id == role).Name;
UserManager.AddToRole(aspNetUsers.Id, newRole);
}
db.Entry(aspNetUsers).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("EditUser"));
}
public TCBasicInfo GetTc(long id)
{
using (var db = new InnosixEntities())
{
return(db.TCBasicInfo.Find(id));
}
}
private bool AutomaticClaimAccept(string userId, long tcId)
{
using (var db = new InnosixEntities())
{
var exists = db.AspNetUsersToTC.Any(x => x.AspNetUserId == userId && x.TCid == tcId);
if (exists)
{
return(false);
}
db.AspNetUsersToTC.Add(
new AspNetUsersToTC
{
AspNetUserId = userId,
TCid = tcId
});
var tc = db.TCBasicInfo
.Include("TCActive")
.FirstOrDefault(x => x.Id == tcId);
if (tc == null)
{
return(false);
}
tc.TCActive.IsActive = true;
db.SaveChanges();
return(true);
}
}
public ActionResult AcceptClaim(int id, string userId, long tcId)
{
using (var db = new InnosixEntities())
{
db.AspNetUsersToTC.Add(
new AspNetUsersToTC
{
AspNetUserId = userId,
TCid = tcId
});
var tc = db.TCBasicInfo
.Include("TCActive")
.FirstOrDefault(x => x.Id == tcId);
if (tc == null)
{
return(View("Index"));
}
tc.TCActive.IsActive = true;
var claim = db.AspNetUsersTcClaim.Find(id);
if (claim == null)
{
return(View("Index"));
}
db.AspNetUsersTcClaim.Remove(claim);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult ProductsGridViewPartialUpdate(Product item, long tcId)
{
using (var db = new InnosixEntities())
{
var model = db.Product;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.Id == item.Id);
if (modelItem != null)
{
UpdateModel(modelItem);
db.SaveChanges();
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
return(ProductsGridViewPartial(tcId));
}
}
public ActionResult TechSectorGridViewPartialUpdate(TechSector item)
{
using (var db = new InnosixEntities())
{
var model = db.TechSector;
if (ModelState.IsValid)
{
try
{
var modelItem = model.FirstOrDefault(it => it.Id == item.Id);
if (modelItem != null)
{
UpdateModel(modelItem);
db.SaveChanges();
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
return(PartialView("_TechSectorGridViewPartial", model.ToList()));
}
}
public ActionResult TCsGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.VTcWithTags.OrderBy(x => x.CompanyName);
return(PartialView("_TCsGridViewPartial", model.ToList()));
}
}
public ActionResult ClaimTcGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.VUserTcClaim.Where(x => !x.IsActive);
return(PartialView("_ClaimTcGridViewPartial", model.ToList()));
}
}
public ActionResult ServicesGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.Services;
return(PartialView("_ServicesGridViewPartial", model.ToList()));
}
}
public ActionResult TechSectorGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.TechSector;
return(PartialView("_TechSectorGridViewPartial", model.ToList()));
}
}
public ActionResult RevenueGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.Revenue;
return(PartialView("_RevenueGridViewPartial", model.ToList()));
}
}
public ActionResult MaturityGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.Maturity;
return(PartialView("_MaturityGridViewPartial", model.ToList()));
}
}
public ActionResult ClusterGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.Cluster;
return(PartialView("_ClusterGridViewPartial", model.ToList()));
}
}
public ActionResult CountryGridView1Partial()
{
using (var db = new InnosixEntities())
{
var model = db.Country;
return(PartialView("_CountryGridView1Partial", model.ToList()));
}
}
public ActionResult BusinessModelGridViewPartial()
{
using (var db = new InnosixEntities())
{
var model = db.BusinessModel;
return(PartialView("_BusinessModelGridViewPartial", model.ToList()));
}
}
