public bool Manage(string Filter, AV_SiteIssueTracker sit, Int64 UserId)
{
try
{
return(sitD.Manage(Filter, sit.TrackingId, sit.SiteId, sit.TesterId, sit.NetworkModeId, sit.BandId, sit.CarrierId, sit.ScopeId, sit.Description, sit.Status, sit.Picture, sit.IssueType, UserId));
}
catch (Exception)
{
throw;
}
}
public string UpdateStatus(int TrakingId, string Status)
{
try
{
AV_SiteIssueTrackerBL sitd = new AV_SiteIssueTrackerBL();
AV_SiteIssueTracker issue = new AV_SiteIssueTracker();
issue.TrackingId = TrakingId;
issue.Status = Status;
return(sitd.Manage("UpdateStatus", issue, ViewBag.UserId).ToString());
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ActionResult NetLayer(AV_SiteIssueTracker sit)
{
//AV_SiteIssueTracker s = new AV_SiteIssueTracker();
//s.SiteId
AV_SiteIssueTrackerBL sitb = new AV_SiteIssueTrackerBL();
ViewBag.SiteId = sit.SiteId;
ViewBag.TesterId = sit.TesterId;
ViewBag.NetworkModeId = sit.NetworkModeId;
ViewBag.BandId = sit.BandId;
ViewBag.CarrierId = sit.CarrierId;
ViewBag.ScopeId = sit.ScopeId;
var rec = sitb.ToList("byNetLayer", sit);
Common.SelectedList sl = new Common.SelectedList();
ViewBag.IssueTypes = sl.IssueTypes();
return(PartialView("~/views/SiteTrackerIssue/_NetLayer.cshtml", rec));
}
public ActionResult New(AV_SiteIssueTracker sit)
{
Response r = new Response();
try
{
AV_SiteIssueTrackerBL sitd = new AV_SiteIssueTrackerBL();
if (sitd.Manage("Insert", sit, ViewBag.UserId))
{
r.Message = "success";
r.Status = "success";
}
}
catch (Exception ex)
{
r.Status = "error";
r.Message = ex.Message;
}
return(Json(r, JsonRequestBehavior.AllowGet));
}
//public AV_SiteIssueTracker Single(string filter, string value1 = null, string value2 = null)
//{
// DataTable dt = sitD.Get(filter, value1, value2);
// AV_SiteIssueTracker sit = new AV_SiteIssueTracker();
// if (dt.Rows.Count > 0)
// {
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// sit.TrackingId = int.Parse(dt.Rows[i]["TrackingId"].ToString());
// sit.SiteId = int.Parse(dt.Rows[i]["SiteId"].ToString());
// sit.TesterId = int.Parse(dt.Rows[i]["TesterId"].ToString());
// sit.NetworkModeId = int.Parse(dt.Rows[i]["NetworkModeId"].ToString());
// sit.BandId = int.Parse(dt.Rows[i]["BandId"].ToString());
// sit.CarrierId = int.Parse(dt.Rows[i]["CarrierId"].ToString());
// sit.ScopeId = int.Parse(dt.Rows[i]["ScopeId"].ToString());
// sit.Description = dt.Rows[i]["Description"].ToString();
// sit.Status = dt.Rows[i]["Status"].ToString();
// if (!string.IsNullOrEmpty(dt.Rows[i]["ReportDate"].ToString()))
// {
// sit.ReportDate = DateTime.Parse(dt.Rows[i]["ReportDate"].ToString());
// }
// sit.PTrakingId = (!string.IsNullOrEmpty(dt.Rows[i]["PTrakingId"].ToString())) ? int.Parse(dt.Rows[i]["PTrakingId"].ToString()) : 0;
// sit.Tester =(!dt.Columns.Contains("Tester"))? "": dt.Rows[i]["Tester"].ToString();
// sit.Picture = (!dt.Columns.Contains("Picture"))? "": dt.Rows[i]["Picture"].ToString();
// break;
// }
// }
// return sit;
//}
public List <AV_SiteIssueTracker> ToList(string filter, AV_SiteIssueTracker iss)
{
DataTable dt = sitD.Get(filter, iss);
AV_SiteIssueTracker sit;
List <AV_SiteIssueTracker> lst = new List <AV_SiteIssueTracker>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sit = new AV_SiteIssueTracker();
sit.TrackingId = int.Parse(dt.Rows[i]["TrackingId"].ToString());
sit.SiteId = int.Parse(dt.Rows[i]["SiteId"].ToString());
sit.TesterId = int.Parse(dt.Rows[i]["TesterId"].ToString());
sit.NetworkModeId = int.Parse(dt.Rows[i]["NetworkModeId"].ToString());
sit.BandId = int.Parse(dt.Rows[i]["BandId"].ToString());
sit.CarrierId = int.Parse(dt.Rows[i]["CarrierId"].ToString());
sit.ScopeId = int.Parse(dt.Rows[i]["ScopeId"].ToString());
sit.Description = dt.Rows[i]["Description"].ToString();
sit.Status = dt.Rows[i]["Status"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[i]["ReportDate"].ToString()))
{
sit.ReportDate = DateTime.Parse(dt.Rows[i]["ReportDate"].ToString());
}
sit.PTrakingId = (!string.IsNullOrEmpty(dt.Rows[i]["PTrakingId"].ToString())) ? int.Parse(dt.Rows[i]["PTrakingId"].ToString()) : 0;
sit.Tester = (!dt.Columns.Contains("Tester")) ? "" : dt.Rows[i]["Tester"].ToString();
sit.Picture = (!dt.Columns.Contains("Picture")) ? "" : dt.Rows[i]["Picture"].ToString();
sit.ImagePath = (!dt.Columns.Contains("ImagePath")) ? "" : dt.Rows[i]["ImagePath"].ToString();
sit.IssueTypeName = (!dt.Columns.Contains("IssueTypeName")) ? "" : dt.Rows[i]["IssueTypeName"].ToString();
lst.Add(sit);
}
}
return(lst);
}
