public static string getDist(UnogViewModel model)
{
gdgs1Entities db1 = new gdgs1Entities();
var item = db1.distrbutions.FirstOrDefault(p => p.ID.ToString() == model.dist);
string dist = item.Name.ToString();
return(dist);
}
public static string getCount(string iso, UnogViewModel model)
{
gdgs1Entities db1 = new gdgs1Entities();
var count = db1.countries.Where(x => x.languages_ID == model.lang_ID && x.ISO == iso).FirstOrDefault();
string Cname = count.Short_Name.ToString();
return(Cname);
}
public ActionResult FindTemplate(UnogViewModel model)
{
gdgs1Entities db1 = new gdgs1Entities();
UnogViewModel Newmodel = new UnogViewModel();
//Filtering possible Matches according to Symbole structure
string sym = model.Sym.ToString();
int Count = sym.Split('/').Count();
int i = 0;
int index = 0;
int numofmatches = 0;
//string Matches ="";
List <UnogViewModel> List = new List <UnogViewModel>();
List = db1.final_temp.Where(p => p.Count == Count).Select(Item => new UnogViewModel
{
tempname = Item.Name,
structure = Item.Symbole,
regx = Item.Reg,
}).ToList();
foreach (var l in List)
{
var pattern = new Regex(@l.regx.ToString());
if (pattern.IsMatch(sym.ToString()))
{
index = i;
numofmatches = numofmatches + 1;
}
i++;
}
if (numofmatches > 1)
{
string s = List[index].structure.ToString();
model.structure = s;
return(RedirectToAction("Verify", model));
}
if (numofmatches == 1)
{
string x = List[index].tempname.ToString();
string xx = List[index].structure.ToString();
model.structure = xx;
model.tempname = x;
var lang = db1.languages.Where(p => p.ID == model.lang_ID).FirstOrDefault();
string name = lang.Lang_Name.ToString().Substring(0, 1);
model.tempname = model.tempname + name;
return(RedirectToAction("Generate", model));
}
else
{
return(RedirectToAction("WrongTemplate"));
}
}
public static bool categoryname(UnogViewModel model)
{
string str = model.tempname.ToString();
//str = str.Substring(0, str.Length-1);
gdgs1Entities db1 = new gdgs1Entities();
var item = db1.final_temp.FirstOrDefault(p => p.Name == str);
int x = item.categories_ID;
var item1 = db1.categories.FirstOrDefault(p => p.ID == x);
string cat = item1.Name.ToString();
if (cat == "Country Report" || cat == "Country Report -Optional Procedure")
{
return(false);
}
else
{
return(true);
}
}
public static string SessionDate(string sdate, string edate, UnogViewModel model)
{
string final = "";
string[] s = sdate.Split(' ');
string[] e = edate.Split(' ');
string lang = Olanguage(model.lang_ID);
switch (lang)
{
case "Spanish":
{
if (s[2] == e[2])
{
final = s[0] + " a " + e[0] + " de " + e[2] + " de " + e[4];
}
if (s[2] != e[2])
{
final = s[0] + " de " + s[2] + " a " + e[0] + " de " + e[2] + " " + e[4];
}
//return final;
break;
}
default:
{
if (s[1] == e[1])
{
final = s[0] + "-" + e[0] + " " + e[1] + " " + e[2];
}
if (s[1] != e[1])
{
final = s[0] + " " + s[1] + "-" + e[0] + " " + e[1] + " " + e[2];
}
//return final;
break;
}
}
return(final);
}
public static string formatdate(string date, UnogViewModel model)
{
gdgs1Entities db1 = new gdgs1Entities();
var item = db1.languages.FirstOrDefault(p => p.ID == model.lang_ID);
string lang = item.Lang_Name.ToString();
string final = "day month year";
if (lang == "French")
{
string[] d = date.Split('/');
int[] convert = Array.ConvertAll <string, int>(d, int.Parse);
var frenchCultureInfo = CultureInfo.CreateSpecificCulture("fr-fr");
string month = frenchCultureInfo.DateTimeFormat.GetMonthName(convert[0]);
if (d[1] == "1")
{
d[1] = d[1] + "\u1D49" + "\u02B3";
}
final = d[1] + " " + month + " " + d[2];
}
else if (lang == "Spanish")
{
string[] d = date.Split('/');
int[] convert = Array.ConvertAll <string, int>(d, int.Parse);
var frenchCultureInfo = CultureInfo.CreateSpecificCulture("es-es");
string month = frenchCultureInfo.DateTimeFormat.GetMonthName(convert[0]);
final = d[1] + " de " + month + " de " + d[2];
}
else
{
string[] d = date.Split('/');
int[] convert = Array.ConvertAll <string, int>(d, int.Parse);
var frenchCultureInfo = CultureInfo.CreateSpecificCulture("en-US");
string month = frenchCultureInfo.DateTimeFormat.GetMonthName(convert[0]);
final = d[1] + " " + month + " " + d[2];
}
return(final);
}
public ActionResult Generate(UnogViewModel model)
{
//get temp name from reg expression plus lang plus symb
string fname = model.tempname.ToString();
g_assembly = Assembly.GetExecutingAssembly();
//string source = Server.MapPath(Path.Combine("/", "IN/" + fname + ".docx"));
//string Dest = Server.MapPath(Path.Combine("/", "OUT/" + fname + ".docx"));
string source = Server.MapPath(Path.Combine("/", "GDGS/IN/" + fname + ".docx"));
string Dest = Server.MapPath(Path.Combine("/", "GDGS/OUT/" + fname + ".docx"));
string tempname = fname.Remove(fname.Length - 1);
model.tempname = tempname;
g_document = DocX.Load(source);
g_document = CreateDocA(DocX.Load(source), model);
g_document.SaveAs(Dest);
return(RedirectToAction("download", "Unog", new { name = fname }));
}
public ActionResult VerifyF(UnogViewModel model)
{
string fname = model.tempname.ToString();
var lang = db.languages.Where(p => p.ID == model.lang_ID).FirstOrDefault();
string name = lang.Lang_Name.ToString().Substring(0, 1);
fname = fname + name;
g_assembly = Assembly.GetExecutingAssembly();
string source = Server.MapPath(Path.Combine("/", "GDGS/IN/" + fname + ".docx"));
string Dest = Server.MapPath(Path.Combine("/", "GDGS/OUT/" + fname + ".docx"));
//string source = Server.MapPath(Path.Combine("/", "IN/" + fname + ".docx"));
//string Dest = Server.MapPath(Path.Combine("/", "OUT/" + fname + ".docx"));
g_document = DocX.Load(source);
g_document = CreateDocA(DocX.Load(source), model);
g_document.SaveAs(Dest);
return(RedirectToAction("download", "Unog", new { name = fname }));
}
public ActionResult Verify(UnogViewModel model)
{
return(View(model));
}
public static string SpanishNum(UnogViewModel model, string prep, string iso)
{
string num1 = prep;
string[] str = num1.Split('-');
string final = "";
string Country1 = getCountwithSrticle(iso, model);
var spanishCultureInfo = CultureInfo.CreateSpecificCulture("es-es");
if (str.Length == 1)
{
int num = Convert.ToInt32(prep);
if (num <= 10)
{
final = num.ToOrdinalWords(spanishCultureInfo) + " informe periódico " + Country1;
if (final == "primer")
{
final = "informe inicial " + Country1;
}
}
else
{
string chr = num1.Last().ToString();
if (chr == "1" || chr == "3")
{
final = num1 + "\u1D49" + "\u02B3" + " informe periódico " + Country1;
}
else
{
final = num1 + "\u1D52" + " informe periódico " + Country1;
}
}
}
if (str.Length > 1)
{
int x = Convert.ToInt32(str[0]);
int y = Convert.ToInt32(str[1]);
if (x <= 10 & y <= 10)
{
string str1 = x.ToOrdinalWords(spanishCultureInfo);
string str2 = y.ToOrdinalWords(spanishCultureInfo);
if (x == y - 1)
{
final = "informes periódicos " + str1 + " y " + str2 + " combinados " + Country1;
if (str1 == "primer")
{
final = "informes periódicos inicial y " + str2 + " combinados " + Country1;
}
}
else
{
final = "informes periódicos " + str1 + " a " + str2 + " combinados " + Country1;
if (str1 == "primer")
{
final = "informes periódicos inicial a " + str2 + " combinados " + Country1;
}
}
}
if (x <= 10 & y > 10)
{
string chr = str[0].Last().ToString();
string final1 = "";
string final2 = "";
final1 = str[0] + "\u1D52";
final2 = str[1] + "\u1D52";
if (x == y - 1)
{
final = "informes periódicos " + final1 + " y " + final2 + " combinados " + Country1;
}
else
{
final = "informes periódicos " + final1 + " a " + final2 + " combinados " + Country1;
}
}
}
return(final);
}
public static string Reportnumber(UnogViewModel model, string prep, int langg, string iso)
{
gdgs1Entities db1 = new gdgs1Entities();
var item = db1.languages.Where(p => p.ID == langg).FirstOrDefault();
string lang = item.Lang_Name.ToString();
string final = "";
string country = getCount(iso, model);
string Country1 = getCountwithSrticle(iso, model);
bool cat = false;
cat = categoryname(model);
if (cat == true)
{
switch (lang)
{
case "English":
{
string cc = prep;
string[] com = cc.Split('-');
//case single number
if (com.Length == 1)
{
var engCultureInfo = CultureInfo.CreateSpecificCulture("en-US");
int x = Convert.ToInt32(prep);
final = x.ToOrdinalWords(engCultureInfo);
if (final == "first")
{
final = "initial report of " + country;
}
else
{
final = final + " periodic report of " + country;
}
}
//case combined number
if (com.Length > 1)
{
var engCultureInfo = CultureInfo.CreateSpecificCulture("en-US");
int x = Convert.ToInt32(com[0]);
int y = Convert.ToInt32(com[1]);
string Fprep1 = x.ToOrdinalWords(engCultureInfo);
string Fprep2 = y.ToOrdinalWords(engCultureInfo);
//case 4 and 5 or 5 and 6
if (x == y - 1)
{
if (Fprep1 == "first")
{
Fprep1 = "initial ";
final = Fprep1 + "and " + Fprep2 + " combined reports of " + country;
}
else
{
final = Fprep1 + " and " + Fprep2 + " combined reports of " + country;
}
}
//case 1 - 5 or 3-10
if (x != y - 1)
{
if (Fprep1 == "first")
{
Fprep1 = "initial ";
final = Fprep1 + " to " + Fprep2 + " combined reports of " + country;
}
else
{
final = Fprep1 + " to " + Fprep2 + " combined reports of" + country;
}
}
}
break;
}
case "French":
{
string cc = prep;
string[] com = cc.Split('-');
var frenchCultureInfo = CultureInfo.CreateSpecificCulture("fr-fr");
//case single number
if (com.Length == 1)
{
int x = Convert.ToInt32(prep);
final = x.ToOrdinalWords(frenchCultureInfo);
if (final == "premier")
{
final = "rapport initial " + Country1;
}
else
{
final = final + " rapport périodique " + Country1;
}
}
//case combined number
if (com.Length > 1)
{
int x = Convert.ToInt32(com[0]);
int y = Convert.ToInt32(com[1]);
string Fprep1 = x.ToOrdinalWords(frenchCultureInfo);
string Fprep2 = y.ToOrdinalWords(frenchCultureInfo);
//case 4 and 5 or 5 and 6
if (Fprep1 == "premier")
{
Fprep1 = "rapport initial";
final = "rapport " + Country1 + " valant " + Fprep1 + " à " + Fprep2 + " rapports périodiques";
}
else
{
final = "rapport " + Country1 + " valant " + Fprep1 + " à " + Fprep2 + " rapports périodiques";
}
}
break;
}
case "Spanish":
{
final = SpanishNum(model, prep, iso);
break;
}
}
}
if (cat == false)
{
switch (lang)
{
case "English":
{
string cc = prep;
string[] com = cc.Split('-');
//case single number
if (com.Length == 1)
{
var engCultureInfo = CultureInfo.CreateSpecificCulture("en-US");
int x = Convert.ToInt32(prep);
final = x.ToOrdinalWords(engCultureInfo);
final = final.Substring(0, 1).ToUpperInvariant() + final.Substring(1);
if (final == "First")
{
final = "Initial report ";
}
else
{
final = final + " periodic report ";
}
}
//case combined number
if (com.Length > 1)
{
int x = Convert.ToInt32(com[0]);
int y = Convert.ToInt32(com[1]);
string Fprep1 = x.ToOrdinalWords();
string Fprep2 = y.ToOrdinalWords();
//case 4 and 5 or 5 and 6
if (x == y - 1)
{
if (Fprep1 == "first")
{
Fprep1 = "Initial ";
final = Fprep1 + "and " + Fprep2 + " combined reports ";
}
else
{
Fprep1 = Fprep1 + " and " + Fprep2 + " combined reports ";
}
}
//case 1 - 5 or 3-10
if (x != y - 1)
{
if (Fprep1 == "first")
{
Fprep1 = "Initial ";
final = Fprep1 + "- " + Fprep2 + " combined reports";
}
else
{
Fprep1 = Fprep1 + " - " + Fprep2 + " combined reports ";
}
}
}
break;
}
case "French":
{
string cc = prep;
string[] com = cc.Split('-');
var frenchCultureInfo = CultureInfo.CreateSpecificCulture("fr-fr");
//case single number
if (com.Length == 1)
{
int x = Convert.ToInt32(prep);
final = x.ToOrdinalWords(frenchCultureInfo);
final = final.Substring(0, 1).ToUpper() + final.Substring(1);
if (final == "Premier")
{
final = "Rapport initiaux ";
}
else
{
final = final + " rapport périodique ";
}
}
//case combined number
if (com.Length > 1)
{
int x = Convert.ToInt32(com[0]);
int y = Convert.ToInt32(com[1]);
string Fprep1 = x.ToOrdinalWords(frenchCultureInfo);
string Fprep2 = y.ToOrdinalWords(frenchCultureInfo);
//case 4 and 5 or 5 and 6
if (Fprep1 == "premier")
{
Fprep1 = "initial ";
final = "Rapport valant " + Fprep1 + " à " + Fprep2 + " rapports périodiques";
}
else
{
final = "Rapport valant " + Fprep1 + " à " + Fprep2 + " rapports périodiques";
}
}
break;
}
case "Spanish":
{
final = SpanishNum1(model, prep, iso);
break;
}
}
}
return(final);
}
public static DocX CreateDocA(DocX template, UnogViewModel model)
{
string sym = model.Sym.ToString();
string[] SymStr = sym.Split('/');
string[] sym1 = SymStr.Skip(1).ToArray();
string Fsym = String.Join("/", sym1);
int reppos = 0;
int repposcom = 0;
int countpos = 0;
//Create Date for Header
string Fdate = model.date.ToString();
string[] d = Fdate.Split(' ');
Fdate = d[0];
Fdate = formatdate(Fdate, model);
//Create Distrbution for Header
string Fdist = getDist(model);
//document Language "Section"
string Ftlang = "";
Ftlang = Tlanguage(model.lang_ID);
//ORiginal Language
string Folang = "";
Folang = Olanguage1(model.Olang_ID);
string FAuthor = "";
//Typist
if (!String.IsNullOrEmpty(model.Author))
{
FAuthor = model.Author.ToString();
}
//Agenda Title
string Fatitle = "";
if (!String.IsNullOrEmpty(model.AgendaItem))
{
Fatitle = model.AgendaItem.ToString();
}
//Session Title
string Fstitle = "";
if (!String.IsNullOrEmpty(model.STitle))
{
Fstitle = model.STitle.ToString();
}
//Session Dates
string Fsdate = "";
if (model.Sdate != null & model.Edate != null)
{
string sdate = model.Sdate.ToString();
string[] sd = sdate.Split(' ');
sdate = sd[0];
sdate = formatdate(sdate, model);
string edate = model.Edate.ToString();
string[] ed = edate.Split(' ');
edate = ed[0];
edate = formatdate(edate, model);
Fsdate = SessionDate(sdate, edate, model);
}
//Agenda Number
string Fanum = "";
if (!String.IsNullOrEmpty(model.AgendaNum))
{
Fanum = model.AgendaNum.ToString();
}
//Session Numer
string Fsnum = "";
if (!String.IsNullOrEmpty(model.SNum))
{
Fsnum = Sessionnum(model);
}
///
//Report num and count
string structure = model.structure.ToString();
string[] str = structure.Split('/');
for (int i = 0; i < str.Length; i++)
{
if (str[i] == "#")
{
reppos = i;
}
if (str[i] == "ISO")
{
countpos = i;
}
if (str[i] == "R.#")
{
repposcom = i;
}
}
string Fprep = "";
if (reppos != 0 && countpos != 0)
{
Fprep = Reportnumber(model, SymStr[reppos], model.lang_ID, SymStr[countpos]);
}
if (repposcom != 0 && countpos != 0)
{
string x = SymStr[repposcom];
int start = x.IndexOf('.');
string prep = x.Substring(start, x.Count() - 1);
Fprep = Reportnumber(model, prep, model.lang_ID, SymStr[countpos]);
}
string fCount = "";
if (countpos != 0)
{
fCount = getCount(SymStr[countpos], model);
}
//QR code and Bar code
string lang = getlanguageQR(model.lang_ID);
string url = "http://undocs.org/m2/QRCode.ashx?DS=" + Fsym + "&Size=2&Lang=" + lang;
using (var client = new WebClient())
{
//var content = client.DownloadData("https://api.qrserver.com/v1/create-qr-code/?size=66x66&data=http://undocs.org/fr/A/HRC/70");
//var content = client.DownloadData("http://undocs.org/m2/QRCode.ashx?DS=A/HRC/70&Size=2&Lang=F");
var content = client.DownloadData(url);
using (var str1 = new MemoryStream(content))
{
Image image = template.AddImage(str1);
Picture p = image.CreatePicture();
Footer f = template.Footers.first;
Table t = f.Tables[0];
//t.Rows[0].Cells[1].Paragraphs.First().AppendPicture(pR);
t.Rows[0].Cells[1].Paragraphs.First().AppendPicture(p);
}
}
//create barcode
string Fbar = "";
Fbar = model.Gdoc.ToString();
Fbar = "*" + Fbar + "*";
//creat gdoc
string gdoc = model.Gdoc.ToString();
gdoc = gdoc.Insert(2, "-");
//creat gdoc footer
string Fgdocf = gdoc;
DateTime xxx = DateTime.Now;
template.AddCustomProperty(new CustomProperty("sym1", Fsym));
template.AddCustomProperty(new CustomProperty("symh", sym));
template.AddCustomProperty(new CustomProperty("dist", Fdist));
template.AddCustomProperty(new CustomProperty("date", Fdate));
template.AddCustomProperty(new CustomProperty("sdate", Fsdate));
template.AddCustomProperty(new CustomProperty("virs", ""));
template.AddCustomProperty(new CustomProperty("snum", Fsnum));
template.AddCustomProperty(new CustomProperty("anum", Fanum));
template.AddCustomProperty(new CustomProperty("count", fCount));
template.AddCustomProperty(new CustomProperty("gdoc", gdoc));
template.AddCustomProperty(new CustomProperty("gdocf", Fgdocf));
template.AddCustomProperty(new CustomProperty("tlang", Ftlang));
template.AddCustomProperty(new CustomProperty("atitle", Fatitle));
template.AddCustomProperty(new CustomProperty("stitle", Fstitle));
template.AddCustomProperty(new CustomProperty("prep", Fprep));
template.AddCustomProperty(new CustomProperty("olang", Folang));
template.AddCustomProperty(new CustomProperty("Author", FAuthor));
template.AddCustomProperty(new CustomProperty("bar", Fbar));
template.AddCustomProperty(new CustomProperty("Date-Generated", xxx));
// template.AddCoreProperty("dc:title", sym);
return(template);
}
public static string Sessionnum(UnogViewModel model)
{
string lang = Olanguage(model.lang_ID);
string final = "";
switch (lang)
{
case "English":
{
int num = Convert.ToInt32(model.SNum.ToString());
if (num <= 99)
{
final = num.ToOrdinalWords();
}
else
{
final = model.SNum.ToString() + "th";
}
break;
}
case "French":
{
var frenchCultureInfo = CultureInfo.CreateSpecificCulture("fr-fr");
int num = Convert.ToInt32(model.SNum.ToString());
if (num <= 99)
{
final = num.ToOrdinalWords(frenchCultureInfo);
}
else
{
final = model.SNum.ToString() + "\u1D49";
}
break;
}
case "Spanish":
{
var spanishCultureInfo = CultureInfo.CreateSpecificCulture("es-es");
int num = Convert.ToInt32(model.SNum.ToString());
if (num <= 10)
{
final = num.ToOrdinalWords(spanishCultureInfo);
}
else
{
final = model.SNum.ToString();
string chr = final.Last().ToString();
if (chr == "1" || chr == "3")
{
final = final + "\u1D49" + "\u02B3";
}
else
{
final = final + "\u1D52";
}
}
break;
}
}
final = char.ToUpper(final[0]) + final.Substring(1);
return(final);
}
