public HttpResponseMessage ChangeIssueStatus(PM_IssuesLog IssueLog)
{
//IssueLog.UserId = ViewBag.UserId;
PM_IssueBL bal = new PM_IssueBL();
if (IssueLog.IssueLogId != 0)
{
var res = bal.ManageIssueLog("Insert_IssueLog_Status", IssueLog);
if (res)
{
return(this.Request.CreateResponse(HttpStatusCode.OK,
new { Message = "Issue status Loged", Value = 1 }));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Issue status not Loged"));
}
}
else
{
var res = bal.ManageIssueLog("Insert_IssueLog_Status", IssueLog);
if (res)
{
return(this.Request.CreateResponse(HttpStatusCode.OK,
new { Message = "Issue status Loged", Value = 1 }));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Issue status not Loged"));
}
}
}
public List <PM_IssuesLog> GetIssue(string Filter, long IssueId)
{
DataTable dt = dal.GetIssueLog(Filter, IssueId);
List <PM_IssuesLog> lst = new List <PM_IssuesLog>();
foreach (DataRow item in dt.Rows)
{
PM_IssuesLog issue = new PM_IssuesLog();
issue.ActivityTypeId = (!string.IsNullOrEmpty(item["ActivityTypeId"].ToString())) ? int.Parse(item["ActivityTypeId"].ToString()) : 0; // Convert.ToInt64(item["ActivityTypeId"]);
issue.IssueCategoryId = (!string.IsNullOrEmpty(item["IssueCategoryId"].ToString())) ? int.Parse(item["IssueCategoryId"].ToString()) : 0; /// Convert.ToInt64(item["IssueCategoryId"]);
issue.eNB = item["eNB"].ToString();
issue.IsUnavoidable = Convert.ToBoolean(item["IsUnavoidable"]);
issue.ExtendedeNB = item["ExtendedeNB"].ToString();
issue.AOTSCR = item["AOTSCR"].ToString();
issue.RequestedDate = Convert.ToDateTime(item["RequestedDate"].ToString());
issue.ReasonId = (!string.IsNullOrEmpty(item["ReasonId"].ToString())) ? int.Parse(item["ReasonId"].ToString()) : 0; //Convert.ToInt64(item["ReasonId"]);
issue.MSWindowId = (!string.IsNullOrEmpty(item["MSWindowId"].ToString())) ? int.Parse(item["MSWindowId"].ToString()) : 0; //Convert.ToInt64(item["MSWindowId"]);
issue.AlarmId = (!string.IsNullOrEmpty(item["AlarmId"].ToString())) ? int.Parse(item["AlarmId"].ToString()) : 0; // Convert.ToInt64(item["AlarmId"]);
issue.EquipmentId = item["EquipmentId"].ToString();
issue.AOTSCR = item["AOTSCR"].ToString();
issue.ReasonId = (!string.IsNullOrEmpty(item["ReasonId"].ToString())) ? int.Parse(item["ReasonId"].ToString()) : 0; // Convert.ToInt64(item["ReasonId"]);
issue.SeverityId = (!string.IsNullOrEmpty(item["SeverityId"].ToString())) ? int.Parse(item["SeverityId"].ToString()) : 0; // Convert.ToInt64(item["SeverityId"]);
issue.RequestedBy = item["RequestedBy"].ToString();
issue.ItemTypeId = (!string.IsNullOrEmpty(item["ItemTypeId"].ToString())) ? int.Parse(item["ItemTypeId"].ToString()) : 0; // Convert.ToInt64(item["ItemTypeId"]);
lst.Add(issue);
}
return(lst);
}
public ActionResult ChangeIssueStatus(PM_IssuesLog IssueLog)
{
IssueLog.UserId = ViewBag.UserId;
if (IssueLog.IssueLogId != 0)
{
var res = bal.ManageIssueLog("Insert_IssueLog_Status", IssueLog);
return(Json(res, JsonRequestBehavior.AllowGet));
}
else
{
var res = bal.ManageIssueLog("Insert_IssueLog_Status", IssueLog);
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
public List <PM_IssuesLog> GetIssueLog(string Filter, long IssueId)
{
DataTable dt = dal.GetIssueLog(Filter, IssueId);
List <PM_IssuesLog> lst = new List <PM_IssuesLog>();
foreach (DataRow item in dt.Rows)
{
PM_IssuesLog issue = new PM_IssuesLog();
issue.IssueId = Convert.ToInt64(item["IssueId"]);
issue.IssueLogId = Convert.ToInt64(item["IssueLogId"]);
issue.UserId = Convert.ToInt64(item["UserId"]);
issue.StatusId = Convert.ToInt64(item["StatusId"]);
issue.Description = item["Description"].ToString();
issue.Status = item["Status"].ToString();
issue.Picture = item["Picture"].ToString();
issue.UserName = item["UserName"].ToString();
issue.Task = item["Task"].ToString();
issue.Priority = item["Priority"].ToString();
issue.AssignedToId = item["AssignedToId"].ToString();
issue.CreatedOn = Convert.ToDateTime(item["CreatedOn"].ToString());
if (!string.IsNullOrEmpty(Convert.ToString(item["ActivityTypeId"])))
{
issue.ActivityTypeId = Convert.ToInt64(item["ActivityTypeId"]);
}
issue.IssueCategoryId = Convert.ToInt64(item["IssueCategoryId"]);
issue.eNB = item["eNB"].ToString();
issue.ExtendedeNB = item["ExtendedeNB"].ToString();
issue.AOTSCR = item["AOTSCR"].ToString();
issue.RequestedDate = Convert.ToDateTime(item["RequestedDate"].ToString());
if (!string.IsNullOrEmpty(Convert.ToString(item["ReasonId"])))
{
issue.ReasonId = Convert.ToInt64(item["ReasonId"]);
}
if (!String.IsNullOrEmpty(Convert.ToString(item["MSWindowId"])))
{
issue.MSWindowId = Convert.ToInt64(item["MSWindowId"]);
}
if (!String.IsNullOrEmpty(Convert.ToString(item["AlarmId"])))
{
issue.AlarmId = Convert.ToInt64(item["AlarmId"]);
}
if (!String.IsNullOrEmpty(Convert.ToString(item["EquipmentId"])))
{
issue.EquipmentId = item["EquipmentId"].ToString();
}
if (!String.IsNullOrEmpty(Convert.ToString(item["AOTSCR"])))
{
issue.AOTSCR = item["AOTSCR"].ToString();
}
if (!string.IsNullOrEmpty(Convert.ToString(item["ReasonId"])))
{
issue.ReasonId = Convert.ToInt64(item["ReasonId"]);
}
if (!String.IsNullOrEmpty(Convert.ToString(item["SeverityId"])))
{
issue.SeverityId = Convert.ToInt64(item["SeverityId"]);
}
if (!String.IsNullOrEmpty(Convert.ToString(item["RequestedBy"])))
{
issue.RequestedBy = item["RequestedBy"].ToString();
}
lst.Add(issue);
}
return(lst);
}
public bool ManageIssueLog(string Filter, PM_IssuesLog issueLog)
{
issueLog.CreatedOn = DateTime.Now;
return(dal.ManageIssueLog(Filter, issueLog.IssueId, issueLog.StatusId, issueLog.UserId, issueLog.Description, issueLog.CreatedOn));
}
