public void AddProfile(EmployeeProfile commandDto, string imgURL, string cartoonURL)
{
string user = System.Web.HttpContext.Current.User.Identity.Name;
using (DbConnection conn = new SQLiteConnection(ConfigurationManager.ConnectionStrings["reedDirectory"].ConnectionString))
{
conn.Open();
conn.Execute(
"insert into EmployeeProfile (Department, FirstName, ImageUrl, LastName, Role, Tags, CreatedBy, CreatedOn, IsSuperUser, Extension, CartoonURL, WindowsIdentity, emailaddress, SeatingFloor, seatNo) values " +
"(@Department, @FirstName, @ImageUrl, @LastName, @Role, @Tags, @CreatedBy, @CreatedOn, @IsSuperUser, @Extension, @CartoonURL, @WindowsIdentity, @emailAddress, @SeatingFloor, @seatNo)",
new
{
Department = commandDto.Department,
FirstName = commandDto.FirstName.Replace("'","''"),
ImageUrl = imgURL,
LastName = commandDto.LastName.Replace("'", "''"),
Role = commandDto.Role,
Tags = !string.IsNullOrEmpty(commandDto.Tags) ? commandDto.Tags.Replace("'", "''"): "",
CreatedBy = user.Remove(0, 11),
CreatedOn = commandDto.CreatedOn,
IsSuperUser = false,
Extension = !string.IsNullOrEmpty(commandDto.Extension) ? commandDto.Extension.Replace("'", "''") : "",
CartoonURL = cartoonURL,
windowsIdentity = user,
emailAddress = commandDto.EmailAddress,
SeatingFloor = commandDto.SeatingFloor,
seatNo = commandDto.SeatNo
});
conn.Close();
}
}
public void UpdateProfile(EmployeeProfile commandDto, string imgURL, string cartoonURL)
{
string user = System.Web.HttpContext.Current.User.Identity.Name;
using (DbConnection conn = new SQLiteConnection(ConfigurationManager.ConnectionStrings["reedDirectory"].ConnectionString))
{
conn.Open();
conn.Execute("Update EmployeeProfile set Department=@Department, " +
"FirstName=@FirstName, " +
"ImageUrl=@ImageUrl, " +
"LastName=@LastName, " +
"Role=@Role, " +
"Tags=@Tags, " +
"UpdatedBy=@UpdatedBy, " +
"UpdatedOn=@UpdatedOn, " +
"Extension=@Extension, " +
"CartoonURL = @CartoonUrl, " +
"emailaddress = @emailaddress, " +
"SeatingFloor= @SeatingFloor, " +
"seatNo = @seatNo " +
"where ProfileId = @ProfileId",
new
{
Department = commandDto.Department,
FirstName = commandDto.FirstName.Replace("'", "''"),
ProfileId = commandDto.ProfileId,
ImageUrl = (string.IsNullOrEmpty(imgURL) ? commandDto.ImageUrl : imgURL),
LastName = commandDto.LastName.Replace("'", "''"),
Role = commandDto.Role,
Tags = !string.IsNullOrEmpty(commandDto.Tags) ? commandDto.Tags.Replace("'", "''") : "",
UpdatedBy = user,
UpdatedOn = DateTime.Now,
Extension = !string.IsNullOrEmpty(commandDto.Extension) ? commandDto.Extension.Replace("'", "''") : "",
CartoonUrl = (string.IsNullOrEmpty(cartoonURL) ? commandDto.CartoonUrl : cartoonURL),
emailaddress = commandDto.EmailAddress,
SeatingFloor = commandDto.SeatingFloor,
seatNo = commandDto.SeatNo
});
conn.Close();
}
}
private static string LoadDefaultProfileImage(EmployeeProfile profile)
{
if (String.IsNullOrEmpty(profile.ImageUrl))
{
return "~/Content/images/profile-default.jpg";
}
return profile.ImageUrl;
}