protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int taskID = 0;
if (Request.QueryString["isedit"] == null & Request.QueryString["TaskID"] == null)
{
Response.Redirect("~/404.aspx");
}
if (!int.TryParse(Request.QueryString["TaskID"].ToString(), out taskID))
{
taskID = 0;
}
Session["taskid"] = taskID;
ADefHelpDeskTasks t = new ADefHelpDeskTasks();
if (!t.LoadByPrimaryKey(taskID))
{
Response.Redirect("~/404.aspx");
}
ADefHelpDeskTaskDetailsQuery tQ = new ADefHelpDeskTaskDetailsQuery("a");
ADefHelpDeskTaskDetailsCollection tC = new ADefHelpDeskTaskDetailsCollection();
tQ.SelectAll().Where(tQ.TaskID == taskID && tQ.DetailType == "Details");
tQ.es.Top = 1;
tC.Load(tQ);
//Fill the Form
txtTitle.Text = t.Description;
if (tC.Count > 0)
{
foreach (ADefHelpDeskTaskDetails aT in tC)
{
txtDesc.Text = aT.Description;
}
}
}
}
public void grdTask_Select()
{
int taskID = 0;
RowSelectionModel rm = this.grdTask.GetSelectionModel() as RowSelectionModel;
if (rm.SelectedRows.Count > 0)
{
if (!int.TryParse(rm.SelectedRow.RecordID, out taskID))
{
taskID = 0;
}
if (taskID <= 0)
{
return;
}
Session["TaskID"] = taskID;
ADefHelpDeskTasks t = new ADefHelpDeskTasks();
if (t.LoadByPrimaryKey(taskID))
{
ADefHelpDeskTaskDetailsQuery tQ = new ADefHelpDeskTaskDetailsQuery("a");
ADefHelpDeskTaskDetailsCollection tC = new ADefHelpDeskTaskDetailsCollection();
tQ.SelectAll().Where(tQ.TaskID == taskID);
tC.Load(tQ);
if (tC.Count > 0)
{
string detail = string.Empty;
foreach (ADefHelpDeskTaskDetails tD in tC)
{
ADefHelpDeskUsers u = new ADefHelpDeskUsers();
detail += tD.Description;
if (u.LoadByPrimaryKey((int)tD.UserID))
{
detail += "<br><br><b>User : </b>" + u.FirstName;
//detail += "<b>User : </b>" + u.FirstName + ", <b>Insert Date : </b>" + tD.InsertDate.ToString();
//detail += "<br><br><br>";
}
detail += ", <b>Insert Date : </b>" + tD.InsertDate.ToString() + "<br>---------------------------------------------------------<br>";
lblHtml.Html = detail;
}
}
else
{
lblHtml.Html = string.Empty;
}
}
}
}
public void btnSave_Click()
{
int taskID = 0;
if (Session["taskid"] != null)
{
taskID = (int)Session["taskid"];
}
else
{
Response.Redirect("~/404.aspx");
}
ADefHelpDeskTasks t = new ADefHelpDeskTasks();
ADefHelpDeskTaskDetails td = new ADefHelpDeskTaskDetails();
ADefHelpDeskTaskDetailsQuery tdQ = new ADefHelpDeskTaskDetailsQuery("a");
ADefHelpDeskTaskDetailsCollection tdC = new ADefHelpDeskTaskDetailsCollection();
if (t.LoadByPrimaryKey(taskID))
{
t.Description = txtTitle.Text;
tdQ.SelectAll().Where(tdQ.TaskID == taskID, tdQ.DetailType == "Details");
tdQ.es.Top = 1;
tdC.Load(tdQ);
if (tdC.Count > 0)
{
foreach (ADefHelpDeskTaskDetails ttt in tdC)
{
if (td.LoadByPrimaryKey((int)ttt.DetailID))
{
td.Description = txtDesc.Text;
td.Save();
}
}
}
t.Save();
}
//t.PortalID = 0;
//t.Description = txtDesc.Text;
//t.Status = "New";
//t.Priority = "High";
//t.CreatedDate = DateTime.Now;
//t.EstimatedStart = DateTime.Now;
//t.EstimatedCompletion = DateTime.Now.AddDays(7);
//t.DueDate = DateTime.Now.AddDays(14);
//t.AssignedRoleID = 1;
//Password Ticket
//Guid g = new Guid();
//t.TicketPassword = Guid.NewGuid().ToString();
//Get username ID
//ADefHelpDeskUsersQuery uq = new ADefHelpDeskUsersQuery("a");
//ADefHelpDeskUsersCollection uc = new ADefHelpDeskUsersCollection();
//uq.SelectAll().Where(uq.Username == HttpContext.Current.User.Identity.Name.ToString().Trim());
//uq.es.Top = 1;
//uc.Load(uq);
//if (uc.Count > 0)
//{
// foreach (ADefHelpDeskUsers u in uc)
// {
// t.RequesterUserID = u.UserID;
// t.RequesterName = u.FirstName;
// }
//}
//t.Save();
MessageBus.Default.Publish("grdTask_Refresh");
//X.Js.Call("onWinClose");
}
