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);
}
public bool GetCommand(List <DbUser> user, int stream_id)
{
string cmdString = "sp_add_user(" + user[0].TypeId + ",'" + user[0].Username + "','" +
user[0].Password + "','" +
user[0].FirstName + "','" + user[0].LastName + "','" + user[0].Email + "','" +
user[0].Location + "'," + stream_id + ")";
IWriteCommand cmd = new WriteCommand();
cmd.SetCommand(cmdString);
if (cmd.Execute())
{
return(true);
}
return(false);
}
public bool GetCommand(List <string> skills, int skill_id)
{
IWriteCommand cmd = new WriteCommand();
foreach (string skill in skills)
{
string cmdString = "sp_add_jobSkill(" + skill_id + ")";
cmd.SetCommand(cmdString);
cmd.Execute();
}
if (cmd.Execute() == true)
{
return(true);
}
return(false);
}
