private string UploadUserImage(string sourceImage)
{
//Copy the source image to
var currentDirectory = Directory.GetCurrentDirectory();
var source = new FileInfo(sourceImage);
string destination = String.Format(@"{0}\{1}\{2}", Directory.GetCurrentDirectory(),
GymSoftConfigurationManger.GetUserDefaultPictureDirectory().ToString(),
source.Name);
source.CopyTo(destination, true);
//var baseUri = new Uri(currentDirectory);
//var fullUri = new Uri(destination);
//var relativeUri = fullUri.MakeRelativeUri(baseUri);
//var directoryFormat = relativeUri.OriginalString.Replace('/', Path.DirectorySeparatorChar);
//var relativeDestination = String.Format(@"{0}\{1}\{2}", directoryFormat,
// GymSoftConfigurationManger.GetUserDefaultPictureDirectory()
// .ToString(), source.Name);
//return destination;
var relativeDestination = source.Name;
return(relativeDestination);
}
public RuntimeBusinessUnitService()
{
ConnectionString = GymSoftConfigurationManger.GetDatabaseConnection();
MySqlConnection = new MySqlConnection(ConnectionString);
MySqlCommand = MySqlConnection.CreateCommand();
MySqlDataAdapter = new MySqlDataAdapter();
BusinessUnitDataSet = new DataSet();
}
public RuntimeUserService()
{
ConnectionString = GymSoftConfigurationManger.GetDatabaseConnection();
MySqlConnection = new MySqlConnection(ConnectionString);
MySqlCommand = MySqlConnection.CreateCommand();
MySqlDataAdapter = new MySqlDataAdapter();
UserDataSet = new DataSet();
DefaultPictureDirectory = GymSoftConfigurationManger.GetUserDefaultPictureDirectory();
}
private int AddNewUser(User newUser, int buId = 1, int userId = 1)
{
//Upload image
var currentPath = newUser.PhotoPath.DataValue;
newUser.PhotoPath.DataValue = currentPath.Equals(GymSoftConfigurationManger.GetDefaultUserPicture().ToString())
? currentPath : UploadUserImage(currentPath);
MySqlCommand.CommandType = CommandType.StoredProcedure;
MySqlCommand.CommandText = AddNewUserStoredProcedure;
MySqlCommand.Parameters.Clear();
MySqlCommand.Parameters.AddWithValue("buid", buId);
MySqlCommand.Parameters.AddWithValue("userid", userId);
MySqlCommand.Parameters.AddWithValue("fname", newUser.FirstName.DataValue);
MySqlCommand.Parameters.AddWithValue("mname", newUser.MiddleName.DataValue);
MySqlCommand.Parameters.AddWithValue("lname", newUser.LastName.DataValue);
MySqlCommand.Parameters.AddWithValue("dob", newUser.DateOfBirth.DataValue);
MySqlCommand.Parameters.AddWithValue("email", newUser.EmailAddress.DataValue);
MySqlCommand.Parameters.AddWithValue("num1", newUser.ContactNum1.DataValue);
MySqlCommand.Parameters.AddWithValue("num2", newUser.ContactNum2.DataValue);
MySqlCommand.Parameters.AddWithValue("num3", newUser.ContactNum3.DataValue);
MySqlCommand.Parameters.AddWithValue("add1", newUser.Address1.DataValue);
MySqlCommand.Parameters.AddWithValue("add2", newUser.Address2.DataValue);
MySqlCommand.Parameters.AddWithValue("add3", newUser.Address3.DataValue);
MySqlCommand.Parameters.AddWithValue("par", newUser.Parish.DataValue);
MySqlCommand.Parameters.AddWithValue("sex", newUser.Gender.DataValue);
MySqlCommand.Parameters.AddWithValue("photo", newUser.PhotoPath.DataValue);
MySqlCommand.Parameters.AddWithValue("uname", newUser.UserName.DataValue);
MySqlCommand.Parameters.AddWithValue("pwd", newUser.Password.DataValue);
MySqlCommand.Parameters.AddWithValue("status", newUser.Status.DataValue);
MySqlCommand.Parameters.AddWithValue("jt", newUser.JobTitle.DataValue);
MySqlCommand.Parameters.Add(new MySqlParameter("@newUserId", MySqlDbType.Int32));
MySqlCommand.Parameters["@newUserId"].Direction = ParameterDirection.Output;
MySqlCommand.Parameters.Add(new MySqlParameter("@result", MySqlDbType.Int32));
MySqlCommand.Parameters["@result"].Direction = ParameterDirection.Output;
MySqlCommand.Connection.Open();
MySqlCommand.ExecuteNonQuery();
MySqlCommand.Connection.Close();
int newUserId = (int)MySqlCommand.Parameters["@newUserId"].Value;
//Update photoPath with new UserId
// newUser.PhotoPath.DataValue = photoPath;
//UpdateUser(newUser);
return((int)MySqlCommand.Parameters["@newUserId"].Value);
}
private int UpdateUser(User user, int buId = 1, int userId = 1)
{
var currentPath = user.PhotoPath.DataValue;
var defaultPhotoPath = GymSoftConfigurationManger.GetDefaultUserPicture().ToString();
if (!currentPath.Equals(defaultPhotoPath))
{
currentPath = UploadUserImage(currentPath);
}
MySqlCommand.CommandType = CommandType.StoredProcedure;
MySqlCommand.CommandText = UpdateUserStoredProcedure;
MySqlCommand.Parameters.Clear();
MySqlCommand.Parameters.AddWithValue("buid", buId);
MySqlCommand.Parameters.AddWithValue("userid", userId);
/*buid int, userid int, personid int, userName VARCHAR(1024),
* passwd VARCHAR(1024),stat VARCHAR(1024), jt VARCHAR(1024),
* fname VARCHAR(1024), mname VARCHAR(1024), lname VARCHAR(1024),
* dob date, email VARCHAR(1024),num1 VARCHAR(20), num2 VARCHAR(20),
* num3 VARCHAR(20), add1 VARCHAR(1024), add2 VARCHAR(1024), add3 VARCHAR(1024),
* par VARCHAR(1024), sex VARCHAR(1024), photo VARCHAR(1024), OUT result int*/
MySqlCommand.Parameters.AddWithValue("persid", user.UserId.DataValue);
MySqlCommand.Parameters.AddWithValue("fname", user.FirstName.DataValue);
MySqlCommand.Parameters.AddWithValue("mname", user.MiddleName.DataValue);
MySqlCommand.Parameters.AddWithValue("lname", user.LastName.DataValue);
MySqlCommand.Parameters.AddWithValue("dob", user.DateOfBirth.DataValue);
MySqlCommand.Parameters.AddWithValue("email", user.EmailAddress.DataValue);
MySqlCommand.Parameters.AddWithValue("num1", user.ContactNum1.DataValue);
MySqlCommand.Parameters.AddWithValue("num2", user.ContactNum2.DataValue);
MySqlCommand.Parameters.AddWithValue("num3", user.ContactNum3.DataValue);
MySqlCommand.Parameters.AddWithValue("add1", user.Address1.DataValue);
MySqlCommand.Parameters.AddWithValue("add2", user.Address2.DataValue);
MySqlCommand.Parameters.AddWithValue("add3", user.Address3.DataValue);
MySqlCommand.Parameters.AddWithValue("par", user.Parish.DataValue);
MySqlCommand.Parameters.AddWithValue("sex", user.Gender.DataValue);
MySqlCommand.Parameters.AddWithValue("photo", currentPath);
MySqlCommand.Parameters.AddWithValue("stat", user.Status.DataValue);
MySqlCommand.Parameters.AddWithValue("jt", user.JobTitle.DataValue);
MySqlCommand.Parameters.Add(new MySqlParameter("@result", MySqlDbType.Int32));
MySqlCommand.Parameters["@result"].Direction = ParameterDirection.Output;
MySqlCommand.Connection.Open();
MySqlCommand.ExecuteNonQuery();
MySqlCommand.Connection.Close();
return((int)MySqlCommand.Parameters["@result"].Value);
}
private string UploadUserImage(string sourceImage)
{
//Copy the source image to
var currentDirectory = Directory.GetCurrentDirectory();
var source = new FileInfo(sourceImage);
string destination = String.Format(@"{0}\{1}\{2}", Directory.GetCurrentDirectory(),
GymSoftConfigurationManger.GetUserDefaultPictureDirectory().ToString(),
source.Name);
//Copy file only if sourceImageDirectory is not the same as destinationDirectory
var destinationDirectory = String.Format(@"{0}\{1}", Directory.GetCurrentDirectory(),
GymSoftConfigurationManger.GetUserDefaultPictureDirectory().ToString());
var sourceImageDirectory = sourceImage.Substring(0, sourceImage.LastIndexOf('\\'));
if (!sourceImageDirectory.Equals(destinationDirectory, StringComparison.CurrentCultureIgnoreCase))
{
source.CopyTo(destination, true);
}
var relativeDestination = source.Name;
return(relativeDestination);
}
