private void InitilizeCurrentUser()
{
if (service.isConnencted())
{
System.Drawing.Drawing2D.GraphicsPath gp1 = new System.Drawing.Drawing2D.GraphicsPath();
gp1.AddEllipse(0, 0, userProfilePicture1.Width - 3, userProfilePicture1.Height - 3);
Region rg1 = new Region(gp1);
userProfilePicture1.Region = rg1;
System.Drawing.Drawing2D.GraphicsPath gp2 = new System.Drawing.Drawing2D.GraphicsPath();
gp2.AddEllipse(0, 0, userProfilePicture1.Width + 60, userProfilePicture1.Height + 60);
Region rg2 = new Region(gp2);
userProfilePicture2.Region = rg2;
try
{
User session = app.getSession();
if (session.name.Contains(" "))
{
usernameLabel1.Text = session.name.Substring(0, session.name.IndexOf(" "));
usernameLabel2.Text = session.name.Substring(0, session.name.IndexOf(" "));
}
else
{
usernameLabel1.Text = session.name;
usernameLabel2.Text = session.name;
}
User user = getService.getUserByUsername(session.username);
if (user.picture != null && user.picture.Length > 0)
{
userProfilePicture1.Image = app.byteArrayToImage(user.picture);
userProfilePicture2.Image = app.byteArrayToImage(user.picture);
}
}
catch (Exception ex)
{
app.showWarning(ex.Message);
}
}
else
{
app.showWarning("Oops! Unable to connect to the database");
}
}
public int addUser(User user)
{
SSGetService getService = new SSGetService();
User numberCheck = getService.getUserByMobileNumber(user.mobile_number);
User usernameCheck = getService.getUserByUsername(user.username);
if (usernameCheck.username == null)
{
if (numberCheck.mobile_number == null)
{
using (SqlCommand command = new SqlCommand("INSERT INTO ss_users(bid,name, username, password, mobile_number,picture)VALUES(@bid,@name,@username,@password, @mobile_number,@picture)"))
{
command.Parameters.AddWithValue("@bid", user.bid);
command.Parameters.AddWithValue("@name", user.name);
command.Parameters.AddWithValue("@username", user.username);
command.Parameters.AddWithValue("@password", user.password);
command.Parameters.AddWithValue("@mobile_number", user.mobile_number);
if (user.picture != null)
{
command.Parameters.Add("@picture", SqlDbType.Image, user.picture.Length).Value = user.picture;
}
int response = service.execute(command);
if (response > 0)
{
this.addLog(new Log()
{
type = "Add User",
statement = command.CommandText,
description = "Created user " + user.name,
});
}
return(response);
}
}
else
{
return(-3);
}
}
else
{
return(-2);
}
}
