public ActionResult SaveTask(tbl_UserTask model)
{
if (UserPermissionManager.EditTask(model))
{
return(JavaScript("{\"status\":1}"));
}
else
{
return(JavaScript("{\"status\":0}"));
}
}
public static bool EditTask(tbl_UserTask model)
{
if (model.ID <= 0)
{
return(DALUserPermission.AddTask(model));
}
else
{
return(DALUserPermission.UpdateTask(model));
}
}
public ActionResult TaskEdit(string appType = "1", string id = "0")
{
if (id == "0")
{
return(View(new tbl_UserTask()
{
APPType = Convert.ToInt32(appType)
}));
}
else
{
tbl_UserTask model = UserPermissionManager.GetTask(id);
return(View(model));
}
}
public static bool AddTask(tbl_UserTask model)
{
string sql = "INSERT INTO Gungnir..tbl_UserTask VALUES(@TaskName,@Description,@APPType,@APPHandler,@APPConnect)";
var conn = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(conn))
{
conn = SecurityHelp.DecryptAES(conn);
}
using (var dbhelper = new SqlDbHelper(conn))
{
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@TaskName", model.TaskName.Trim() ?? null);
cmd.Parameters.AddWithValue("@Description", model.Description.Trim() ?? null);
cmd.Parameters.AddWithValue("@APPType", model.APPType);
cmd.Parameters.AddWithValue("@APPHandler", model.APPHandler.Trim() ?? null);
cmd.Parameters.AddWithValue("@APPConnect", model.APPConnect.Trim() ?? null);
return(dbhelper.ExecuteNonQuery(cmd) > 0);
}
}
public static bool UpdateTask(tbl_UserTask model)
{
string sql = @"
UPDATE Gungnir..tbl_UserTask SET [Description]=@Description, APPType=@APPType,APPHandler=@APPHandler,APPConnect=@APPConnect
WHERE ID=@ID";
var conn = ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(conn))
{
conn = SecurityHelp.DecryptAES(conn);
}
using (var dbhelper = new SqlDbHelper(conn))
{
SqlCommand cmd = new SqlCommand(sql);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Description", model.Description.Trim() ?? null);
cmd.Parameters.AddWithValue("@APPType", model.APPType);
cmd.Parameters.AddWithValue("@APPHandler", model.APPHandler.Trim() ?? null);
cmd.Parameters.AddWithValue("@APPConnect", model.APPConnect.Trim() ?? null);
cmd.Parameters.AddWithValue("@ID", model.ID);
return(dbhelper.ExecuteNonQuery(cmd) > 0);
}
}
