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");
}
}
public Model.TaskTotal GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from TaskTotal ");
strSql.Append("where TT_ID=@TT_ID");
SqlParameter[] parameters =
{
new SqlParameter("@TT_ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Model.TaskTotal model = new Model.TaskTotal();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
model.TT_ID = Convert.ToInt32(dr["TT_ID"]);
model.TT_Release = dr["TT_Release"].ToString();
model.TT_CU = dr["TT_CU"].ToString();
model.TT_BuildType = dr["TT_BuildType"].ToString();
model.TT_BuildNum = dr["TT_BuildNum"].ToString();
model.TT_TaskType = dr["TT_TaskType"].ToString();
model.TT_CaseTotalNum = dr["TT_CaseTotalNum"].ToString();
model.TT_CaseRealRunNum = dr["TT_CaseRealRunNum"].ToString();
model.TT_DateStart = dr["TT_DateStart"].ToString();
model.TT_DateEnd = dr["TT_DateEnd"].ToString();
model.TT_TaskStyle = dr["TT_TaskStyle"].ToString();
model.TT_BugIssueNum = dr["TT_BugIssueNum"].ToString();
model.TT_ReportLink = dr["TT_ReportLink"].ToString();
model.TT_Comments = dr["TT_Comments"].ToString();
model.TT_CreateDate = dr["TT_CreateDate"].ToString();
model.TT_TaskProgress = dr["TT_TaskProgress"].ToString();
model.TT_TaskStatus = dr["TT_TaskStatus"].ToString();
model.TT_HaveScenario = dr["TT_HaveScenario"].ToString();
model.TT_TimeStart = dr["TT_TimeStart"].ToString();
model.TT_TimeEnd = dr["TT_TimeEnd"].ToString();
model.TT_TimeUsed = dr["TT_TimeUsed"].ToString();
model.TT_Title = dr["TT_Title"].ToString();
model.TT_CompleteReason = dr["TT_CompleteReason"].ToString();
model.TT_ServerClient = dr["TT_ServerClient"].ToString();
return(model);
}
else
{
return(null);
}
}
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 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");
}
}
public bool Update(Model.TaskTotal model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TaskTotal set ");
strSql.Append("TT_Release=@TT_Release,");
strSql.Append("TT_CU=@TT_CU,");
strSql.Append("TT_BuildType=@TT_BuildType,");
strSql.Append("TT_BuildNum=@TT_BuildNum,");
strSql.Append("TT_TaskType=@TT_TaskType,");
strSql.Append("TT_CaseTotalNum=@TT_CaseTotalNum,");
strSql.Append("TT_CaseRealRunNum=@TT_CaseRealRunNum,");
strSql.Append("TT_DateStart=@TT_DateStart,");
strSql.Append("TT_DateEnd=@TT_DateEnd,");
strSql.Append("TT_TaskStyle=@TT_TaskStyle,");
strSql.Append("TT_BugIssueNum=@TT_BugIssueNum,");
strSql.Append("TT_ReportLink=@TT_ReportLink,");
strSql.Append("TT_Comments=@TT_Comments,");
strSql.Append("TT_ServerClient=@TT_ServerClient");
strSql.Append(" where TT_ID=@TT_ID");
SqlParameter[] parameters =
{
new SqlParameter("@TT_Release", SqlDbType.VarChar, 10),
new SqlParameter("@TT_CU", SqlDbType.VarChar, 10),
new SqlParameter("@TT_BuildType", SqlDbType.VarChar, 20),
new SqlParameter("@TT_BuildNum", SqlDbType.VarChar, 20),
new SqlParameter("@TT_TaskType", SqlDbType.VarChar, 20),
new SqlParameter("@TT_CaseTotalNum", SqlDbType.VarChar, 10),
new SqlParameter("@TT_CaseRealRunNum", SqlDbType.VarChar, 10),
new SqlParameter("@TT_DateStart", SqlDbType.VarChar, 10),
new SqlParameter("@TT_DateEnd", SqlDbType.VarChar, 10),
new SqlParameter("@TT_TaskStyle", SqlDbType.VarChar, 10),
new SqlParameter("@TT_BugIssueNum", SqlDbType.VarChar),
new SqlParameter("@TT_ReportLink", SqlDbType.VarChar),
new SqlParameter("@TT_Comments", SqlDbType.VarChar),
new SqlParameter("@TT_ServerClient", SqlDbType.VarChar, 20),
new SqlParameter("@TT_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.TT_Release;
parameters[1].Value = model.TT_CU;
parameters[2].Value = model.TT_BuildType;
parameters[3].Value = model.TT_BuildNum;
parameters[4].Value = model.TT_TaskType;
parameters[5].Value = model.TT_CaseTotalNum;
parameters[6].Value = model.TT_CaseRealRunNum;
parameters[7].Value = model.TT_DateStart;
parameters[8].Value = model.TT_DateEnd;
parameters[9].Value = model.TT_TaskStyle;
parameters[10].Value = model.TT_BugIssueNum;
parameters[11].Value = model.TT_ReportLink;
parameters[12].Value = model.TT_Comments;
parameters[13].Value = model.TT_ServerClient;
parameters[14].Value = model.TT_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int Add(Model.TaskTotal model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TaskTotal(");
strSql.Append("TT_Release,TT_CU,TT_BuildType,TT_BuildNum,TT_TaskType,TT_CaseTotalNum,TT_CaseRealRunNum,TT_DateStart,TT_DateEnd,TT_TaskStyle,TT_BugIssueNum,TT_ReportLink,TT_Comments,TT_CreateDate,TT_Title,TT_TaskProgress,TT_TaskStatus,TT_HaveScenario,TT_ServerClient)");
strSql.Append(" values (");
strSql.Append("@TT_Release,@TT_CU,@TT_BuildType,@TT_BuildNum,@TT_TaskType,@TT_CaseTotalNum,@TT_CaseRealRunNum,@TT_DateStart,@TT_DateEnd,@TT_TaskStyle,@TT_BugIssueNum,@TT_ReportLink,@TT_Comments,@TT_CreateDate,@TT_Title,@TT_TaskProgress,@TT_TaskStatus,@TT_HaveScenario,@TT_ServerClient)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TT_Release", SqlDbType.VarChar, 10),
new SqlParameter("@TT_CU", SqlDbType.VarChar, 10),
new SqlParameter("@TT_BuildType", SqlDbType.VarChar, 20),
new SqlParameter("@TT_BuildNum", SqlDbType.VarChar, 20),
new SqlParameter("@TT_TaskType", SqlDbType.VarChar, 20),
new SqlParameter("@TT_CaseTotalNum", SqlDbType.VarChar, 10),
new SqlParameter("@TT_CaseRealRunNum", SqlDbType.VarChar, 10),
new SqlParameter("@TT_DateStart", SqlDbType.VarChar, 10),
new SqlParameter("@TT_DateEnd", SqlDbType.VarChar, 10),
new SqlParameter("@TT_TaskStyle", SqlDbType.VarChar, 10),
new SqlParameter("@TT_BugIssueNum", SqlDbType.VarChar),
new SqlParameter("@TT_ReportLink", SqlDbType.VarChar),
new SqlParameter("@TT_Comments", SqlDbType.VarChar),
new SqlParameter("@TT_CreateDate", SqlDbType.VarChar, 20),
new SqlParameter("@TT_Title", SqlDbType.VarChar, 300),
new SqlParameter("@TT_TaskProgress", SqlDbType.VarChar, 10),
new SqlParameter("@TT_TaskStatus", SqlDbType.VarChar, 10),
new SqlParameter("@TT_HaveScenario", SqlDbType.VarChar, 5),
new SqlParameter("@TT_ServerClient", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.TT_Release;
parameters[1].Value = model.TT_CU;
parameters[2].Value = model.TT_BuildType;
parameters[3].Value = model.TT_BuildNum;
parameters[4].Value = model.TT_TaskType;
parameters[5].Value = model.TT_CaseTotalNum;
parameters[6].Value = model.TT_CaseRealRunNum;
parameters[7].Value = model.TT_DateStart;
parameters[8].Value = model.TT_DateEnd;
parameters[9].Value = model.TT_TaskStyle;
parameters[10].Value = model.TT_BugIssueNum;
parameters[11].Value = model.TT_ReportLink;
parameters[12].Value = model.TT_Comments;
parameters[13].Value = model.TT_CreateDate;
parameters[14].Value = model.TT_Title;
parameters[15].Value = model.TT_TaskProgress;
parameters[16].Value = model.TT_TaskStatus;
parameters[17].Value = model.TT_HaveScenario;
parameters[18].Value = model.TT_ServerClient;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
//return Convert.ToInt32(obj);
int TT_ID = Convert.ToInt32(obj);
bool resAddDailyTask = AddTaskDaily(TT_ID, model.TT_DateStart, model.TT_DateEnd, model.TT_CaseTotalNum);
if (resAddDailyTask)
{
return(Convert.ToInt32(TT_ID));
}
else
{
return(0);
}
}
}
public bool Update(Model.TaskTotal model)
{
return(dal.Update(model));
}
public int Add(Model.TaskTotal model)
{
return(dal.Add(model));
}
