private void InsertOrUpdateCompanyServices(int certId, EcomCert_Service companyService) { // Company Services EcomCert_Service certCompanyServices = _db.EcomCert_Service .Find(certId); using (MSDBContext db = new MSDBContext()) { // Add new record if (certCompanyServices == null) { certCompanyServices = new EcomCert_Service(); certCompanyServices = companyService; certCompanyServices.CertID = certId; certCompanyServices.CreatedDate = DateTime.Now; db.EcomCert_Service.Add(certCompanyServices); } // Update existing else { certCompanyServices = companyService; certCompanyServices.CertID = certId; certCompanyServices.ModifiedDate = DateTime.Now; db.EcomCert_Service.Attach(certCompanyServices); db.Entry(certCompanyServices).State = EntityState.Modified; } db.SaveChanges(); } }
public ActionResult ReportCertified(int id) { /*if (Request.UrlReferrer == null || (Request.UrlReferrer != null && Request.UrlReferrer.AbsoluteUri != "http://wcaecommerce.wcaworld.com/eng/report_cert.asp")) * { * return RedirectToAction("Login", "Account"); * }*/ if (Session["temp_report"] == null) { return(RedirectToAction("Login", "Application")); } //int Cid = Convert.ToInt32(HttpContext.Session["Cid"]); int CertId = id; int Cid = _db.EcomCerts.Where(r => r.CertID == CertId).FirstOrDefault().Cid; if (Cid == 0) { //redirec to login } ViewMember member = _db.Members.AsNoTracking() .Include(x => x.Memberships) .Include(x => x.Memberships.Select(y => y.Network)) .FirstOrDefault(x => x.Cid == Cid && x.Nid == 103); if (member == null) { //redirec to logi } CertifiedMemberApplicationView model = new CertifiedMemberApplicationView(); model.Company = member; model.Company.Memberships = member.Memberships; model.EcomCert.Cid = Cid; model.Company_Detail.CompName = member.Company; EcomCert cert = _db.EcomCerts.AsNoTracking() .FirstOrDefault(x => x.Cid == Cid); if (cert != null) { int StatusId = _db.EcomCert_Status.AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.StatusID) .FirstOrDefault(); // Status model.Status = StatusId == 1 ? "draft" : "submitted"; // Company detail EcomCert_CompDetail companyDetail = _db.EcomCert_CompDetail .Find(cert.CertID); model.Company_Detail = companyDetail; IEnumerable <int> productsHandled = _db.EcomCert_Product_Handled .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.ProductId) .ToList(); model.Products_Handled = productsHandled; // Company service EcomCert_Service companyService = _db.EcomCert_Service .Find(cert.CertID); // Company service: services provide IEnumerable <int> companyServicesProvide = _db.EcomCert_Service_Provide .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.ServiceId) .ToList(); model.Company_Service = companyService; model.Services = companyServicesProvide; // Company service cross-border service provide model.CrossBorderServices = _db.EcomCert_Service_CrossBorder .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.CrossBorderId) .ToList(); // Company service: GroundServices model.GroundServices = _db.EcomCert_Service_Ground .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.GroundServiceId) .ToList(); // Company service: TransportFleets model.TransportFleets = _db.EcomCert_Service_TransportFleet .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.TransportFleetId) .ToList(); // Company service: PayOnDelivery model.PayOnDelivery = _db.EcomCert_Service_PayOnDelivery .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.PaymentTypeId) .ToList(); // Company service: InternalBounds model.InternalBounds = _db.EcomCert_Service_InternalBound .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.InternalBoundId) .ToList(); // Company IT EcomCert_IT companyIT = _db.EcomCert_IT .Find(cert.CertID); model.Company_IT = companyIT; } return(View(model)); }
//[Authorize] public ActionResult Certified(int cId = 0) { int Cid = cId == 0 ? Convert.ToInt32(HttpContext.Session["Cid"]) : cId; ViewMember member = _db.Members.AsNoTracking() .Include(x => x.Memberships) .Include(x => x.Memberships.Select(y => y.Network)) .FirstOrDefault(x => x.Cid == Cid && x.Nid == 103); if (member == null) { //redirec to login return(RedirectToAction("Login", "Account", new { returnUrl = "application/certified" })); } CertifiedMemberApplicationView model = new CertifiedMemberApplicationView(); model.Company = member; model.Company.Memberships = member.Memberships; model.EcomCert.Cid = Cid; model.Company_Detail.CompName = member.Company; EcomCert cert = _db.EcomCerts.AsNoTracking() .FirstOrDefault(x => x.Cid == Cid); if (cert != null) { int StatusId = _db.EcomCert_Status.AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.StatusID) .FirstOrDefault(); // Status model.Status = StatusId == 1 ? "draft" : "submitted"; // Company detail EcomCert_CompDetail companyDetail = _db.EcomCert_CompDetail .Find(cert.CertID); model.Company_Detail = companyDetail == null ? new EcomCert_CompDetail() : companyDetail; IEnumerable <int> productsHandled = _db.EcomCert_Product_Handled .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.ProductId) .ToList(); model.Products_Handled = productsHandled; // Company service EcomCert_Service companyService = _db.EcomCert_Service .Find(cert.CertID); // Company service: services provide IEnumerable <int> companyServicesProvide = _db.EcomCert_Service_Provide .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.ServiceId) .ToList(); model.Company_Service = companyService == null ? new EcomCert_Service() : companyService; model.Services = companyServicesProvide; // Company service cross-border service provide model.CrossBorderServices = _db.EcomCert_Service_CrossBorder .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.CrossBorderId) .ToList(); // Company service: GroundServices model.GroundServices = _db.EcomCert_Service_Ground .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.GroundServiceId) .ToList(); // Company service: TransportFleets model.TransportFleets = _db.EcomCert_Service_TransportFleet .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.TransportFleetId) .ToList(); // Company service: PayOnDelivery model.PayOnDelivery = _db.EcomCert_Service_PayOnDelivery .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.PaymentTypeId) .ToList(); // Company service: InternalBounds model.InternalBounds = _db.EcomCert_Service_InternalBound .AsNoTracking() .Where(x => x.CertID == cert.CertID) .Select(x => x.InternalBoundId) .ToList(); // Company IT EcomCert_IT companyIT = _db.EcomCert_IT .Find(cert.CertID); model.Company_IT = companyIT == null ? new EcomCert_IT() : companyIT; } return(View(model)); }