public void cmbStatus_Change()
{
X.Msg.Alert("Info", cmbStatus.SelectedItem.Value).Show();
if (cmbStatus.SelectedItems.Count <= 0)
{
return;
}
if (string.IsNullOrEmpty(cmbStatus.SelectedItem.Value))
{
return;
}
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
t.InnerJoin(tD).On(t.TaskID == tD.TaskID);
t.InnerJoin(u).On(t.RequesterUserID == u.UserID);
t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.ConfirmAsFinishDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, t.RequesterEmail, t.RequesterPhone,
tD.DetailID, tD.DetailType, tD.UserID, tD.InsertDate, tD.Description.As("Comment"), tD.StartTime, tD.StopTime, u.Username);
t.InnerJoin(tD).On(t.TaskID == tD.TaskID);
t.InnerJoin(u).On(t.AssignedRoleID == u.UserID);
t.Where(t.Status == cmbStatus.SelectedItem.Value.Trim());
//t.Where(t.Status == value);
DataTable dTask = t.LoadDataTable();
storeTask.DataSource = dTask;
storeTask.DataBind();
}
public void storeNeedApproval_ReadData(object sender, StoreReadDataEventArgs e)
{
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.ConfirmAsFinishDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, t.RequesterEmail, t.RequesterPhone);
t.Where(t.Status == "Resolved", t.ApprovedByRequestorID.IsNull());
//RequesterEmail = Service unit peminta
//RequesterPhone = Service unit tujuan
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
//if (!(AppSession.ServiceUnit.UserServiceUnitID == "HIT" || AppSession.ServiceUnit.UserServiceUnitID == "IT"))
//{
t.Where(t.RequesterEmail == AppSession.ServiceUnit.UserServiceUnitID);
//}
}
t.es.Distinct = true;
DataTable dTask = t.LoadDataTable();
storeNeedApproval.DataSource = dTask;
storeNeedApproval.DataBind();
}
public void storeTask_ReadData(object sender, StoreReadDataEventArgs e)
{
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.ConfirmAsFinishDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, t.RequesterEmail, t.RequesterPhone);
//tD.DetailID,tD.DetailType,tD.UserID,tD.InsertDate,tD.Description.As("Comment"),tD.StartTime,tD.StopTime,u.Username);
//t.RightJoin(tD).On(t.TaskID == tD.TaskID);
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
if (!(AppSession.ServiceUnit.UserServiceUnitID == "HIT" || AppSession.ServiceUnit.UserServiceUnitID == "IT"))
{
t.Where(t.RequesterEmail == AppSession.ServiceUnit.UserServiceUnitID | t.RequesterPhone == AppSession.ServiceUnit.UserServiceUnitID);
}
if (!X.IsAjaxRequest)
{
t.Where(t.Status == "New");
}
}
//t.InnerJoin(u).On(t.AssignedRoleID == u.UserID);
t.es.Distinct = true;
//t.OrderBy(t.TaskID.Ascending);
DataTable dTask = t.LoadDataTable();
storeTask.DataSource = dTask;
storeTask.DataBind();
}
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 btnSearch_Click()
{
if (string.IsNullOrEmpty(cmbStatus.SelectedItem.Value))
{
return;
}
if (AppSession.ServiceUnit.UserServiceUnitID == null)
{
return;
}
ADefHelpDeskTasksQuery t = new ADefHelpDeskTasksQuery("a");
ADefHelpDeskTaskDetailsQuery tD = new ADefHelpDeskTaskDetailsQuery("b");
ADefHelpDeskUsersQuery u = new ADefHelpDeskUsersQuery("c");
//RequesterEmail == Requestor Service Unit
//RequesterPhone == Destination Service Unit
//t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, u.Username);
t.Select(t.TaskID, t.Status, t.DueDate, t.CreatedDate, t.ConfirmAsFinishDate, t.AssignedRoleID, t.Description, t.RequesterUserID, t.RequesterName, t.RequesterEmail, t.RequesterPhone);
//t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%") && (t.RequesterEmail == Session["ServiceUnit"].ToString() || t.RequesterPhone == Session["ServiceUnit"].ToString()));
//t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%"));
if (!string.IsNullOrEmpty(txtSearch.Text.Trim()))
{
t.Where(t.Description.Like("%" + txtSearch.Text + "%"));
}
//|| t.Description.Like("%" + txtSearch.Text + "%") || (t.RequesterEmail == Session["ServiceUnit"].ToString() | t.RequesterPhone == Session["ServiceUnit"].ToString()));
if (AppSession.ServiceUnit.UserServiceUnitID != null)
{
if (!(AppSession.ServiceUnit.UserServiceUnitID == "HIT" || AppSession.ServiceUnit.UserServiceUnitID == "IT"))
{
t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%") && t.Description.Like("%" + txtSearch.Text + "%") && (t.RequesterEmail == Session["ServiceUnitID"].ToString() | t.RequesterPhone == AppSession.ServiceUnit.UserServiceUnitID));
}
else
{
t.Where(t.Status.Like("%" + cmbStatus.SelectedItem.Value + "%"));
}
}
else
{
Session.Abandon();
Session.RemoveAll();
FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();
}
//t.InnerJoin(u).On(t.AssignedRoleID == u.UserID);
t.es.Distinct = true;
DataTable dTask = t.LoadDataTable();
this.grdTask.Store.Primary.DataSource = dTask;
this.grdTask.Store.Primary.DataBind();
storeTask.DataSource = dTask;
storeTask.DataBind();
}
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");
}
