//[ValidateAntiForgeryToken]
public async Task <IActionResult> Create([Bind("PriorityId, ProjectId, Title, Description")] Issues issues)
{
//if (ModelState.IsValid)
//{
var user = await GetCurrentUserAsync();
Issues issue = new Issues()
{
ProjectId = issues.ProjectId,
UserId = user.Id,
PriorityId = issues.PriorityId,
IsActive = true,
IsCompleted = false,
IsReviewed = false,
Description = issues.Description,
Title = issues.Title,
CreatorId = user.Id
};
//IssueId, CreatedByUserId,PriorityId,IsActive,IsCompleted,IsReviewed
_context.Add(issue);
await _context.SaveChangesAsync();
//var projects = await _context.Projects.FindAsync(issues.ProjectId);
//var project = _context.Projects.Include(i => i).Where(pm => pm.ProjectId == issue.ProjectId);
//var IndexId = Int32.Parse(projects.ProjectId);
//var anothertemp = id.ToString();
//var TempRedirectString = issue.ProjectId;
//var RedirectInt = Int32.Parse(TempRedirectString);
return(RedirectToAction("Index", new { id = issue.ProjectId }));
//}
//return View(issues);
}
/// <summary>
/// Get List Issue MeetingRoom
/// </summary>
/// <param name="account">Account of User</param>
/// <returns>List<Issue></returns>
public List <Issue> GetAllIssue(Accounts account)
{
Issues alldata = GetAllMeetingRoom(account);
var list = alldata.issues;
return(list);
}
private void ItemRenamed([NotNull] object sender, [NotNull] ItemUri itemuri, [NotNull] string newname)
{
Debug.ArgumentNotNull(sender, nameof(sender));
Debug.ArgumentNotNull(itemuri, nameof(itemuri));
Debug.ArgumentNotNull(newname, nameof(newname));
if (validationIssues == null)
{
return;
}
var changed = false;
for (var index = validationIssues.Count - 1; index >= 0; index--)
{
var issue = validationIssues[index];
if (issue.ItemUri != itemuri)
{
continue;
}
issue.Name = issue.Name.Left(issue.Name.LastIndexOf('/')) + '/' + newname;
changed = true;
}
if (!changed)
{
return;
}
Issues.Items.Clear();
RenderIssues(validationIssues);
Issues.FilterTreeViewItems(filterText, GetHeaderText);
}
//[ValidateAntiForgeryToken]
public async Task <IActionResult> Edit(int id, [Bind("IssueId,ProjectId, PriorityId,IsActive,IsCompleted,IsReviewed, Title, Description, CreatorId, UserId, Creator")] Issues issues)
{
//CreatedByUserId,
if (id != issues.IssueId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (issues.IsReviewed == true)
{
issues.IsActive = false;
}
try
{
_context.Update(issues);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IssuesExists(issues.IssueId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index", new { id = issues.ProjectId }));
}
return(View(issues));
}
public RequestEntityTooLargeException()
{
Issues.Add(new OperationOutcomeIssue(
OperationOutcomeConstants.IssueSeverity.Error,
OperationOutcomeConstants.IssueType.Invalid,
Resources.ResourceTooLarge));
}
private void ItemDeleted([NotNull] object sender, [NotNull] ItemUri itemuri)
{
Debug.ArgumentNotNull(sender, nameof(sender));
Debug.ArgumentNotNull(itemuri, nameof(itemuri));
if (validationIssues == null)
{
return;
}
var changed = false;
for (var index = validationIssues.Count - 1; index >= 0; index--)
{
var issue = validationIssues[index];
if (issue.ItemUri != itemuri)
{
continue;
}
validationIssues.Remove(issue);
changed = true;
}
if (!changed)
{
return;
}
Issues.Items.Clear();
RenderIssues(validationIssues);
Issues.FilterTreeViewItems(filterText, GetHeaderText);
}
protected void TextBoxIssueOrder_TextChanged(object sender, EventArgs e)
{
try
{
// Checks
CheckForDangerousInput();
var order = TextBox_Issue_Order.Text.Trim();
if (order == Empty)
{
throw new ApplicationException("The Order Textbox can not be empty.");
}
if (!order.IsValidInteger())
{
throw new ApplicationException("The Order Textbox needs to be an integer.");
}
var issueOrder = IsNullOrEmpty(order)
? 1
: Convert.ToInt16(order);
Issues.UpdateIssueOrder(issueOrder, _IssueKey);
Table_Issue_Edit.Visible = false;
RenumberIssues();
//CreateIssuesReport();
Msg.Text = Ok("The issue order has been updated");
}
catch (Exception ex)
{
Msg.Text = Fail(ex.Message);
LogAdminError(ex);
}
}
public ResourceNotValidException(IEnumerable <ValidationFailure> validationFailures)
{
EnsureArg.IsNotNull(validationFailures, nameof(validationFailures));
foreach (var failure in validationFailures)
{
if (failure is FhirValidationFailure fhirValidationFailure)
{
if (fhirValidationFailure.IssueComponent != null)
{
Issues.Add(fhirValidationFailure.IssueComponent);
}
}
else
{
string[] location = string.IsNullOrEmpty(failure.PropertyName) ? null : new[] { failure.PropertyName };
Issues.Add(new OperationOutcomeIssue(
OperationOutcomeConstants.IssueSeverity.Error,
OperationOutcomeConstants.IssueType.Invalid,
failure.ErrorMessage,
location));
}
}
}
private void ExportAsTextResults()
{
var resultBuilder = new StringBuilder();
var grouped = Issues.OfType <JiraIssue>().GroupBy(i => i.EpicName);
foreach (var group in grouped)
{
if (string.IsNullOrWhiteSpace(group.Key))
{
resultBuilder.AppendLine("\n(No Epic)");
}
else
{
resultBuilder.AppendLine("\n" + group.Key);
}
foreach (var issue in group)
{
resultBuilder.AppendLine(string.Format("* {0} - {1}", issue.Key, issue.Summary));
}
}
var dialog = new TextualPreview(resultBuilder.ToString());
dialog.ShowDialog();
}
// Textboxes
//Issues
protected void TextBoxIssueDescription_TextChanged(object sender,
EventArgs e)
{
try
{
// checks
CheckForDangerousInput();
var description = TextBox_Issue_Description.Text.Trim();
if (description == Empty)
{
throw new ApplicationException(
"The Issue Description Textbox is empty.");
}
if (description.Length > 40)
{
var tooLongBy = description.Length - 40;
throw new ApplicationException(
$"The Issue description must be 40 characters or less. You need to shorten by {tooLongBy} characters");
}
Issues.UpdateIssue(description, _IssueKey);
Table_Issue_Edit.Visible = false;
//CreateIssuesReport();
Msg.Text = Ok("The issue description has been updated");
}
catch (Exception ex)
{
Msg.Text = Fail(ex.Message);
LogAdminError(ex);
}
}
public void ChangeThisProps(Issues issues)
{
this.IssuesCategoriesId = issues.IssuesCategoriesId;
IssuesStatusesId = issues.IssuesStatusesId;
IssuesCreatedBy = issues.IssuesCreatedBy;
IssuesCreatedDate = issues.IssuesCreatedDate;
IssuesLastModifiedBy = issues.IssuesLastModifiedBy;
IssuesLastModifiedDate = issues.IssuesLastModifiedDate;
IssuesDescription = issues.IssuesDescription;
IssuesExpectedBehavior = issues.IssuesExpectedBehavior;
IssuesPriorityId = issues.IssuesPriorityId;
IssuesProjectsId = issues.IssuesProjectsId;
IssuesSeverityId = issues.IssuesSeverityId;
IssuesTitle = issues.IssuesTitle;
IssueCategoriesTitle = issues.IssueCategoriesTitle;
IssuesProjectsIsActive = issues.IssuesProjectsIsActive;
IssuesProjectsTitle = issues.IssuesProjectsTitle;
IssuesStatusesTitle = issues.IssuesStatusesTitle;
IssuesSeverityTitle = issues.IssuesSeverityTitle;
IssuesPriorityTitle = issues.IssuesPriorityTitle;
}
private void ExportAsConfluenceMarkupResults()
{
var resultBuilder = new StringBuilder();
var grouped = Issues.OfType <JiraIssue>().GroupBy(i => i.EpicName);
foreach (var group in grouped)
{
resultBuilder.AppendLine();
if (string.IsNullOrWhiteSpace(group.Key))
{
resultBuilder.AppendLine("h2. (No Epic)");
}
else
{
resultBuilder.AppendLine("h2. " + group.Key);
}
resultBuilder.AppendLine();
foreach (var issue in group)
{
resultBuilder.AppendLine(string.Format("* *{0}* - {1}", issue.Key, EscapeConfluenceMarkupCharacters(issue.Summary)));
}
}
var dialog = new TextualPreview(resultBuilder.ToString());
dialog.ShowDialog();
}
static void Main()
{
//TestPullRequest ();
var user = new User(new BasicCacher.BasicCacher(), new SimpleLogProvider());
user.Authenticate(new GithubSharp.Core.Models.GithubUser {
Name = "AleksMorozova", APIToken = "f1870a94856b1d74f844db3a03863e949309a66f"
});
try
{
var privateuser = user.Get();
if (privateuser == null)
{
throw new Exception("Invalid user");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
var issuesAPI = new Issues(new BasicCacher.BasicCacher(), new SimpleLogProvider());
var closedIssues = issuesAPI.List("Gruvo", "AleksMorozova", GithubSharp.Core.Models.IssueState.Closed);
var openIssues = issuesAPI.List("Gruvo", "AleksMorozova", GithubSharp.Core.Models.IssueState.Open);
Console.ReadKey();
}
public CustomerManagedKeyInaccessibleException()
{
Issues.Add(new OperationOutcomeIssue(
OperationOutcomeConstants.IssueSeverity.Error,
OperationOutcomeConstants.IssueType.Forbidden,
Resources.CustomerManagedKeyInaccessible));
}
public Issues GetIssuesApi()
{
var issues = new Issues(_basicCacher, _logger);
issues.Authenticate(GithubUser);
return(issues);
}
private void AddIssue(string diagnostics)
{
Issues.Add(new OperationOutcomeIssue(
OperationOutcomeConstants.IssueSeverity.Error,
OperationOutcomeConstants.IssueType.Forbidden,
diagnostics));
}
private void OpenNew(object param)
{
NewTaskView newTaskView;
int id;
int.TryParse(param.ToString(), out id);
if (id > 0)
{
newTaskView = new NewTaskView("", Issues.FirstOrDefault(x => x.Id == id));
}
else
{
newTaskView = new NewTaskView("", null);
}
if (newTaskView.ShowDialog().Value)
{
newTaskView.Issue.Id = FileRepository.GetLastId("Issue");
Issues.Add(newTaskView.Issue);
FileRepository.UpdateFile <Issue>("issue", Issues.ToList());
if (newTaskView.Issue.IssueDate.Date == DateTime.Now.Date)
{
TodayIssues.Add(newTaskView.Issue);
}
}
}
public BadRequestException(string errorMessage)
{
Issues.Add(new OperationOutcomeIssue(
OperationOutcomeConstants.IssueSeverity.Error,
OperationOutcomeConstants.IssueType.Invalid,
errorMessage));
}
/// <summary>
/// Produces an exception from a result, ordered by descending severity.
/// </summary>
public ResultException ToException()
{
return(Issues
.Where(issue => !ReferenceEquals(issue, null))
.OrderByDescending(issue => issue.Level)
.Aggregate <ResultIssue, ResultException>(null, (inner, issue) => new ResultException(issue, inner)));
}
public async Task <int> CreateIssue([FromBody] Issues i)
{
i.IssueCategory = null;
i.UserReportedId = (await _userManager.Users.FirstOrDefaultAsync(x => x.UserName.Equals(User.Identity.Name, StringComparison.InvariantCultureIgnoreCase))).Id;
await _issues.Add(i);
var category = await _categories.GetAll().FirstOrDefaultAsync(x => i.IssueCategoryId == x.Id);
if (category != null)
{
i.IssueCategory = category;
}
var notificationModel = new NotificationOptions
{
RequestId = i.RequestId ?? 0,
DateTime = DateTime.Now,
NotificationType = NotificationType.Issue,
RequestType = i.RequestType,
Recipient = string.Empty,
AdditionalInformation = $"{i.Subject} | {i.Description}",
UserId = i.UserReportedId,
};
AddIssueNotificationSubstitutes(notificationModel, i, User.Identity.Name);
await _notification.Notify(notificationModel);
return(i.Id);
}
public UnauthorizedFhirActionException()
{
Issues.Add(new OperationOutcomeIssue(
OperationOutcomeConstants.IssueSeverity.Error,
OperationOutcomeConstants.IssueType.Forbidden,
Resources.Forbidden));
}
public Argument?Execute(SyntaxNode node)
{
try
{
var result = EngineInstruction.Evaluate(this, node);
if (result != null)
{
return(new Argument(node, result));
}
}
catch (CompilerException compilerException)
{
Issues.Add(compilerException.Origin ?? node, CompilerIssueType.Error, compilerException.Message, compilerException.InnerException);
if (Context.FailOnError)
{
// Instead of propagating the exception, we just stop.
Stop();
}
}
return(null);
}
public async Task <Result> EditIssue(IssueDTO dto, string userId, string userDept)
{
Result result = new Result();
try
{
Issues issue = _repo.GetById <Issues>(Convert.ToInt32(dto.Id));
issue.Issue = dto.Issue;
issue.SeverityLevel = dto.SeverityLevel;
issue.Description = dto.Description;
issue.AssignedTo = dto.AssignedTo;
issue.Date = dto.Date;
issue.Action = dto.Action;
issue.Status = dto.Status;
issue.ModifiedBy = userId;
issue.ModifiedDate = DateTime.UtcNow;
_repo.Update(issue);
await _repo.SaveAsync();
result.Message = "Issue has been successfully updated.";
result.Success = true;
}
catch (Exception)
{
throw;
}
return(result);
}
public void Post(string defectId)
{
using (IOTMOdel context = new IOTMOdel())
{
// string query_1 = @"INSERT INTO [dbo].[Issues]([DefectID],[RequestTime],[ResponceTime],[status]) OUTPUT INSERTED.ID VALUES('" + defectId + "','"+ DateTime.Now + "','','"+false+ "')";
// string query_1 = @"Insert into Issues(DefectID, RequestTime, ResponceTime, status) Output Inserted.ID Values('" + defectId + "','" + DateTime.Now + "','','" + false + "')";
// Debug.WriteLine(query_1);
Issues issues = new Issues();
issues.status = true;
issues.DefectID = defectId;
issues.RequestTime = DateTime.Now;
issues.ResponceTime = DateTime.Now;
context.Issues.Add(issues);
context.SaveChanges();// end of the save
try
{
context.SaveChanges();
var lineInfo = context.IPs.Where(x => x.RaspBerryID == 2).FirstOrDefault();
string responce = TakeAction(lineInfo.IPAddress, defectId, issues.ID);
int issue = Int32.Parse(responce);
var issueEntity = context.Issues.SingleOrDefault(f => f.ID == issue);
issueEntity.status = true;
issueEntity.ResponceTime = DateTime.Now;
context.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine("Error " + ex);
}
}
}
/// <summary>
/// Sonar Api client constructor. One instance per Sonar server address.
/// </summary>
/// <param name="baseAddress">The Uri of the server Sonar API</param>
private void AffectURI(Uri baseAddress)
{
_baseAddress = baseAddress.AbsoluteUri;
_issues = BaseObjectApi <Issues> .CreateObject(this);
_system = BaseObjectApi <Business.System.System> .CreateObject(this);
_filters = BaseObjectApi <Filters> .CreateObject(this);
_languages = BaseObjectApi <Languages> .CreateObject(this);
_rules = BaseObjectApi <Rules> .CreateObject(this);
_qualityProfiles = BaseObjectApi <QualityProfiles> .CreateObject(this);
_qualityGates = BaseObjectApi <QualityGates> .CreateObject(this);
_projects = BaseObjectApi <Projects> .CreateObject(this);
_plugins = BaseObjectApi <Plugins> .CreateObject(this);
_users = BaseObjectApi <Users> .CreateObject(this);
_userGroups = BaseObjectApi <UserGroups> .CreateObject(this);
_permissions = BaseObjectApi <Permissions> .CreateObject(this);
_metrics = BaseObjectApi <Metrics> .CreateObject(this);
_measures = BaseObjectApi <Measures> .CreateObject(this);
_components = BaseObjectApi <Components> .CreateObject(this);
}
private static bool IsValidIssue(string issueKey, string stateCode)
{
if (Is_Valid_Issue(issueKey))
#region Check StateCode in IssueKey match StateCode for page
{
switch (Issues.GetIssueLevelFromKey(issueKey.ToUpper()))
{
case "A": //All Offices
return(Issues.GetStateCodeFromKey(issueKey) == "LL");
case "B": //National issues
return(Issues.GetStateCodeFromKey(issueKey) == "US");
case "C": //State Issues
return(Issues.GetStateCodeFromKey(issueKey) == stateCode);
case "D": //County Issues
return(Issues.GetStateCodeFromKey(issueKey) == stateCode);
case "E": //Local Issues
return(Issues.GetStateCodeFromKey(issueKey) == stateCode);
default:
return(false);
}
}
#endregion Check StateCode in IssueKey match StateCode for page
return(false);
}
public Issues GetAllIssues(Issues issues)
{
//// Deserializing json data to object
//JavaScriptSerializer js = new JavaScriptSerializer();
//Issues issues = js.Deserialize<Issues>(content);
//string title = issues.IssueTitle;
//string description = issues.IssueDescription;
// Other way to whithout help of BlogSites class
//Issues issues = JsonConvert.DeserializeObject<Issues>(content);
//var serializer = new JavaScriptSerializer();
//dynamic jsonObject = serializer.Deserialize<dynamic>(content);
//myProperty = Convert.MyPropertyType(jsonObject["myProperty"]);
//var jobj = (JObject)JsonConvert.DeserializeObject(content);
//var items = jobj.Children()
// .Cast<JProperty>()
// .Select(j => new
// {
// ID = j.Name,
// title = (string)j.Value["title"],
// body = (string)j.Value["body"],
// labels = (string)j.Value["labels"],
// })
// .ToList();
context.Issues.InsertOne(issues);
return(issues);
}
private void IssuesChanged()
{
int warnings = 0;
int errors = 0;
int messages = 0;
foreach (Issue issue in _issuesAnalyzerService.AnalyzerContext.Issues)
{
if (issue.Severity == IssueSeverity.Message)
{
messages++;
}
if (issue.Severity == IssueSeverity.Warning)
{
warnings++;
}
if (issue.Severity == IssueSeverity.Error)
{
errors++;
}
}
Errors = errors;
Warnings = warnings;
Messages = messages;
Issues.Refresh();
}
public async Task <int> CreateIssue([FromBody] Issues i)
{
i.IssueCategory = null;
i.CreatedDate = DateTime.UtcNow;
var username = User.Identity.Name.ToUpper();
var reportedUser = await _userManager.Users.FirstOrDefaultAsync(x => x.NormalizedUserName == username);
i.UserReportedId = reportedUser.Id;
await _issues.Add(i);
var category = await _categories.GetAll().FirstOrDefaultAsync(x => i.IssueCategoryId == x.Id);
if (category != null)
{
i.IssueCategory = category;
}
var notificationModel = new NotificationOptions
{
RequestId = i.RequestId ?? 0,
DateTime = DateTime.UtcNow,
NotificationType = NotificationType.Issue,
RequestType = i.RequestType,
Recipient = string.Empty,
AdditionalInformation = $"{i.Subject} | {i.Description}",
UserId = i.UserReportedId,
};
AddIssueNotificationSubstitutes(notificationModel, i, reportedUser.UserName, reportedUser.UserAlias);
await _notification.Notify(notificationModel);
return(i.Id);
}
protected void ReportQuestion(DataRow row)
{
var tr = new HtmlTableRow().AddTo(CurrentHtmlTable, "trReportDetail");
new HtmlTableCell {
InnerText = row.QuestionOrder().ToString()
}
.AddTo(tr, "tdReportDetail");
var td = new HtmlTableCell().AddTo(tr, "tdReportDetail");
new HtmlAnchor
{
HRef = SecureAdminPage.GetIssuesPageUrl(Issues.GetStateCodeFromKey(row.IssueKey()),
row.IssueKey(), row.QuestionKey()),
InnerHtml = $"<nobr>{row.Question()}</nobr>"
}.AddTo(td);
td = new HtmlTableCell().AddTo(tr, "tdReportDetail");
new HtmlAnchor
{
HRef = SecureAdminPage.GetIssuesPageUrl(Issues.GetStateCodeFromKey(row.IssueKey()),
row.IssueKey(), row.QuestionKey(), !row.IsQuestionOmit()),
InnerHtml = row.IsQuestionOmit() ? "<strong>OMIT</strong>" : "ok"
}.AddTo(td);
new HtmlTableCell {
InnerText = row.QuestionKey()
}
.AddTo(tr, "tdReportDetail");
new HtmlTableCell {
InnerText = row.Count().ToString()
}
.AddTo(tr, "tdReportDetail");
}
public ProductCreated(TenantId tenantId, Issues.ProductId id, string name, string description, ProductManager manager, IssueAssigner assigner)
{
// TODO: Complete member initialization
this.TenantId = tenantId.ToString();
this.ProductId = id.ToString();
this.Name = name.ToString();
this.Description = description.ToString();
this.ProductManager = manager.ToString();
this.IssueAssigner = assigner.ToString();
}
internal int updateIssue(Issues issues)
{
String sql = "update ISSUES set comments=:n " +
", type=:t , complete=:c, admin=:a , datereview=:d" +
" where id=:i";
var data = db.Database.ExecuteSqlCommand(sql,
new OracleParameter(":n", issues.Comments),
new OracleParameter(":t", issues.Type),
new OracleParameter(":c", issues.Complete),
new OracleParameter(":a", issues.Admin),
new OracleParameter(":d", DateTime.Now),
new OracleParameter(":i", issues.Id)
);
// new OracleParameter(":d", issues.DateReview),
return data;
}
internal void insertNewIssueInLineOld(Issues newIssue)
{
string sql = "insert into ISSUES (MIDNID,TYPE,COMPLETE,ADMIN,COMMENTS,VISIBLE) " +
" values (:i, :t, :c, :a, :cmt, :v) ";
db.Database.ExecuteSqlCommand(sql, new OracleParameter(":i", newIssue.MidnId)
, new OracleParameter(":t", newIssue.Type)
, new OracleParameter(":c", newIssue.Complete)
, new OracleParameter(":a", newIssue.Admin)
, new OracleParameter(":cmt", newIssue.Comments)
, new OracleParameter(":v", 1)
);
}
internal int addIssueTypes(Issues model)
{
string sql = "insert into ISSUE_TYPE (TYPE) values (:s)";
var data = db.Database.ExecuteSqlCommand(sql,
new OracleParameter(":s", model.Type)
);
return data;
}
public AddressResolutionException(string message, Issues issue) :
base(message)
{
Issue = issue;
}
/// <summary>
/// Using stored proc and returning issue id
/// </summary>
/// <param name="newIssue"></param>
/// <returns></returns>
internal Int32 insertNewIssue(Issues newIssue)
{
String spName = "PKG_MM_ISSUES.ADD_ISSUE";
Int32 resIssueId =0;
var connectionString = dbConn;
ParameterDirection pin = ParameterDirection.Input;
ParameterDirection pout = ParameterDirection.Output;
try
{
using (var conn = new OracleConnection(connectionString))
using (var command = new OracleCommand(spName, conn)
{
CommandType = CommandType.StoredProcedure
})
{
command.Parameters.Add("P_MIDNID", OracleDbType.Int32, 256, pin).Value = newIssue.MidnId;
command.Parameters.Add("P_TYPE", OracleDbType.Varchar2, 100, pin).Value = newIssue.Type;
command.Parameters.Add("P_COMPLETE", OracleDbType.Int32, pin).Value = newIssue.Complete;
command.Parameters.Add("P_ADMIN", OracleDbType.Int32, pin).Value = newIssue.Admin;
command.Parameters.Add("P_COMMENTS", OracleDbType.Varchar2, 4000, pin).Value = newIssue.Comments;
command.Parameters.Add("P_VISIBLE", OracleDbType.Int32, pin).Value = 1;
command.Parameters.Add("P_ISSUEID", OracleDbType.Int64, pout);
conn.Open();
command.ExecuteNonQuery();
resIssueId = int.Parse(command.Parameters["P_ISSUEID"].Value.ToString());
// resIssueId= Convert.ToInt32(res);
conn.Close();
}
}
catch (Exception e) {
logger.Error(e.Message);
}
return resIssueId;
}