private void GetDDLScenarioRole(HttpContext context)
{
string FK_S_ID = context.Request["S_ID"];
BLL.ScenarioRole bll = new BLL.ScenarioRole();
DataSet ds = new DataSet();
if (!string.IsNullOrEmpty(FK_S_ID))
{
ds = bll.GetList("SR_FK_S_ID=" + FK_S_ID);
}
else
{
ds = bll.GetList("SR_FK_S_ID=0");
}
List <Model.ScenarioRoleForDDL> list = new List <Model.ScenarioRoleForDDL>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(new Model.ScenarioRoleForDDL()
{
SR_ID = Convert.ToInt32(dr["SR_ID"]),
SR_RoleTitle = dr["SR_RoleTitle"].ToString()
});
}
JavaScriptSerializer jss = new JavaScriptSerializer();
string strJson = jss.Serialize(list);
context.Response.Write(strJson);
}
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");
}
}
private void DeleteScenarioRole(HttpContext context)
{
BLL.ScenarioRole bll = new BLL.ScenarioRole();
if (bll.Delete(Convert.ToInt32(context.Request["SR_ID"]), Convert.ToInt32(context.Request["SR_FK_S_ID"])))
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
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");
}
}
private void AddScenarioRoleBatch(HttpContext context)
{
int SR_FK_S_ID = int.Parse(context.Request["SR_FK_S_ID"]);
int SR_FK_TT_ID = int.Parse(context.Request["SR_FK_TT_ID"]);
int User_ID = int.Parse(context.Request["User_ID"]);
string JsonScenarioRole = context.Request["JsonSenarioRole"].ToString();
string strJson = string.Format("[{0}]", JsonScenarioRole);
JavaScriptSerializer jss = new JavaScriptSerializer();
List <Model.ScenarioRoleForJson> list = jss.Deserialize <List <Model.ScenarioRoleForJson> >(strJson);
BLL.ScenarioRole bll = new BLL.ScenarioRole();
bool AddRes = bll.AddBatch(list, SR_FK_S_ID, SR_FK_TT_ID, User_ID);
if (AddRes)
{
context.Response.Write("success");
}
else
{
context.Response.Write("fail");
}
}
