public bool GetCommand(List <DbUser> user, int stream_id)
{
FindUser tempUser = new FindUser();
IWriteCommand cmd = new WriteCommand();
DbUser deluser = new DbUser();
bool result = false;
try
{
string username = user[0].Username;
deluser = tempUser.GetUserByUsername(username);
if (deluser.UserId == 0)
{
return(result);
}
else
{
string cmdString = "sp_del_user_and_constraints(" + deluser.UserId + ")";
cmd.SetCommand(cmdString);
if (cmd.Execute())
{
Console.WriteLine(cmdString);
result = true;
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(result);
}
private string Read(string username)
{
FindUser user = new FindUser();
string password = "";
if (user.GetUserByUsername(username).Username == username)
{
string cmdString = "SELECT password FROM FDMUser WHERE FDMUSER.Username = '******'";
IReadOneCommand cmd = new ReadOneCommand();
password = cmd.Execute(cmdString).ToString();
}
return(password);
}
public List <DbJob> CheckJobExists(string username)
{
FindUser tempUser = new FindUser();
DbUser deluser = new DbUser();
DbJob job = new DbJob();
MyJobs jobs = new MyJobs();
List <DbJob> jobcount = new List <DbJob>();
try
{
deluser = tempUser.GetUserByUsername(username);
if (deluser.TypeId == 1)
{
job.UserId = deluser.UserId;
jobcount = jobs.Execute(job);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(jobcount);
}