private void UpdateTaskListTotal(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
Model.TaskTotal model = new Model.TaskTotal();
model = bll.GetModel(Convert.ToInt32(context.Request["TT_ID"]));
model.TT_ID = Convert.ToInt32(context.Request["TT_ID"]);
model.TT_Release = context.Request["TT_Release"];
model.TT_BuildType = context.Request["TT_BuildType"];
model.TT_TaskStyle = context.Request["TT_TaskStyle"];
model.TT_TaskType = context.Request["TT_TaskType"];
model.TT_CU = context.Request["TT_CU"];
model.TT_BuildNum = context.Request["TT_BuildNum"];
model.TT_CaseTotalNum = context.Request["TT_CaseTotalNum"];
model.TT_DateStart = Convert.ToDateTime(context.Request["TT_DateStart"]).ToString("yyyy-MM-dd");
model.TT_DateEnd = Convert.ToDateTime(context.Request["TT_DateEnd"]).ToString("yyyy-MM-dd");
model.TT_Comments = context.Request["TT_Comments"];
model.TT_ServerClient = context.Request["TT_ServerClient"];
bool UpdateResult = bll.Update(model);
if (UpdateResult)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
private void DeleteTaskListTotal(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
bool DelResult = bll.Delete(Convert.ToInt32(context.Request["TT_ID"]));
if (DelResult)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
private void StartTaskTotal(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
bool UpdateRes = bll.StartTaskTotal(Convert.ToInt32(context.Request["TT_ID"]));
if (UpdateRes)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
private void QueryTaskListTotal(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
string keyWord = context.Request["keyWord"];
DataSet ds = new DataSet();
if (keyWord == "OnlyHaveScenario")
{
ds = bll.GetList("TT_HaveScenario='Yes'");
}
else
{
ds = bll.GetList("");
}
List <Model.TaskTotalForDisplay> list = new List <Model.TaskTotalForDisplay>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.TaskTotalForDisplay()
{
TT_ID = Convert.ToInt32(dr["TT_ID"]),
TT_Title = dr["TT_Title"].ToString(),
//TT_Release = dr["TT_Release"].ToString(),
//TT_CU = dr["TT_CU"].ToString(),
//TT_BuildType = dr["TT_BuildType"].ToString(),
//TT_BuildNum = dr["TT_BuildNum"].ToString(),
//TT_TaskType = dr["TT_TaskType"].ToString(),
//TT_CaseTotalNum = dr["TT_CaseTotalNum"].ToString(),
//TT_CaseRealRunNum = dr["TT_CaseRealRunNum"].ToString(),
//TT_Date = ((DateTime)dr["TT_DateStart"]).ToString("dd/MM/yyyy") + " - " + ((DateTime)dr["TT_DateEnd"]).ToString("dd/MM/yyyy"),
TT_Date = Convert.ToDateTime(dr["TT_DateStart"]).ToString("dd/MM/yyyy") + " - " + Convert.ToDateTime(dr["TT_DateEnd"]).ToString("dd/MM/yyyy"),
TT_TaskStyle = dr["TT_TaskStyle"].ToString(),
//TT_BugIssueNum = dr["TT_BugIssueNum"].ToString(),
//TT_ReportLink = dr["TT_ReportLink"].ToString(),
//TT_Comments = dr["TT_Comments"].ToString(),
TT_HaveScenario = dr["TT_HaveScenario"].ToString(),
//TT_CreateDate = ((DateTime)dr["TT_CreateDate"]).ToString("yyyy-MM-dd HH:mm:ss")
TT_TaskProgress = dr["TT_TaskProgress"].ToString() + "%",
TT_TaskStatus = dr["TT_TaskStatus"].ToString()
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = string.Format("{{\"rows\":{0}}}", jss.Serialize(list));
context.Response.Write(strJson);
}
private void EndTaskTotal(HttpContext context)
{
int TT_ID = Convert.ToInt32(context.Request["TT_ID"]);
string TT_TaskProgress = context.Request["TT_TaskProgress"];
string TT_CompleteReason = context.Request["TT_CompleteReason"];
BLL.TaskTotal bll = new BLL.TaskTotal();
bool UpdateRes = bll.EndTaskTotal(TT_ID, TT_TaskProgress, TT_CompleteReason);
if (UpdateRes)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
private void GetDDLTaskTotalInprogress(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
DataSet ds = bll.GetList("TT_TaskStatus='InProgress'");
List <Model.TaskTotalForDLL> list = new List <Model.TaskTotalForDLL>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.TaskTotalForDLL()
{
TT_ID = Convert.ToInt32(dr["TT_ID"]),
TT_Title = dr["TT_Title"].ToString()
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);//.TrimStart('[').TrimEnd(']');
context.Response.Write(strJson);
}
private void GetTaskTotalInfoSingle(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
Model.TaskTotal model = new Model.TaskTotal();
model = bll.GetModel(Convert.ToInt32(context.Request["id"]));
List <Model.TaskTotal> list = new List <Model.TaskTotal>();
list.Add(new Model.TaskTotal
{
TT_ID = model.TT_ID,
TT_Release = model.TT_Release,
TT_CU = model.TT_CU,
TT_BuildType = model.TT_BuildType,
TT_BuildNum = model.TT_BuildNum,
TT_TaskType = model.TT_TaskType,
TT_CaseTotalNum = model.TT_CaseTotalNum,
TT_CaseRealRunNum = model.TT_CaseRealRunNum,
TT_DateStart = Convert.ToDateTime(model.TT_DateStart).ToString("MM/dd/yyyy"),
TT_DateEnd = Convert.ToDateTime(model.TT_DateEnd).ToString("MM/dd/yyyy"),
TT_Date = Convert.ToDateTime(model.TT_DateStart).ToString("dd/MM/yyyy") + " - " + Convert.ToDateTime(model.TT_DateEnd).ToString("dd/MM/yyyy"),
TT_TaskStyle = model.TT_TaskStyle,
TT_BugIssueNum = model.TT_BugIssueNum,
TT_ReportLink = model.TT_ReportLink,
TT_Comments = model.TT_Comments,
TT_CreateDate = model.TT_CreateDate,
TT_TaskProgress = model.TT_TaskProgress + '%',
TT_TaskStatus = model.TT_TaskStatus,
TT_HaveScenario = model.TT_HaveScenario,
TT_TimeStart = string.IsNullOrEmpty(model.TT_TimeStart) ? "Task Not Start" : model.TT_TimeStart,
TT_TimeEnd = string.IsNullOrEmpty(model.TT_TimeEnd) ? "Task Not End" : model.TT_TimeEnd,
TT_TimeUsed = Minute2Day(model.TT_TimeUsed),
TT_Title = model.TT_Title,
TT_CompleteReason = model.TT_CompleteReason,
TT_ServerClient = model.TT_ServerClient
});
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
strJson = strJson.Replace("[", "").Replace("]", "");
context.Response.Write(strJson);
}
private void QueryTaskListTotalSimple(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
int ListItemNum = Convert.ToInt32(context.Request["ListItemNum"]);
string keyWord = context.Request["keyWord"];
DataSet ds = bll.GetList(ListItemNum, string.Format("TT_Title like '%{0}%'", keyWord));
List <Model.TaskTotalForDisplay> list = new List <Model.TaskTotalForDisplay>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.TaskTotalForDisplay()
{
TT_ID = Convert.ToInt32(dr["TT_ID"]),
TT_Title = dr["TT_Title"].ToString(),
TT_Date = Convert.ToDateTime(dr["TT_DateStart"]).ToString("dd/MM/yyyy") + " - " + Convert.ToDateTime(dr["TT_DateEnd"]).ToString("dd/MM/yyyy"),
TT_TaskStatus = dr["TT_TaskStatus"].ToString()
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
private void GetDDLTaskTotalSearch(HttpContext context)
{
BLL.TaskTotal bll = new BLL.TaskTotal();
DataSet ds = new DataSet();
string strKeyWord = context.Request["keyword"];
if (!string.IsNullOrEmpty(strKeyWord))
{
if (strKeyWord == "InProgress")
{
ds = bll.GetList("TT_TaskStatus='InProgress'");
}
else
{
ds = bll.GetList("TT_Title like '%" + strKeyWord + "%'");
}
}
else
{
ds = bll.GetList("TT_TaskStatus='InProgress'");
}
List <Model.TaskTotalForDLL> list = new List <Model.TaskTotalForDLL>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.TaskTotalForDLL()
{
TT_ID = Convert.ToInt32(dr["TT_ID"]),
TT_Title = dr["TT_Title"].ToString(),
TT_TaskStatus = dr["TT_TaskStatus"].ToString()
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
private void AddTaskListTotal(HttpContext context)
{
//throw new NotImplementedException();
BLL.TaskTotal bll = new BLL.TaskTotal();
Model.TaskTotal model = new Model.TaskTotal();
model.TT_Release = context.Request["TT_Release"].ToString();
model.TT_CU = context.Request["TT_CU"].ToString();
model.TT_BuildType = context.Request["TT_BuildType"].ToString();
model.TT_BuildNum = context.Request["TT_BuildNum"].ToString();
model.TT_TaskType = context.Request["TT_TaskType"].ToString();
model.TT_CaseTotalNum = context.Request["TT_CaseTotalNum"].ToString();
model.TT_CaseRealRunNum = "0";
model.TT_DateStart = Convert.ToDateTime(context.Request["TT_DateStart"]).ToString("yyyy-MM-dd");
model.TT_DateEnd = Convert.ToDateTime(context.Request["TT_DateEnd"]).ToString("yyyy-MM-dd");
model.TT_TaskStyle = context.Request["TT_TaskStyle"].ToString();
model.TT_BugIssueNum = "999999,888888,777777";
model.TT_ReportLink = "http://TestLink.com";
model.TT_Comments = context.Request["TT_Comments"].ToString();
model.TT_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
model.TT_Title = context.Request["TT_Title"].ToString();
model.TT_TaskProgress = "0";
model.TT_TaskStatus = "Pending";
model.TT_HaveScenario = "No";
model.TT_ServerClient = context.Request["TT_ServerClient"].ToString();
int iRows = bll.Add(model);
if (iRows > 0)
{
context.Response.Write(iRows);
}
else
{
context.Response.Write("fail");
}
}
