public IssueResult Find(long id)
{
Data.Entity.Issue entity = IssueDao.Find(id);
IssueResult result = IssueResultConverter.Convert(entity);
return(result);
}
public async Task <IssueResult> GetIssues(bool state, int pageNumber)
{
IssueResult response = new IssueResult();
HttpWebRequest webRequest = System.Net.WebRequest.Create(baseURL + "?state=" + (state ? "open" : "closed") + "&page=" + pageNumber) as HttpWebRequest;
if (webRequest != null)
{
webRequest.Method = "GET";
webRequest.UserAgent = "Anything";
webRequest.ServicePoint.Expect100Continue = false;
try
{
using (StreamReader responseReader = new StreamReader(webRequest.GetResponse().GetResponseStream()))
{
string reader = responseReader.ReadToEnd();
var jsonobj = JsonConvert.DeserializeObject(reader);
response.RecievedIssues = JsonConvert.DeserializeObject <List <IssueResponse.Issue> >(reader);
}
}
catch (Exception e)
{
response.ErrorMessage = e.Message;
}
}
return(response);
}
public IssueResult Convert(Data.Entity.Issue param)
{
IssueResult result = new IssueResult()
{
Code = param.Code,
Id = param.Id,
Description = param.Description,
Name = param.Name
};
return(result);
}
private IssueResult Check(IssueType issueType, List <string> correctSentences, List <TestSentence> testSentences)
{
// Evaluates all methods
var issueResult = new IssueResult();
issueResult.Levenshtein = CheckAccuracy(Global.SpellingMethod.Levenshtein, issueType, correctSentences, testSentences);
issueResult.NGram = CheckAccuracy(Global.SpellingMethod.NGram, issueType, correctSentences, testSentences);
issueResult.Htm = CheckAccuracy(Global.SpellingMethod.Htm, issueType, correctSentences, testSentences);
// Show tested sentences and results presented by each method
int colLabelsOffset = 40;
int colValuesOffset = 20;
Status.Update("Correct".PadRight(colValuesOffset) + "Mispelled".PadRight(colValuesOffset) + "Levenshtein".PadRight(colValuesOffset) + "N-Gram".PadRight(colValuesOffset) + "HTM".PadRight(colValuesOffset));
foreach (TestSentence testSentence in testSentences)
{
Status.Update(testSentence.Issue.SuggestedWords[0].PadRight(colValuesOffset) + testSentence.Issue.CurrentWord.PadRight(colValuesOffset) + testSentence.LevenshteinSugestion.PadRight(colValuesOffset) + testSentence.NGramSugestion.PadRight(colValuesOffset) + testSentence.HtmSugestion.PadRight(colValuesOffset));
}
// Show type of test
string type = "";
switch (issueType)
{
case IssueType.Error:
type = "Non-Words";
break;
case IssueType.Warning:
type = "Real-Words";
break;
}
// Show results
colLabelsOffset = 30;
colValuesOffset = 12;
string output = Environment.NewLine;
output += type.PadRight(colLabelsOffset) + "Levenshtein".PadLeft(colValuesOffset) + "N-Gram".PadLeft(colValuesOffset) + "HTM".PadLeft(colValuesOffset) + System.Environment.NewLine;
output += "Accuracy (%):".PadRight(colLabelsOffset) + issueResult.Levenshtein.Accuracy.ToString("0.000").PadLeft(colValuesOffset) + issueResult.NGram.Accuracy.ToString("0.000").PadLeft(colValuesOffset) + issueResult.Htm.Accuracy.ToString("0.000").PadLeft(colValuesOffset) + System.Environment.NewLine;
output += "Performance (s):".PadRight(colLabelsOffset) + issueResult.Levenshtein.Performance.ToString("0.000").PadLeft(colValuesOffset) + issueResult.NGram.Performance.ToString("0.000").PadLeft(colValuesOffset) + issueResult.Htm.Performance.ToString("0.000").PadLeft(colValuesOffset) + System.Environment.NewLine;
Status.Update(output);
return(issueResult);
}
static void Main(string[] args)
{
try
{
ScyllaJiraClient client = new ScyllaJiraClient("username", "password");
// List project ids and keys...
//client.Projects.GetProjects().ForEach(proj => { Console.WriteLine(string.Format("{0}-{1}", proj.id, proj.key)); });
// TYPED - Grab an issue
//Issue issue = client.Issues.GetIssueByKey("SWS-31");
// JSON - Grab an issue
//IRestResponse issue2 = client.Execute(new RestRequest("issue/SWS-31/worklog"));
//string json = issue2.Content;
// Create issue
//CreateIssueResponse issue3 = client.Issues.CreateIssue("AT", "First Issue", "Description of the issue...");
// Get issues by project
IssueResult result = client.Issues.GetIssuesByProject("SWS");
// Find all worklog entries
result.issues.ForEach(issue => {
WorkLogResponse resp = client.Issues.GetIssueWorklogs(issue.key);
if (resp.total > 0)
{
Console.WriteLine(issue.key + " - " + issue.fields.summary);
resp.worklogs.ForEach(wl => {
Console.WriteLine("\t" + wl.author.displayName + " spent " + wl.timeSpent + " on " + wl.created.ToShortDateString());
});
}
});
}
catch (Exception e)
{
Console.WriteLine("Error: " + e.Message);
}
finally
{
Console.ReadKey();
}
}
public static IssueResult GetInstance(string id)
{
var paramList = new List <ParameterValue> {
new ParameterValue("idInstance", id)
};
var r = DataFacade.GetDataRow("InstanceGet",
paramList.ToArray());
var l = new IssueResult
{
DateDryFrom = r["DateDryFrom"].ToString(),
DateDryTo = r["DateDryTo"].ToString(),
ATGCommFail = r["ATGCommFail"].ToString(),
ATGOperational = r["ATGOperational"].ToString(),
Claim = r["Claim"].ToString(),
ClaimComment = r["ClaimComment"].ToString(),
IDIssueType = (r["idIssueType"].ToString()),
IDProduct = (r["idProduct"].ToString()),
ProductName = (r["ProductName"].ToString()),
IDRequestStatus = (r["idRequestStatus"].ToString()),
RequestStatusName = (r["RequestStatusName"].ToString()),
IDTank = (r["idTank"].ToString()),
TankName = (r["TankName"].ToString()),
UserId = r["UserId"].ToString(),
Email = r["Email"].ToString(),
Name = r["Name"].ToString(),
PODReference = r["PODReference"].ToString(),
DateLogged = (r["DateLogged"].ToString()),
DateClosed = (r["DateClosed"].ToString()),
Comment = r["Comment"].ToString(),
IssueTypeName = r["IssueTypeName"].ToString(),
Volume = r["Volume"].ToString(),
IDInstance = (r["idInstance"].ToString()),
IDSOC = (r["idSOC"].ToString()),
SOCName = (r["SOCName"].ToString())
};
return(l);
}
/// <summary>
///
/// </summary>
/// <param name="requestStatus"></param>
/// <param name="instance"></param>
public void SendEmail(string requestStatus, IssueResult instance)
{
string strXslt = "", strAdminXslt = "";
var template = new Email();
if (requestStatus == Constants.REQUEST_STATUS_OPEN)
{
template.Subject = "Instance added";
template.AdminSubject = "A new Instance has been added";
template._Email = instance.Email;
template.AdminEmail = ConfigurationManager.AppSettings["StandingDryAdminEmail"];
strXslt = ("DealerCreateInstanceLetterTemplate");
strAdminXslt = ("AdminCreateInstanceLetterTemplate");
}
if (requestStatus == Constants.REQUEST_STATUS_CLOSED)
{
template.Subject = "Instance closed";
template.AdminSubject = "An Instance has been closed";
template._Email = instance.Email;
template.AdminEmail = ConfigurationManager.AppSettings["StandingDryAdminEmail"];
strXslt = ("DealerClosedInstanceLetterTemplate");
strAdminXslt = ("AdminClosedInstanceLetterTemplate");
}
if (requestStatus == Constants.REQUEST_STATUS_RETRACTED)
{
template.Subject = "Instance retracted";
template.AdminSubject = "An Instance has been retracted";
template._Email = instance.Email;
template.AdminEmail = ConfigurationManager.AppSettings["StandingDryAdminEmail"];
strXslt = ("DealerRetractedInstanceLetterTemplate");
strAdminXslt = ("AdminRetractedInstanceLetterTemplate");
}
var client = new SmtpClient(ConfigurationManager.AppSettings["SMTP"]);
string templatepath = ConfigurationManager.AppSettings["EmailTemplates"];
XmlDocument doc = XsltTransformer.Render(instance, templatepath + strXslt + ".xslt");
var mailMessage = new MailMessage
{
From = new MailAddress(ConfigurationManager.AppSettings["StandingDryAdminEmailFrom"])
};
mailMessage.To.Add(new MailAddress(template._Email));
mailMessage.IsBodyHtml = true;
mailMessage.Subject = template.Subject;
mailMessage.Body = doc.InnerXml;
try
{
//Sending email to dealer informing them of the online change
client.Send(mailMessage);
}
catch (Exception e)
{
throw new Exception("Failed to send email to " + template._Email + ". " + e.Message, e);
}
doc = XsltTransformer.Render(instance, templatepath + strAdminXslt + ".xslt");
mailMessage = new MailMessage
{
From =
new MailAddress(ConfigurationManager.AppSettings["StandingDryAdminEmailFrom"])
};
mailMessage.To.Add(new MailAddress(template.AdminEmail));
mailMessage.IsBodyHtml = true;
mailMessage.Subject = template.AdminSubject;
mailMessage.Body = doc.InnerXml;
//Sending email to administration about the change
try
{
client.Send(mailMessage);
}
catch (Exception e)
{
//Creating nicely formatted exception
throw new Exception("Failed to send email to " + template.AdminEmail + ". " + e.Message, e);
}
}
public string Edit(IssueResult log)
{
return(IssueDao.Edit(log));
}
public static string Edit(IssueResult log)
{
var paramList = new List <ParameterValue> {
new ParameterValue("idInstance", log.IDInstance)
};
if (!String.IsNullOrEmpty(log.DateDryTo))
{
paramList.Add(new ParameterValue("DateDryTo", log.DateDryTo)); //
}
if (!String.IsNullOrEmpty(log.ATGCommFail))
{
paramList.Add(new ParameterValue("ATGCommFail", Convert.ToBoolean(log.ATGCommFail) ? 1 : 0)); //
}
if (!String.IsNullOrEmpty(log.ATGOperational))
{
paramList.Add(new ParameterValue("ATGOperational", Convert.ToBoolean(log.ATGOperational) ? 1 : 0)); //
}
if (!String.IsNullOrEmpty(log.DateDryFrom))
{
paramList.Add(new ParameterValue("DateDryFrom", log.DateDryFrom)); //
}
if (!String.IsNullOrEmpty(log.DateLogged))
{
paramList.Add(new ParameterValue("DateLogged", log.DateLogged)); //
}
if (!String.IsNullOrEmpty(log.PODReference))
{
paramList.Add(new ParameterValue("PODReference", log.PODReference)); //
}
if (!String.IsNullOrEmpty(log.Comment))
{
paramList.Add(new ParameterValue("Comment", log.Comment)); //
}
if (!String.IsNullOrEmpty(log.Claim))
{
paramList.Add(new ParameterValue("Claim", Convert.ToBoolean(log.Claim) ? 1 : 0)); //
}
if (!String.IsNullOrEmpty(log.ClaimComment))
{
paramList.Add(new ParameterValue("ClaimComment", log.ClaimComment)); //
}
if (!String.IsNullOrEmpty(log.Volume))
{
paramList.Add(new ParameterValue("Volume", log.Volume)); //
}
if (!String.IsNullOrEmpty(log.DealerUser))
{
paramList.Add(new ParameterValue("DealerUser", log.DealerUser));
}
if (log.IDInstance != null)
{
paramList.Add(new ParameterValue("idInstance", log.IDInstance));
}
if (!String.IsNullOrEmpty(log.IDIssueType))
{
paramList.Add(new ParameterValue("idIssueType", log.IDIssueType)); //
}
if (log.IDProduct != null)
{
paramList.Add(new ParameterValue("idProduct", log.IDProduct)); //
}
if (log.IDRequestStatus != null)
{
paramList.Add(new ParameterValue("idRequestStatus", log.IDRequestStatus)); //
}
if (log.IDSOC != null)
{
paramList.Add(new ParameterValue("idSOC", log.IDSOC)); //
}
if (log.IDTank != null)
{
paramList.Add(new ParameterValue("idTank", log.IDTank)); //
}
if (!String.IsNullOrEmpty(log.Name))
{
paramList.Add(new ParameterValue("Name", log.Name)); //
}
if (!String.IsNullOrEmpty(log.UserId))
{
paramList.Add(new ParameterValue("UserId", log.UserId)); //
}
paramList.Add(new ParameterValue("Adding", log.Adding ? 1 : 0)); //
var r = DataFacade.GetDataRow("InstanceEdit",
paramList.ToArray());
string idInstance = r["idInstance"].ToString();
return(idInstance);
}
public IssueResult GetIssueInstance(string id)
{
IssueResult result = BaseApiController.FacadeRepository.GetIssueFacade().GetInstance(id);
return(result);
}
