public async Task <IHttpActionResult> GenPdfKarticePd(PdfParamsPosebniDio obj)
{
try
{
var zgrada = await _db.Zgrade.FirstOrDefaultAsync(p => p.Id == obj.master.ZgradaId);
#region pdfCreation
var doc = new Document(PageSize.A4, 30, 30, 25, 25);
//var physicalPath = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/download"), "PosebniDio-1223.pdf");
//PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(physicalPath, FileMode.Create));
var output = new MemoryStream();
var writer = PdfWriter.GetInstance(doc, output);
doc.Open();
var titleFont = FontFactory.GetFont("Arial", 16, Font.BOLD);
var subTitleFont = FontFactory.GetFont("Arial", 12, Font.BOLD);
var boldTableFont = FontFactory.GetFont("Arial", 10, Font.BOLD);
var cellTableFont = FontFactory.GetFont("Arial", 10, Font.NORMAL);
//var endingMessageFont = FontFactory.GetFont("Arial", 10, Font.ITALIC);
//var bodyFont = FontFactory.GetFont("Arial", 12, Font.NORMAL);
doc.Add(new Paragraph("Kartica posebnih dijelova", titleFont));
doc.Add(new Paragraph("Posebni dio: " + obj.master.Naziv, subTitleFont));
doc.Add(new Paragraph("Godina : " + obj.godina, subTitleFont));
doc.Add(new Paragraph("Zgrada : " + zgrada.Naziv + ", " + zgrada.Adresa + ", " + zgrada.Mjesto, subTitleFont));
doc.Add(new Paragraph(" "));
PdfPTable tbl = new PdfPTable(6);
tbl.HorizontalAlignment = 0;
tbl.WidthPercentage = 100;
//tbl.SpacingBefore = 10;
//tbl.SpacingAfter = 10;
tbl.DefaultCell.Border = 0;
//tbl.SetWidths(new int[] { 1, 3, 1, 1, 1, 1 });
BaseColor backColorGray = new BaseColor(252, 252, 252);
BaseColor backColorGrayUkupno = new BaseColor(245, 245, 245);
BaseColor borderColor = new BaseColor(230, 230, 230);
// rb
PdfPCell cell = new PdfPCell(new Phrase("Rb", boldTableFont));
//cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 150, 0);
cell.BorderColor = borderColor;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
tbl.AddCell(cell);
// Mjesec
cell = new PdfPCell(new Phrase("Mjesec", boldTableFont));
//cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 150, 0);
cell.BorderColor = borderColor;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Datum", boldTableFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Uplata", boldTableFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Zaduženje", boldTableFont));
cell.BorderColor = borderColor;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", boldTableFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("Dug/Pretplata", boldTableFont));
//cell.HorizontalAlignment = Element.ALIGN_RIGHT;
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
List <int> mjeseci = obj.mjeseci;
mjeseci.Sort();
foreach (var mj in mjeseci)
{
var rec = obj.tBodyList.FirstOrDefault(p => p.mjesec == mj);
cell = new PdfPCell(new Phrase(rec.rb.ToString() + ".", cellTableFont));
cell.BorderColor = borderColor;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
tbl.AddCell(cell);
// prihodi
//PdfPTable tblPrihodi = new PdfPTable(2);
//tblPrihodi.DefaultCell.Border = 0;
////tbl.DefaultCell.BackgroundColor = BaseColor.GRAY;
//foreach (var prihod in mjesec.prihodi)
//{
// tblPrihodi.AddCell(new Phrase(prihod.naziv, cellTableFont));
// tblPrihodi.AddCell(new Phrase(prihod.iznos.ToString(), cellTableFont));
//}
//tbl.AddCell(tblPrihodi);
cell = new PdfPCell(new Phrase(rec.mjesec.ToString(), cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.datum.ToString(), cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.zaduzenje.ToString(), cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase(mjesec.dugPretplata.ToString(), cellTableFont));
//cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
//cell.VerticalAlignment = Element.ALIGN_MIDDLE;
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
// BEGIN vlasnici
//cell = new PdfPCell(new Phrase("", cellTableFont));
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("Vlasnici", cellTableFont));
//cell.BackgroundColor = backColorGray;
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//var vlasnici = "";
//foreach (var v in rec.vlasnici)
//{
// vlasnici += v.imePrezime;
//}
//cell = new PdfPCell(new Phrase(vlasnici, cellTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGray;
//cell.Colspan = 4;
//tbl.AddCell(cell);
// END OF vlasnici
// BEGIN PosebiDijelovi
//cell = new PdfPCell(new Phrase("", cellTableFont));
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("Posebni dijelovi", cellTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGray;
//tbl.AddCell(cell);
//var pdChildren = "";
//foreach (var pd in mjesec.posDijelovi)
//{
// pdChildren += pd.naziv;
//}
//cell = new PdfPCell(new Phrase(pdChildren, cellTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGray;
//cell.Colspan = 4;
//tbl.AddCell(cell);
// END OF PosebiDijelovi
if (rec.displayTotal)
{
cell = new PdfPCell(new Phrase(" ", boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.Colspan = 2;
cell.FixedHeight = 30;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Ukupno", boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.FixedHeight = 30;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.ukupnoPrihodi.ToString(), boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.ukupnoZaduzenje.ToString(), boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.Colspan = 2;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.ukupno.ToString(), boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase(mjesec.ukupnoDugPretplata.ToString(), boldTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGrayUkupno;
//cell.VerticalAlignment = Element.ALIGN_MIDDLE;
//tbl.AddCell(cell);
// empty row
cell = new PdfPCell(new Phrase(" ", boldTableFont));
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("", boldTableFont));
cell.BorderColor = borderColor;
cell.Colspan = 5;
tbl.AddCell(cell);
}
}
//var tbl = new PdfPTable(6);
//tbl.HorizontalAlignment = 0;
//tbl.SpacingBefore = 10;
//tbl.SpacingAfter = 10;
//tbl.DefaultCell.Border = 0;
//tbl.SetWidths(new int[] { 1, 4 });
//PdfPCell cell = new PdfPCell();
//cell.Phrase = new Phrase("header", boldTableFont);
//cell.HorizontalAlignment = 0;
//cell.Colspan = 6;
//tbl.AddCell(cell);
//cell = new PdfPCell();
//cell.Phrase = new Phrase("Mjesec", boldTableFont);
////cell.Colspan = 2;
//cell.HorizontalAlignment = 0;
//tbl.AddCell(cell);
//cell = new PdfPCell();
//cell.Phrase = new Phrase("Iznos prihoda", boldTableFont);
////cell.Colspan = 2;
//cell.HorizontalAlignment = 0;
//tbl.AddCell(cell);
//cell = new PdfPCell();
//cell.Phrase = new Phrase("Početno stanje", boldTableFont);
//cell.HorizontalAlignment = 0;
//tbl.AddCell(cell);
//cell = new PdfPCell();
//cell.Phrase = new Phrase("Stanje iz prošlog mjeseca", boldTableFont);
//cell.HorizontalAlignment = 0;
//tbl.AddCell(cell);
//cell = new PdfPCell();
//cell.Phrase = new Phrase("Zaduženje", boldTableFont);
//cell.HorizontalAlignment = 0;
//tbl.AddCell(cell);
//cell = new PdfPCell();
//cell.Phrase = new Phrase("Dug/pretplata", boldTableFont);
//cell.HorizontalAlignment = 0;
//tbl.AddCell(cell);
doc.Add(tbl);
doc.Close();
writer.Close();
//System.Web.Hosting.HostingEnvironment.
#endregion
return(Ok("link"));
}
catch (Exception ex) { return(InternalServerError()); }
}
public async Task <ActionResult> genPdfKarticePd(PdfParamsPosebniDio obj)
{
try
{
var zgrada = await _db.Zgrade.FirstOrDefaultAsync(p => p.Id == obj.master.ZgradaId);
#region pdfCreation
var doc = new Document(PageSize.A4, 30, 30, 25, 25);
//var physicalPath = Path.Combine(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/download"), "PosebniDio-1223.pdf");
//PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(physicalPath, FileMode.Create));
var output = new MemoryStream();
var writer = PdfWriter.GetInstance(doc, output);
doc.Open();
var titleFont = FontFactory.GetFont("Arial", 16, Font.BOLD);
var subTitleFont = FontFactory.GetFont("Arial", 12, Font.BOLD);
var boldTableFont = FontFactory.GetFont("Arial", 10, Font.BOLD);
var cellTableFont = FontFactory.GetFont("Arial", 10, Font.NORMAL);
var boldTableHeaderFont = FontFactory.GetFont("Arial", 8, Font.BOLD);
//var endingMessageFont = FontFactory.GetFont("Arial", 10, Font.ITALIC);
//var bodyFont = FontFactory.GetFont("Arial", 12, Font.NORMAL);
doc.Add(new Paragraph("Kartica posebnih dijelova", titleFont));
doc.Add(new Paragraph("Posebni dio: " + obj.master.Naziv, subTitleFont));
doc.Add(new Paragraph("Godina : " + obj.godina, subTitleFont));
doc.Add(new Paragraph("Zgrada : " + zgrada.Naziv + ", " + zgrada.Adresa + ", " + zgrada.Mjesto, subTitleFont));
doc.Add(new Paragraph(" "));
PdfPTable tbl = new PdfPTable(6);
tbl.HorizontalAlignment = 0;
tbl.WidthPercentage = 100;
//tbl.SpacingBefore = 10;
//tbl.SpacingAfter = 10;
tbl.DefaultCell.Border = 0;
//tbl.SetWidths(new int[] { 1, 3, 1, 1, 1, 1 });
BaseColor backColorGray = new BaseColor(252, 252, 252);
BaseColor backColorGrayUkupno = new BaseColor(245, 245, 245);
BaseColor borderColor = new BaseColor(230, 230, 230);
// rb
PdfPCell cell = new PdfPCell(new Phrase("Rb", boldTableFont));
//cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 150, 0);
cell.BorderColor = borderColor;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
tbl.AddCell(cell);
// Mjesec
cell = new PdfPCell(new Phrase("Mjesec", boldTableFont));
//cell.BackgroundColor = new iTextSharp.text.BaseColor(0, 150, 0);
cell.BorderColor = borderColor;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Datum", boldTableFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Uplata", boldTableFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Zaduženje", boldTableFont));
cell.BorderColor = borderColor;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", boldTableFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("Dug/Pretplata", boldTableFont));
//cell.HorizontalAlignment = Element.ALIGN_RIGHT;
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
List <int> mjeseci = obj.mjeseci;
mjeseci.Sort();
foreach (var mj in mjeseci)
{
var recMjeseci = obj.tBodyList.Where(p => p.mjesec == mj);
foreach (var rec in recMjeseci)
{
cell = new PdfPCell(new Phrase(rec.rb.ToString() + ".", cellTableFont));
cell.BorderColor = borderColor;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.mjesec.ToString() + ".", cellTableFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.datum.ToString("dd.MM.yyyy."), cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.showUplata == true ? String.Format("{0:0.00}", rec.prihod) : " ", cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(rec.showZaduzenje ? String.Format("{0:0.00}", rec.zaduzenje) : " ", cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("", cellTableFont));
cell.HorizontalAlignment = 2; // 0 -left, 1 - center, 2 - right
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.BorderColor = borderColor;
tbl.AddCell(cell);
// BEGIN vlasnici
//cell = new PdfPCell(new Phrase("", cellTableFont));
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("Vlasnici", cellTableFont));
//cell.BackgroundColor = backColorGray;
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//var vlasnici = "";
//foreach (var v in rec.vlasnici)
//{
// vlasnici += v.imePrezime;
//}
//cell = new PdfPCell(new Phrase(vlasnici, cellTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGray;
//cell.Colspan = 4;
//tbl.AddCell(cell);
// END OF vlasnici
// BEGIN PosebiDijelovi
//cell = new PdfPCell(new Phrase("", cellTableFont));
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("Posebni dijelovi", cellTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGray;
//tbl.AddCell(cell);
//var pdChildren = "";
//foreach (var pd in mjesec.posDijelovi)
//{
// pdChildren += pd.naziv;
//}
//cell = new PdfPCell(new Phrase(pdChildren, cellTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGray;
//cell.Colspan = 4;
//tbl.AddCell(cell);
// END OF PosebiDijelovi
if (rec.displayTotal)
{
cell = new PdfPCell(new Phrase(" ", boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.Colspan = 2;
cell.FixedHeight = 30;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase("Ukupno", boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.FixedHeight = 30;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(String.Format("{0:0.00}", rec.ukupnoUplata), boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(String.Format("{0:0.00}", rec.ukupnoZaduzenje), boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
tbl.AddCell(cell);
cell = new PdfPCell(new Phrase(String.Format("{0:0.00}", rec.ukupno), boldTableFont));
cell.BorderColor = borderColor;
cell.BackgroundColor = backColorGrayUkupno;
cell.VerticalAlignment = Element.ALIGN_MIDDLE;
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase(mjesec.ukupnoDugPretplata.ToString(), boldTableFont));
//cell.BorderColor = borderColor;
//cell.BackgroundColor = backColorGrayUkupno;
//cell.VerticalAlignment = Element.ALIGN_MIDDLE;
//tbl.AddCell(cell);
// empty row
//cell = new PdfPCell(new Phrase(" ", boldTableFont));
//cell.BorderColor = borderColor;
//tbl.AddCell(cell);
//cell = new PdfPCell(new Phrase("", boldTableFont));
//cell.BorderColor = borderColor;
//cell.Colspan = 5;
//tbl.AddCell(cell);
}
}
}
doc.Add(tbl);
PdfPTable tblFooter = new PdfPTable(2);
tblFooter.HorizontalAlignment = 0;
tblFooter.WidthPercentage = 100;
tblFooter.DefaultCell.Border = 0;
tblFooter.DefaultCell.BorderColor = BaseColor.WHITE;
tblFooter.SetWidths(new int[] { 3, 1 });
PdfPCell cellFooterEmpty = new PdfPCell(new Phrase(" ", boldTableHeaderFont));
cellFooterEmpty.FixedHeight = 35;
cellFooterEmpty.Colspan = 2;
cellFooterEmpty.BorderColor = BaseColor.WHITE;
tblFooter.AddCell(cellFooterEmpty);
//PdfPCell cellFooter10 = new PdfPCell(new Phrase("", boldTableHeaderFont));
//cellFooter10.BorderColor = BaseColor.WHITE;
//tblFooter.AddCell(cellFooter10);
//PdfPCell cellFooter11 = new PdfPCell(new Phrase("", boldTableHeaderFont));
//cellFooter11.BorderColor = BaseColor.WHITE;
//cellFooter11.HorizontalAlignment = Element.ALIGN_RIGHT;
//var logo = iTextSharp.text.Image.GetInstance(Server.MapPath("~/Content/images/logo.png"));
//cellFooter11.AddElement(logo);
//tblFooter.AddCell(cellFooter11);
PdfPCell cellFooter20 = new PdfPCell(new Phrase("", boldTableHeaderFont));
cellFooter20.BorderColor = BaseColor.WHITE;
tblFooter.AddCell(cellFooter20);
PdfPCell cellFooter21 = new PdfPCell(new Phrase("__________________________", boldTableHeaderFont));
cellFooter21.BorderColor = BaseColor.WHITE;
cellFooter21.HorizontalAlignment = Element.ALIGN_CENTER;
tblFooter.AddCell(cellFooter21);
PdfPCell cellFooter30 = new PdfPCell(new Phrase("", boldTableHeaderFont));
cellFooter30.BorderColor = BaseColor.WHITE;
tblFooter.AddCell(cellFooter30);
PdfPCell cellFooter31 = new PdfPCell(new Phrase("Upravitelj", boldTableHeaderFont));
cellFooter31.BorderColor = BaseColor.WHITE;
cellFooter31.HorizontalAlignment = Element.ALIGN_CENTER;
tblFooter.AddCell(cellFooter31);
doc.Add(tblFooter);
doc.Close();
writer.Close();
output.Close();
SessionObj session = new SessionObj {
Pdf = output.ToArray(), Naziv = obj.master.Naziv + ".pdf"
};
Session["PdfPosebniDio"] = session;
doc.Close();
writer.Close();
//System.Web.Hosting.HostingEnvironment.
#endregion
return(new HttpStatusCodeResult(200));
//Response.StatusCode = 200;
//return Content("link");
}
catch (Exception ex) { return(new HttpStatusCodeResult(500)); }
}
