public int PostRetroInfo(RetroInfoModel retroInfoModel)
        {
            var myData = new tbl_trn_retroinfo
            {
                retroinfo_name           = retroInfoModel.retroinfo_name,
                retroinfo_projectinfo_id = retroInfoModel.retroinfo_projectinfo_id,
                retroinfo_sprint         = retroInfoModel.retroinfo_sprint,
                retroinfo_date           = DateTime.UtcNow.ToString("yyy-MM-dd"),
                retroinfo_imagepath      = retroInfoModel.retroinfo_imagepath,
                retroinfo_imageinfo_id   = retroInfoModel.retroinfo_imageinfo_id,
                retroinfo_status         = retroInfoModel.retroinfo_status,
                retroinfo_isdeleted      = retroInfoModel.retroinfo_isdeleted,
            };
            var response = this.InsertandSave(myData);

            return(response.retroinfo_id);
        }
示例#2
0
        private Stream GetExcelSheet(DataSet resultdata, RetroInfoModel headerData, string imageData)
        {
            using (var package = new ExcelPackage())
            {
                var worksheet = package.Workbook.Worksheets.Add("Retrospective");
                worksheet.Cells["A8"].LoadFromDataTable(resultdata.Tables[0], true);

                worksheet.Cells[2, 2, 2, 2].Value           = "Retrospective";
                worksheet.Cells[2, 2, 2, 3].Merge           = true;
                worksheet.Cells[2, 2, 2, 2].Style.Font.Bold = true;
                worksheet.Cells[2, 2, 2, 2].Style.Font.Color.SetColor(Color.White);
                worksheet.Cells[2, 2, 2, 2].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

                var fillRetroTitle = worksheet.Cells[2, 2, 2, 2].Style.Fill;
                fillRetroTitle.PatternType = ExcelFillStyle.Solid;
                fillRetroTitle.BackgroundColor.SetColor(Color.Purple);

                worksheet.Cells[3, 2, 3, 2].Value = "Retro Name";
                worksheet.Cells[4, 2, 4, 2].Value = "Project Name";
                worksheet.Cells[5, 2, 5, 2].Value = "Sprint";
                worksheet.Cells[6, 2, 6, 2].Value = "Date";

                worksheet.Cells[3, 3, 3, 3].Value = headerData.retroinfo_name;
                worksheet.Cells[4, 3, 4, 3].Value = headerData.retroinfo_projectinfo_name;
                worksheet.Cells[5, 3, 5, 3].Value = headerData.retroinfo_sprint;
                worksheet.Cells[6, 3, 6, 3].Value = headerData.retroinfo_date;

                var fillRetroHeader = worksheet.Cells[3, 2, 6, 3].Style.Fill;
                fillRetroHeader.PatternType = ExcelFillStyle.Solid;
                fillRetroHeader.BackgroundColor.SetColor(Color.Orange);

                worksheet.Cells[8, 1, 8, resultdata.Tables[0].Columns.Count].Style.Font.Bold = true;
                worksheet.Cells[8, 1, 8, resultdata.Tables[0].Columns.Count].Style.Font.Color.SetColor(Color.White);
                worksheet.Cells[8, 1, 8, resultdata.Tables[0].Columns.Count].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

                var fillDataHeader = worksheet.Cells[8, 1, 8, resultdata.Tables[0].Columns.Count].Style.Fill;
                fillDataHeader.PatternType = ExcelFillStyle.Solid;
                fillDataHeader.BackgroundColor.SetColor(Color.Purple);

                for (int i = 1; i <= resultdata.Tables[0].Columns.Count; i++)
                {
                    var fillRetroDetals = worksheet.Cells[9, i, 8 + resultdata.Tables[0].Rows.Count, i].Style.Fill;
                    fillRetroDetals.PatternType = ExcelFillStyle.Solid;
                    var colColor = resultdata.Tables[1].Rows[i - 1][0].ToString();
                    var color    = ColorTranslator.FromHtml(colColor);
                    fillRetroDetals.BackgroundColor.SetColor(color);
                }

                if (imageData != null && imageData != string.Empty)
                {
                    Bitmap       image   = LoadImage(imageData);
                    ExcelPicture picture = null;
                    if (image != null)
                    {
                        picture             = worksheet.Drawings.AddPicture("picRetro", image);
                        picture.From.Column = resultdata.Tables[0].Columns.Count + 1;
                        picture.From.Row    = 2;
                        picture.SetSize(800, 600);
                    }
                }

                var stream = new MemoryStream(package.GetAsByteArray());
                return(stream);
            }
        }
        public HttpResponseMessage Post(RetroInfoModel retroInfoModel)
        {
            var response = this.retrospectiveInformationService.PostRetroInfo(retroInfoModel);

            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }