Ejemplo n.º 1
0
        public IHttpActionResult Post([FromBody] CreateTOTReportModel model)
        {
            if (ModelState.IsValid)
            {
                var report = new TOTReport
                {
                    Module             = model.Module,
                    StartDate          = model.StartDate.Value,
                    EndDate            = model.EndDate.Value,
                    Venue              = model.Venue,
                    Organization       = model.Organization,
                    AgeR1NoOfMale      = model.AgeR1NoOfMale,
                    AgeR1NoOfFemale    = model.AgeR1NoOfFemale,
                    AgeR2NoOfMale      = model.AgeR2NoOfMale,
                    AgeR2NoOfFemale    = model.AgeR2NoOfFemale,
                    AgeR3NoOfMale      = model.AgeR3NoOfMale,
                    AgeR3NoOfFemale    = model.AgeR3NoOfFemale,
                    AgeR4NoOfMale      = model.AgeR4NoOfMale,
                    AgeR4NoOfFemale    = model.AgeR4NoOfFemale,
                    AgeR5NoOfMale      = model.AgeR5NoOfMale,
                    AgeR5NoOfFemale    = model.AgeR5NoOfFemale,
                    SalaryR1NoOfMale   = model.SalaryR1NoOfMale,
                    SalaryR1NoOfFemale = model.SalaryR1NoOfFemale,
                    SalaryR2NoOfMale   = model.SalaryR2NoOfMale,
                    SalaryR2NoOfFemale = model.SalaryR2NoOfFemale,
                    SalaryR3NoOfMale   = model.SalaryR3NoOfMale,
                    SalaryR3NoOfFemale = model.SalaryR3NoOfFemale,
                    SalaryR4NoOfMale   = model.SalaryR4NoOfMale,
                    SalaryR4NoOfFemale = model.SalaryR4NoOfFemale,
                    SalaryR5NoOfMale   = model.SalaryR5NoOfMale,
                    SalaryR5NoOfFemale = model.SalaryR5NoOfFemale,
                    SalaryR6NoOfMale   = model.SalaryR6NoOfMale,
                    SalaryR6NoOfFemale = model.SalaryR6NoOfFemale,
                    CreatedBy          = model.CreatedBy,
                    CreatedDate        = DateTime.Now
                };

                db.TOTReport.Add(report);

                foreach (var fileid in model.FilesId)
                {
                    var reportfile = new TOTReportFile
                    {
                        FileId = fileid,
                        Report = report
                    };
                    db.TOTReportFile.Add(reportfile);
                }

                db.SaveChanges();

                return(Ok(report));
            }

            return(BadRequest(ModelState));
        }
Ejemplo n.º 2
0
        public IHttpActionResult Put(int id, [FromBody] EditTOTReportModel model)
        {
            if (ModelState.IsValid)
            {
                var report = db.TOTReport.Where(u => u.Id == id).FirstOrDefault();

                if (report == null)
                {
                    return(NotFound());
                }

                report.Module             = model.Module;
                report.StartDate          = model.StartDate;
                report.EndDate            = model.EndDate;
                report.Venue              = model.Venue;
                report.Organization       = model.Organization;
                report.AgeR1NoOfMale      = model.AgeR1NoOfMale;
                report.AgeR1NoOfFemale    = model.AgeR1NoOfFemale;
                report.AgeR2NoOfMale      = model.AgeR2NoOfMale;
                report.AgeR2NoOfFemale    = model.AgeR2NoOfFemale;
                report.AgeR3NoOfMale      = model.AgeR3NoOfMale;
                report.AgeR3NoOfFemale    = model.AgeR3NoOfFemale;
                report.AgeR4NoOfMale      = model.AgeR4NoOfMale;
                report.AgeR4NoOfFemale    = model.AgeR4NoOfFemale;
                report.AgeR5NoOfMale      = model.AgeR5NoOfMale;
                report.AgeR5NoOfFemale    = model.AgeR5NoOfFemale;
                report.SalaryR1NoOfMale   = model.SalaryR1NoOfMale;
                report.SalaryR1NoOfFemale = model.SalaryR1NoOfFemale;
                report.SalaryR2NoOfMale   = model.SalaryR2NoOfMale;
                report.SalaryR2NoOfFemale = model.SalaryR2NoOfFemale;
                report.SalaryR3NoOfMale   = model.SalaryR3NoOfMale;
                report.SalaryR3NoOfFemale = model.SalaryR3NoOfFemale;
                report.SalaryR4NoOfMale   = model.SalaryR4NoOfMale;
                report.SalaryR4NoOfFemale = model.SalaryR4NoOfFemale;
                report.SalaryR5NoOfMale   = model.SalaryR5NoOfMale;
                report.SalaryR5NoOfFemale = model.SalaryR5NoOfFemale;
                report.SalaryR6NoOfMale   = model.SalaryR6NoOfMale;
                report.SalaryR6NoOfFemale = model.SalaryR6NoOfFemale;

                db.Entry(report).State = EntityState.Modified;

                //remove file
                var attachments = db.TOTReportFile.Where(s => s.TOTReportId == model.Id).ToList();

                if (attachments != null)
                {
                    //delete all
                    if (model.Attachments == null)
                    {
                        foreach (var attachment in attachments)
                        {
                            attachment.FileDocument.Display = false;
                            db.FileDocument.Attach(attachment.FileDocument);
                            db.Entry(attachment.FileDocument).Property(m => m.Display).IsModified = true;

                            db.TOTReportFile.Remove(attachment);
                        }
                    }
                    else
                    {
                        foreach (var attachment in attachments)
                        {
                            if (!model.Attachments.Any(u => u.Id == attachment.FileDocument.Id))//delete if not exist anymore
                            {
                                attachment.FileDocument.Display = false;
                                db.FileDocument.Attach(attachment.FileDocument);
                                db.Entry(attachment.FileDocument).Property(m => m.Display).IsModified = true;

                                db.TOTReportFile.Remove(attachment);
                            }
                        }
                    }
                }

                //add files
                foreach (var fileid in model.FilesId)
                {
                    var reportfile = new TOTReportFile
                    {
                        FileId      = fileid,
                        TOTReportId = id
                    };

                    db.TOTReportFile.Add(reportfile);
                }

                db.Configuration.ValidateOnSaveEnabled = true;
                db.SaveChanges();

                return(Ok(true));
            }

            return(BadRequest(ModelState));
        }