Exemple #1
0
        public RequestResponse DeleteSingleService(int id)
        {
            RequestResponse RequestResponse = new RequestResponse();

            try
            {
                //First check if its used in project already
                bool ifExist = new ServiceCRUD().CheckIfServiceAsocWithProject(id);
                if (ifExist == true)
                {
                    RequestResponse.Message = "Not deleted, Record is used in Project.";
                    RequestResponse.Success = false;
                    return(RequestResponse);
                }

                new ServiceCRUD().DeleteSingle(id);
                RequestResponse.Message = "Record deleted";
                RequestResponse.Success = true;
            }
            catch (Exception ex)
            {
                RequestResponse.Message = ex.Message;
                RequestResponse.Success = false;
            }

            return(RequestResponse);
        }
Exemple #2
0
        public void HTMLToPdf(string FilePath, string newpath, ProjectENT model, CompanyProfileENT setings, string contentRootPath, ProjectWorkflowENT Param)
        {
            PostCodeENT           PostNumbData        = new MiscellaneousCRUD().GetSinglePostCodeByPostNumber(Convert.ToString(setings.postCode));
            List <ProjectService> ListProjectServices = new ProjectCRUD().ListOfProjectServicesByWorkflowID(Param.WorkflowId, Param.ProjectId);
            List <int?>           ServiceIDs          = ListProjectServices.Select(x => x.ServiceId).ToList();
            List <ServiceENT>     ServiceMultiData    = new ServiceCRUD().GetMultipleServiceByMultiServiceIDs(ServiceIDs);

            string pdfPath = newpath;                                            // The file location of the new PDF file

            PdfReader  reader  = new PdfReader(FilePath);                        // filename is the path to the PDF template file.
            FileStream output  = new FileStream(pdfPath, FileMode.OpenOrCreate); // you can also use a Memory Stream.
            PdfStamper stamper = new PdfStamper(reader, output);                 // the stamper is required for updating fields.
            AcroFields af      = reader.AcroFields;

            stamper.AcroFields.GenerateAppearances = false;
            ////Table one
            //stamper.AcroFields.SetField("Tekst498", "uzb");
            //stamper.AcroFields.SetField("Tekst257", "uzb1");
            //stamper.AcroFields.SetField("Tekst261", "uzb2");
            //stamper.AcroFields.SetField("Tekst266", "uzb3");
            stamper.AcroFields.SetField("Tekst264", "uzb3");
            stamper.AcroFields.SetField("Tekst257", model.GardsNo);
            stamper.AcroFields.SetField("Tekst261", model.Bruksnmmer);
            stamper.AcroFields.SetField("Tekst264", model.Kommune);
            stamper.AcroFields.SetField("Tekst254", model.Address);
            stamper.AcroFields.SetField("Tekst255", model.PostNo);
            stamper.AcroFields.SetField("Tekst256", model.Poststed);
            ////Table two
            stamper.AcroFields.SetField("Foretak_2", setings.companyName);
            stamper.AcroFields.SetField("Organisasjonsnr", setings.organizationalNumber);
            stamper.AcroFields.SetField("Adresse_2", setings.address);
            stamper.AcroFields.SetField("Tekst4", Convert.ToString(setings.postCode));
            //stamper.AcroFields.SetField("Tekst5", setings.City.Name);
            stamper.AcroFields.SetField("Tekst5", PostNumbData.Poststed);
            stamper.AcroFields.SetField("Tekst105", setings.ownerName);
            stamper.AcroFields.SetField("Telefon", setings.telephone);
            stamper.AcroFields.SetField("Mobiltelefon", setings.mobile);
            //stamper.AcroFields.SetField("Tekst106", setings.EmailAddress);
            ////Services Table
            int a = 1;

            //Empty 1st two rows of grid
            stamper.AcroFields.SetField("NedtrekkslisteRow1", "-");
            stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow1", "");
            stamper.AcroFields.SetField("Nedtrekksliste23", "-");
            stamper.AcroFields.SetField("Avmerkingsboks10#1", "Off");
            stamper.AcroFields.SetField("Avmerkingsboks810", "Off");

            stamper.AcroFields.SetField("Nedtrekk121", "-");
            stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow2", "");
            stamper.AcroFields.SetField("Nedtrekksliste24", "-");
            stamper.AcroFields.SetField("Avmerkingsboks1101", "Off");
            stamper.AcroFields.SetField("Avmerkingsboks110#10", "Off");
            //Empty Ends
            foreach (var item in ListProjectServices)
            {
                ServiceENT DataSingleService = ServiceMultiData.Where(x => x.Id == (Convert.ToInt32(item.ServiceId))).FirstOrDefault();
                if (DataSingleService.ServiceTypeId != 3)
                {
                    if (a == 1)
                    {
                        //string valuename = GetCheckBoxExportValue(af, "Avmerkingsboks10#1");
                        stamper.AcroFields.SetField("NedtrekkslisteRow1", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow1", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste23", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks10#1", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks810", "Ja");
                    }
                    else if (a == 2)
                    {
                        //string valuename = GetCheckBoxExportValue(af, "Avmerkingsboks1102");
                        stamper.AcroFields.SetField("Nedtrekk121", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow2", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste24", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1101", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks110#10", "Ja");
                    }
                    else if (a == 3)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow21", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow3", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste25", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1102", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks1102#10", "Ja");
                    }
                    else if (a == 4)
                    {
                        //stamper.AcroFields.SetField("NedtrekkslisteRow4", "kontroll");
                        stamper.AcroFields.SetField("NedtrekkslisteRow3", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow4", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste26", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1103", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8103", "Ja");
                    }
                    else if (a == 5)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow5", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow5", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste27", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1104", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8104", "Ja");
                    }
                    else if (a == 6)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow6", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow6", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste28", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1105", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8105", "Ja");
                    }
                    else if (a == 7)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow7", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow7", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste29", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1106", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8106", "Ja");
                    }
                    else if (a == 8)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow8", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow8", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste30", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1107", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8107", "Ja");
                    }
                    else if (a == 9)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow9", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow9", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste31", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1108", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8108", "Ja");
                    }
                    else if (a == 10)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow10", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow10", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste32", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks1109", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks8109", "Ja");
                    }
                    else if (a == 11)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow109", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow109", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste3131", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks11080", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks81081", "Ja");
                    }
                    else if (a == 12)
                    {
                        stamper.AcroFields.SetField("NedtrekkslisteRow1110", "kontroll");
                        stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow1010", item.Service.Name);
                        stamper.AcroFields.SetField("Nedtrekksliste3232", DataSingleService.ServiceTypeId.ToString());
                        stamper.AcroFields.SetField("Avmerkingsboks11092", "Ja");
                        stamper.AcroFields.SetField("Avmerkingsboks81092", "Ja");
                    }
                    #region commented
                    //stamper.AcroFields.SetField("NedtrekkslisteRow1", "kontroll");
                    //stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow1", item.Service.Name);
                    ////stamper.AcroFields.SetField("Responsible_ActionClass_" + a, item.Quantity.ToString());
                    //stamper.AcroFields.SetField("Nedtrekksliste23", item.Service.ServiceTypeID.ToString());
                    ////stamper.AcroFields.SetField("Responsible_FramePermit_" + a, "X");
                    ////stamper.AcroFields.SetField("Responsible_BuildingPermit_" + a, "X");

                    //stamper.AcroFields.SetField("Avmerkingsboks10#1", "47");
                    //stamper.AcroFields.SetField("Avmerkingsboks810", "78");
                    ////var aaa = stamper.AcroFields.Fields["Avmerkingsboks10#1"];

                    //stamper.AcroFields.SetField("Responsible_Function_" + a, "kontroll");
                    //stamper.AcroFields.SetField("Responsible_Description_" + a, item.Service.Name);
                    ////stamper.AcroFields.SetField("Responsible_ActionClass_" + a, item.Quantity.ToString());
                    //stamper.AcroFields.SetField("Responsible_ActionClass_" + a, item.Service.ServiceTypeID.ToString());
                    //stamper.AcroFields.SetField("Responsible_FramePermit_" + a, "X");
                    //stamper.AcroFields.SetField("Responsible_BuildingPermit_" + a, "X");
                    //stamper.AcroFields.SetField("Responsible_TempUsePermit_" + a, "X");
                    //stamper.AcroFields.SetField("Responsible_Complete_" + a, "X");
                    #endregion
                    a++;
                }
            }
            if (a == 1 && ListProjectServices.Count == 0)
            {
                stamper.AcroFields.SetField("NedtrekkslisteRow1", "-");
                stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow1", "");
                stamper.AcroFields.SetField("Nedtrekksliste23", "-");
                stamper.AcroFields.SetField("Avmerkingsboks10#1", "Off");
                stamper.AcroFields.SetField("Avmerkingsboks810", "Off");

                a++;
            }
            if (a == 2 && ListProjectServices.Count == 1)
            {
                stamper.AcroFields.SetField("Nedtrekk121", "-");
                stamper.AcroFields.SetField("Beskrivelse av ansvarsområdetRow2", "");
                stamper.AcroFields.SetField("Nedtrekksliste24", "-");
                stamper.AcroFields.SetField("Avmerkingsboks1101", "Off");
                stamper.AcroFields.SetField("Avmerkingsboks110#10", "Off");
            }

            ////Last Table

            //Changings done after clients feedback/////////////////////////////////////////////////////////
            //stamper.AcroFields.SetField("ResponsibleApp_Company", model.Contact.Name);
            //stamper.AcroFields.SetField("Date", DateTime.Now.ToString("dd.MM.yy"));
            //stamper.AcroFields.SetField("ResponsibleApp_Person_Cap", model.Customer.Name);
            //stamper.AcroFields.SetField("ResponsibleApp_Company", "");

            stamper.AcroFields.SetField("Tekst98", DateTime.Now.ToString("dd.MM.yy"));
            stamper.AcroFields.SetField("Gjentas med blokkbokstaver", setings.ownerName);



            var pdfContentByte = stamper.GetOverContent(1);

            //var url = @"http://nbk.d.com.pk/Resources/global/images/RuneSignature.jpg";
            var url = contentRootPath + "/Images/RuneSignature.jpg";

            //var uri = new Uri(url);
            //var path = Path.GetFileName(uri.AbsolutePath);


            //HttpWebRequest imageRequest = (HttpWebRequest)WebRequest.Create(url);

            //  below lines will be commented for azure

            //WebResponse imageResponse = imageRequest.GetResponse();
            //Stream inputImageStream = imageResponse.GetResponseStream();
            //////Stream inputImageStream = new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.Read);
            //iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(inputImageStream);
            //image.SetAbsolutePosition(150, 60);
            //image.ScalePercent(40f);
            //pdfContentByte.AddImage(image);
            #region commented
            ////Add signature image code STARTS
            //AcroFields.FieldPosition fieldPosition = stamper.AcroFields.GetFieldPositions("Gjentas med blokkbokstaver")[0];
            //PushbuttonField imageField = new PushbuttonField(stamper.Writer, fieldPosition.position, "Gjentas med blokkbokstaver");
            //imageField.Layout = PushbuttonField.LAYOUT_ICON_ONLY;
            //string imageFile = "http://nbk.d.com.pk/Resources/global/images/RuneSignature.jpg";
            //imageField.Image = iTextSharp.text.Image.GetInstance(imageFile);

            //imageField.ScaleIcon = PushbuttonField.SCALE_ICON_ALWAYS;
            //imageField.ProportionalIcon = false;
            //imageField.Options = BaseField.READ_ONLY;

            //stamper.AcroFields.RemoveField("Gjentas med blokkbokstaver");
            //stamper.AddAnnotation(imageField.Field, fieldPosition.page);
            ////Add signature image code ENDS

            ////stamper.AcroFields.ReplacePushbuttonField("Gjentas med blokkbokstaver", imageField.Field);
            #endregion
            stamper.Close();
            reader.Close();
        }