private void RaiseButtonCanExecuteEvent()
{
AppraisalCommand.RaiseCanExecuteChanged();
UsersCommand.RaiseCanExecuteChanged();
ReportCommand.RaiseCanExecuteChanged();
SetupCommand.RaiseCanExecuteChanged();
}
public static void Set(DataRow usr)
{
MFranchise f = new MFranchise();
String connString = Properties.Settings.Default.FAFOS;
SqlConnection con = new SqlConnection(connString);
SqlCommand UsersCommand;
int n = usr.ItemArray.Length;
for (int i = 0; i < n; i++)
{
if (usr[i].ToString() == "")
{
usr[i] = "NULL";
}
}
if (usr["usrIDCol"].ToString() == "NULL") // Create new User
{
string newID = f.getNewID("user_id", "[User]"); // assign user id
List <Bitmap> piclist = LoadImages();
string newPicID = piclist.Count.ToString();
piclist.Add(Properties.Resources.DefaultProPic);
SaveImages(piclist);
List <Bitmap> test = LoadImages();
UsersCommand = new SqlCommand("INSERT INTO [User] VALUES (" + newID + ", '"
+ usr["fName"].ToString() + "', '"
+ usr["lName"].ToString() + "', '"
+ usr["mName"].ToString() + "', '"
+ usr["usrName"].ToString() + "', '"
+ usr["passSetCol"].ToString() + "', "
+ "'<empty>','<empty>','<empty>','<empty>','<empty>','<empty>','<empty>','<empty>', '"
+ usr["hqCol"].ToString() + "', '"
+ usr["adminCol"].ToString() + "', "
+ usr["PerOwnCol"].ToString()
+ ",1,1,1, "
+ Properties.Settings.Default.FranchiseeID + ", "
+ newPicID + ")", con);
}
else
{
UsersCommand = new SqlCommand("UPDATE [User] SET first_nm = '" + usr["fName"].ToString() +
"', last_nm = '" + usr["lName"].ToString() +
"', middle_nm = '" + usr["mName"].ToString() +
"', username = '******', password = '******', hq_user = '******', admin_user = '******', percentage_ownership = " + usr["PerOwnCol"].ToString() +
" WHERE user_id = " + usr["usrIDCol"].ToString(), con);
}
con.Open();
UsersCommand.ExecuteNonQuery();
con.Close();
}
public IResponse ProcessMessage(IRequest message)
{
var command = message.Command;
var personId = ((Person)message.Author).TelegramId;
if (!UsersActiveSessions.ContainsKey(personId) || UsersActiveSessions[personId] == null)
{
if (EventCommands.ContainsKey(command))
{
if (!UsersActiveSessions.ContainsKey(personId))
{
UsersCommand.Add(personId, GetSessionCommand());
UsersActiveSessions.Add(personId, UsersCommand[personId][command]);
}
else
{
UsersActiveSessions[personId] = UsersCommand[personId][command];
}
}
else
{
return(new ButtonResponse(
"No such command implemented!",
EventCommands.Keys.ToArray(), ResponseStatus.Abort));
}
}
try
{
var response = UsersActiveSessions[personId].Execute(message);
if (response.Status == ResponseStatus.Expect)
{
return(response);
}
UsersActiveSessions[personId] = null;
return(new ButtonResponse(response.Text, EventCommands.Keys.ToArray(), ResponseStatus.Abort));
}
catch (ArgumentException)
{
return(new ButtonResponse(
"Incorrect command arguments!",
EventCommands.Keys.ToArray(), ResponseStatus.Abort));
}
}
