Esempio n. 1
0
        public async Task <ActionResult> UpdateInspectionResult(InspectionExt inspectionObj)
        {
            USerLoginDetails uld = new USerLoginDetails();
            var userDetails      = await uld.UserDetails();

            var user = userDetails.DisplayName;

            Auditdetails = new AuditInspectionDetail();
            InspectionExt InspectionExtResult = db.InspectionExts.FirstOrDefault(s => s.ID.Equals(inspectionObj.ID));
            //var InspectionResult = db.Inspections.FirstOrDefault(s => s.ID.Equals(inspectionObj.InspectionID));

            DateTime dateTime = DateTime.Now;

            if (InspectionExtResult == null || inspectionObj == null)
            {
                throw new ArgumentNullException();
            }
            if (InspectionExtResult.Compliant != inspectionObj.Compliant)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "Compliant";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.Compliant) ? "NULL" : InspectionExtResult.Compliant;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.Compliant) ? "NULL" : inspectionObj.Compliant;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.Remarks != inspectionObj.Remarks)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "Remarks";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.Remarks) ? "NULL" : InspectionExtResult.Remarks;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.Remarks) ? "NULL" : inspectionObj.Remarks;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.Severity != inspectionObj.Severity)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "Severity";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.Severity) ? "NULL" : InspectionExtResult.Severity;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.Severity) ? "NULL" : inspectionObj.Severity;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.Assignee != inspectionObj.Assignee)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "Assignee";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.Assignee) ? "NULL" : InspectionExtResult.Assignee;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.Assignee) ? "NULL" : inspectionObj.Assignee;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.DueDate != inspectionObj.DueDate)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "DueDate";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.DueDate) ? "NULL" : InspectionExtResult.DueDate;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.DueDate) ? "NULL" : inspectionObj.DueDate;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.Status != inspectionObj.Status)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "Status";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.Status) ? "NULL" : InspectionExtResult.Status;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.Status) ? "NULL" : inspectionObj.Status;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.ClosureDate != inspectionObj.ClosureDate)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "ClosureDate";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.ClosureDate) ? "NULL" : InspectionExtResult.ClosureDate;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.ClosureDate) ? "NULL" : inspectionObj.ClosureDate;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }
            if (InspectionExtResult.UpdatedComments != inspectionObj.UpdatedComments)
            {
                Auditdetails.InspectionID = InspectionExtResult.InspectionID;
                Auditdetails.TableName    = "InspectionExt";
                Auditdetails.FiledName    = "UpdatedComments";
                Auditdetails.OldValue     = string.IsNullOrEmpty(InspectionExtResult.UpdatedComments) ? "NULL" : InspectionExtResult.UpdatedComments;
                Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionObj.UpdatedComments) ? "NULL" : inspectionObj.UpdatedComments;
                Auditdetails.ModifiedBy   = user;
                Auditdetails.ModifiedDate = dateTime;
                Auditdetails.CompliantNo  = inspectionObj.CompliantNo;
                db.AuditInspectionDetails.Add(Auditdetails);
                db.SaveChanges();
            }

            InspectionExtResult.LastModifiedBy   = user;
            InspectionExtResult.LastModifiedDate = dateTime;

            UpdateModel(InspectionExtResult);
            db.SaveChanges();

            TempData["Success"] = "Updated sccessfully";
            return(Json("Result"));
        }
Esempio n. 2
0
        public async Task <ActionResult> Edit(InpectionViewModel inspectionViewResult)
        {
            try
            {
                USerLoginDetails uld = new USerLoginDetails();
                var userDetails      = await uld.UserDetails();

                var user = userDetails.DisplayName;

                Auditdetails = new AuditInspectionDetail();

                var inspectionResult = (from ins in db.Inspections
                                        where ins.ID == inspectionViewResult.Inspections.ID
                                        select ins).FirstOrDefault();

                DateTime dateTime = DateTime.Now;
                if (inspectionResult == null)
                {
                    throw new ArgumentNullException();
                }
                if (inspectionResult.SiteName != inspectionViewResult.Inspections.SiteName)
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Site Name";
                    Auditdetails.OldValue     = string.IsNullOrEmpty(inspectionResult.SiteName) ? "" : inspectionResult.SiteName;
                    Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionViewResult.Inspections.SiteName) ? "" : inspectionViewResult.Inspections.SiteName;
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }
                if (inspectionResult.SiteID != inspectionViewResult.Inspections.SiteID)
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Site ID";
                    Auditdetails.OldValue     = string.IsNullOrEmpty(inspectionResult.SiteID) ? "" : inspectionResult.SiteID;
                    Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionViewResult.Inspections.SiteID) ? "" : inspectionViewResult.Inspections.SiteID;
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }
                if (inspectionResult.AreaOfBusiness != inspectionViewResult.Inspections.AreaOfBusiness)
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Area of Business";
                    Auditdetails.OldValue     = string.IsNullOrEmpty(inspectionResult.AreaOfBusiness) ? "" : inspectionResult.AreaOfBusiness;
                    Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionViewResult.Inspections.AreaOfBusiness) ? "" : inspectionViewResult.Inspections.AreaOfBusiness;
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }
                if (inspectionResult.AreaInspected != inspectionViewResult.Inspections.AreaInspected)
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Area Inspected";
                    Auditdetails.OldValue     = string.IsNullOrEmpty(inspectionResult.AreaInspected) ? "" : inspectionResult.AreaInspected;
                    Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionViewResult.Inspections.AreaInspected) ? "" : inspectionViewResult.Inspections.AreaInspected;
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }
                if (inspectionResult.InspectedPerson != inspectionViewResult.Inspections.InspectedPerson)
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Inspected Person";
                    Auditdetails.OldValue     = string.IsNullOrEmpty(inspectionResult.InspectedPerson) ? "" : inspectionResult.InspectedPerson;
                    Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionViewResult.Inspections.InspectedPerson) ? "" : inspectionViewResult.Inspections.InspectedPerson;
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }

                if ((string.IsNullOrEmpty(inspectionResult.ActivityName) ? null : inspectionResult.ActivityName) != inspectionViewResult.Inspections.ActivityName)
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Activity Name";
                    Auditdetails.OldValue     = string.IsNullOrEmpty(inspectionResult.ActivityName) ? "" : inspectionResult.ActivityName;
                    Auditdetails.NewValue     = string.IsNullOrEmpty(inspectionViewResult.Inspections.ActivityName) ? "" : inspectionViewResult.Inspections.ActivityName;
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }
                if (inspectionResult.InspectionDate.ToString("dd/MM/yyyy") != inspectionViewResult.Inspections.InspectionDate.ToString("dd/MM/yyyy"))
                {
                    Auditdetails.InspectionID = inspectionViewResult.Inspections.ID;
                    Auditdetails.TableName    = "Inspection";
                    Auditdetails.FiledName    = "Inspection Date";
                    Auditdetails.OldValue     = inspectionResult.InspectionDate.ToString("dd/MM/yyyy");
                    Auditdetails.NewValue     = inspectionViewResult.Inspections.InspectionDate.ToString("dd/MM/yyyy");
                    Auditdetails.ModifiedBy   = user;
                    Auditdetails.ModifiedDate = dateTime;
                    db.AuditInspectionDetails.Add(Auditdetails);
                    db.SaveChanges();
                }

                inspectionResult.InspectionForm  = inspectionResult.InspectionForm;
                inspectionResult.SiteName        = inspectionViewResult.Inspections.SiteName;
                inspectionResult.SiteID          = inspectionViewResult.Inspections.SiteID;
                inspectionResult.AreaOfBusiness  = inspectionViewResult.Inspections.AreaOfBusiness;
                inspectionResult.AreaInspected   = inspectionViewResult.Inspections.AreaInspected;
                inspectionResult.InspectedPerson = inspectionViewResult.Inspections.InspectedPerson;
                inspectionResult.ActivityName    = inspectionViewResult.Inspections.ActivityName;
                inspectionResult.InspectionDate  = inspectionViewResult.Inspections.InspectionDate;

                inspectionResult.LastModifiedBy   = user;
                inspectionResult.LastModifiedDate = dateTime;

                db.SaveChanges();
                TempData["Success"] = "Updated sccessfully";
            }
            catch (Exception)
            {
                // ignored
            }

            return(RedirectToAction("Edit/" + inspectionViewResult.Inspections.ID));
        }