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); }