private void AddScenarioRole(HttpContext context)
{
//SR_RoleTitle: SR_RoleTitle, SR_CaseNum: SR_CaseNum,
// SR_SR_AssignedUser: SR_SR_AssignedUser, SR_AssignedUserName: SR_AssignedUserName,
// SR_FK_S_ID: SR_FK_S_ID, SR_FK_TT_ID: SR_FK_TT_ID
Model.ScenarioRole model = new Model.ScenarioRole();
BLL.ScenarioRole bll = new BLL.ScenarioRole();
model.SR_FK_S_ID = Convert.ToInt32(context.Request["SR_FK_S_ID"]);
model.SR_FK_TT_ID = Convert.ToInt32(context.Request["SR_FK_TT_ID"]);
model.SR_RoleTitle = context.Request["SR_RoleTitle"];
model.SR_CaseNum = context.Request["SR_CaseNum"];
model.SR_AssignedUser = context.Request["SR_AssignedUser"];
model.SR_AssignedUserName = context.Request["SR_AssignedUserName"];
model.SR_CreateUser = context.Request["User_ID"];
model.SR_CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
if (context.Request["TT_TaskStatus"] != "Pending")
{
model.SR_Status = "Pending";
}
else
{
model.SR_Status = "";
}
model.SR_IsDelete = "0";
if (bll.Add(model) > 0)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
public int Add(Model.ScenarioRole model)
{
StringBuilder strSql = new StringBuilder();
string DateTimeNow = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
strSql.Append("insert into ScenarioRole (SR_FK_S_ID,SR_FK_TT_ID,SR_RoleTitle,SR_CaseNum,SR_AssignedUser,SR_AssignedUserName,SR_CasePassed,SR_CaseNA,SR_CaseFailed,SR_CaseRedmond,SR_CompleteProgress,SR_CreateUser,SR_Comments,SR_CreateDate,SR_Status,SR_IsDelete) values (");
strSql.Append(string.Format("{0},{1},'{2}',{3},'{4}','{5}','0','0','0','0','0','{6}','{7}','{8}','{9}','{10}');", model.SR_FK_S_ID, model.SR_FK_TT_ID, model.SR_RoleTitle, model.SR_CaseNum, model.SR_AssignedUser, model.SR_AssignedUserName, model.SR_CreateUser, model.SR_Comments, model.SR_CreateDate, model.SR_Status, model.SR_IsDelete));
return(DbHelperSQL.ExecuteSql(strSql.ToString()));
}
public bool Update(Model.ScenarioRole model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ScenarioRole set ");
strSql.Append(string.Format("SR_AssignedUser='******',SR_AssignedUserName='******',SR_RoleTitle='{2}',", model.SR_AssignedUser, model.SR_AssignedUserName, model.SR_RoleTitle));
strSql.Append(string.Format("SR_CaseNum='{0}' where SR_ID={1}", model.SR_CaseNum, model.SR_ID));
int UpdateRes = DbHelperSQL.ExecuteSql(strSql.ToString());
if (UpdateRes > 0)
{
return(true);
}
else
{
return(false);
}
}
private void UpdateScenarioRole(HttpContext context)
{
Model.ScenarioRole model = new Model.ScenarioRole();
BLL.ScenarioRole bll = new BLL.ScenarioRole();
model.SR_ID = Convert.ToInt32(context.Request["SR_ID"]);
//model.SR_FK_S_ID = Convert.ToInt32(context.Request["SR_FK_S_ID"]);
//model.SR_FK_TT_ID = Convert.ToInt32(context.Request["SR_FK_TT_ID"]);
model.SR_RoleTitle = context.Request["SR_RoleTitle"];
model.SR_CaseNum = context.Request["SR_CaseNum"];
model.SR_AssignedUser = context.Request["SR_AssignedUser"];
model.SR_AssignedUserName = context.Request["SR_AssignedUserName"];
if (bll.Update(model))
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
public bool Update(Model.ScenarioRole model)
{
return(dal.Update(model));
}
public int Add(Model.ScenarioRole model)
{
return(dal.Add(model));
}
