public Boolean sendIntervention(Company cmp, String datPrijave, String VriPrijave, String Prio, String slaDatum,
String slaVrijeme, String Filijala, String CCN, String CID, long idNumber,
String drive, String Prijavio, String NazivUredaja, String Opis, Boolean storno, String grad, String adresa, String telefon, Tickets frm)
{
///////////////// LogMe ////////////////////////
String function = this.GetType().FullName + " - " + System.Reflection.MethodBase.GetCurrentMethod().Name;
String usedQC = "Dodavanje TID";
String data = "";
String Result = "";
LogWriter lw = new LogWriter();
////////////////////////////////////////////////
///
String posaljiPoruku;
String naslov;
String GoogleS;
Boolean done = false;
GoogleS = adresa + "+" + grad;
GoogleS = GoogleS.Replace(".", "+");
GoogleS = GoogleS.Replace(",", "+");
GoogleS = GoogleS.Replace(" ", "+");
if (adresa.Equals(""))
{
adresa = "Unknown";
}
if (grad.Equals(""))
{
grad = "Unknown";
}
if (telefon.Equals(""))
{
telefon = "Unknown";
}
if (storno)
{
naslov = "STORNO" + " CUST_" + cmp.Code + "_ID_" + idNumber + "_CCN_" + CCN + "_CID_" + CID + "_" + "F" + Filijala;
posaljiPoruku = "<p style=''font-family:calibri;font-size:15''>" +
"<u><b>STORNO</b></u>" + "</p>" + "<br>" +
"<p style=''font-family:calibri;font-size:12''>" +
"ID: " + idNumber + "<br>" +
"Klijent: " + cmp.Name + "<br>" +
"Filijala: " + Filijala + "<br>" +
"CCN: " + CCN + "<br>" +
"CID: " + CID + "<br>" + "<br>" + "<br>" + "</p>" +
"<p style=''font-family:calibri;font-size:12''>"
+ "--------------------------------------" + "<br>" +
setAutoFooter();
QueryCommands qc = new QueryCommands();
List <String> arr = new List <string>();
arr = qc.SentToUsers();
String sendList = "";
for (int i = 0; i < arr.Count; i++)
{
sendList = sendList + arr[i++] + ";";
}
sendList = sendList.Trim();
if (qc.SendTIDStorno(WorkingUser.Username, WorkingUser.Password, idNumber, naslov, posaljiPoruku, sendList))
{
Result = "Sent";
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " STORNO sent at " + DateTime.Now);
lw.LogMe(function, usedQC, data, Result);
done = true;
}
else
{
Result = "Not sent";
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " STORNO NOT sent at " + DateTime.Now);
lw.LogMe(function, usedQC, data, Result);
done = false;
}
return(done);
}
else
{
naslov = "CUST_" + cmp.Code + "_ID_" + idNumber + "_CCN_" + CCN + "_CID_" + CID + "_" + "F" + Filijala;
QueryCommands qc = new QueryCommands();
try
{
if (qc.AddTID(WorkingUser.Username, WorkingUser.Password, idNumber, cmp, long.Parse(Prio), Filijala, CCN, CID, datPrijave, VriPrijave, slaDatum, slaVrijeme, long.Parse(drive), NazivUredaja, Opis, Prijavio))
{
data = WorkingUser.Username + ", " + WorkingUser.Password + ", " + idNumber + ", " + cmp + ", " + long.Parse(Prio) + ", " + Filijala + ", " + CCN + ", " + CID + ", " + datPrijave +
", " + VriPrijave + ", " + slaDatum + ", " + slaVrijeme + ", " + long.Parse(drive) + ", " + NazivUredaja + ", " + Opis + ", " + Prijavio;
Result = "Added";
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " - " + CCN + " added to DB at " + DateTime.Now);
lw.LogMe(function, usedQC, data, Result);
}
else
{
data = WorkingUser.Username + ", " + WorkingUser.Password + ", " + idNumber + ", " + cmp + ", " + long.Parse(Prio) + ", " + Filijala + ", " + CCN + ", " + CID + ", " + datPrijave +
", " + VriPrijave + ", " + slaDatum + ", " + slaVrijeme + ", " + long.Parse(drive) + ", " + NazivUredaja + ", " + Opis + ", " + Prijavio;
Result = "Not added";
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " - " + CCN + " NOT added to DB at " + DateTime.Now);
lw.LogMe(function, usedQC, data, Result);
}
}
catch (Exception ex)
{
done = false;
new LogWriter(ex);
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " - " + CCN + " NOT added to DB,");
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "ERROR msg: " + ex.Message + " at " + DateTime.Now);
return(done);
}
List <String> arr = new List <string>();
arr = qc.SentToUsers();
String sendList = "";
for (int i = 0; i < arr.Count; i++)
{
sendList = arr[i];
i++;
posaljiPoruku = "<p style=''font-family:calibri;font-size:15''>" +
"<b>ID:</b> " + idNumber + "<br>" + "<b>Klijent:</b> " + cmp.Name + "<br>" + "<br>" +
"<b>Datum prijave:</b> " + datPrijave + "<br>" + "<b>Vrijeme prijave:</b> " + VriPrijave + "<br>" +
"<b>Datum SLA:</b> " + slaDatum + "<br>" + "<b>Vrijeme SLA:</b> " + slaVrijeme + "<br>" + "<br>" +
"<b>Prioritet:</b> " + Prio + "<br>" +
"<b>Filijala:</b> " + Filijala + "<br>" +
"<b>Grad:</b> " + grad + "<br>" +
"<b>Adresa:</b> " + "<A href=https://www.google.com/maps/search/?api=1&query=" + GoogleS + ">" + adresa + "</A >" + "<br>" +
"<b>Telefon:</b> " + telefon + "<br>" + "<br>" +
"<b>CCN:</b> " + CCN + "<br>" +
"<b>CID:</b> " + CID + "<br>" +
"<b>Drive:</b> " + drive + "<br>" + "<br>" +
"<b>Prijavio:</b> " + Prijavio + "<br>" +
"<b>Uredaj:</b> " + NazivUredaja + "<br>" +
"<b>Opis:</b> " + Opis + "<br>" + "<br>" + "<br>" + "</p>" +
"<br>TID action: " + "<A href=http://" + Properties.Settings.Default.APIweb + ":9090/takenWF?field1=" + idNumber + "&field2=" + arr[i] + ">Take me</A >" + "<br>" + "<br>" +
"<br>TID action: " + "<A href=http://" + Properties.Settings.Default.APIweb + ":9090/driveWF?field1=" + idNumber + "&field2=" + arr[i] + ">Start driving</A >" + "<br>" + "<br>" +
"<br>TID action: " + "<A href=http://" + Properties.Settings.Default.APIweb + ":9090/startWF?field1=" + idNumber + "&field2=" + arr[i] + ">Start working</A >" + "<br>" + "<br>" +
"<br>TID action: " + "<A href=http://" + Properties.Settings.Default.APIweb + ":9090/endWF?field1=" + idNumber + "&field2=" + arr[i] + ">End working</A >" + "<br>" + "<br>" +
"<p style=''font-family:calibri;font-size:12''>" +
"--------------------------------------" + "<br>" +
setAutoFooter();
try
{
if (qc.SendTID(WorkingUser.Username, WorkingUser.Password, idNumber, naslov, posaljiPoruku, sendList))
{
data = posaljiPoruku;
Result = "Sent";
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " - " + CCN + " sent to user " + arr[i - 1] + " at " + DateTime.Now);
lw.LogMe(function, usedQC, data, Result);
done = true;
}
else
{
data = posaljiPoruku;
Result = "Not sent";
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " - " + CCN + " NOT sent to user " + arr[i - 1] + " at " + DateTime.Now);
lw.LogMe(function, usedQC, data, Result);
done = false;
}
}
catch (Exception ex1)
{
done = false;
new LogWriter(ex1);
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "TID " + idNumber + " - " + CCN + " NOT sent,");
frm.AppendTextBox(Environment.NewLine + "- " + DateTime.Now.ToString("dd.MM.yy. HH:mm - ") + "ERROR msg: " + ex1.Message + " at " + DateTime.Now);
break;
}
}
}
return(done);
}