public bool SaveUserProfileDetails(UserProfileDetails_Model userProfileDetails)
{
using (var _dbContext = new SalesTrackingSystemEntities())
{
try
{
var data = new UserProfileDetail()
{
UserProfileDetailID = userProfileDetails.UserProfileDetailID,
UserProfileID = userProfileDetails.UserProfileID,
ModuleID = userProfileDetails.ModuleID,
ModuleActionID = userProfileDetails.ModuleActionID,
ProfileDetailStatus = userProfileDetails.ProfileDetailStatus,
Description = userProfileDetails.Description,
CreatedBy = userProfileDetails.CreatedBy,
DateCreated = DateTime.Now
};
_dbContext.UserProfileDetails.Add(data);
_dbContext.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public int saveUserProfileDetail(UserProfileDetailModel model)
{
try
{
using (_context = new HSSNInventoryEntities())
{
var data = new UserProfileDetail()
{
ProfileId = model.ProfileId,
ModuleId = model.ModuleId,
CreateStatus = model.CreateStatus,
EditStatus = model.EditStatus,
DeleteStatus = model.DeleteStatus,
PrintStatus = model.PrintStatus,
ViewStatus = model.ViewStatus
};
_context.Entry(data).State = EntityState.Added;
_context.SaveChanges();
return(data.ProfileDetailId);
}
}
catch (Exception)
{
throw;
}
}
public UserProfileDetail GetProfileById(int id)
{
UserProfile getProfile = _db.UserProfiles.Single(up => up.ProfileId == id);
UserProfileDetail profileDetail = new UserProfileDetail()
{
ProfileId = getProfile.ProfileId,
UserName = getProfile.UserName,
FirstName = getProfile.FirstName,
LastName = getProfile.LastName,
Age = getProfile.Age,
CreatedUser = getProfile.CreatedUser,
Email = getProfile.Email,
UserActivities = getProfile.UsersActivities.Select(ua => new UsersActivityListItem
{
ActivityId = ua.ActivityId
}).ToList(),
UserEvents = getProfile.UserEvents.Select(ue => new UserEventListItem
{
EventId = ue.EventId
}).ToList()
};
return(profileDetail);
}
public bool SaveUserProfileDetaile(List <UserProfileDetailModel> modellist)
{
try
{
using (_context = new HSSNInventoryEntities())
{
foreach (var userProfileDetailModel in modellist)
{
var model = new UserProfileDetail()
{
ProfileId = userProfileDetailModel.ProfileId,
ModuleId = userProfileDetailModel.ModuleId,
CreateStatus = userProfileDetailModel.CreateStatus,
EditStatus = userProfileDetailModel.EditStatus,
DeleteStatus = userProfileDetailModel.DeleteStatus,
PrintStatus = userProfileDetailModel.PrintStatus,
ViewStatus = userProfileDetailModel.ViewStatus,
};
_context.Entry(model).State = EntityState.Added;
}
_context.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public UserProfileDetail userprofiledetails(int studentscode)
{
userprofile profile = new userprofile();
UserProfileDetail Detils = new UserProfileDetail();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_api_getuserprofile", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@studentcode", SqlDbType.Int).Value = studentscode;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
profile.studentcode = Convert.ToInt32(rdr["code"]);
profile.admissionno = Convert.ToString(rdr["admissionno"]);
profile.firstname = Convert.ToString(rdr["Firstname"]);
profile.lastname = Convert.ToString(rdr["Lastname"]);
profile.middletname = Convert.ToString(rdr["Middlename"]);
profile.aadharno = Convert.ToString(rdr["adharno"]);
profile.correspondance = Convert.ToString(rdr["Correspondance"]);
profile.homeaddress1 = Convert.ToString(rdr["HomeAddress1"]);
profile.homeaddress2 = Convert.ToString(rdr["HomeAddress2"]);
profile.homeaddress3 = Convert.ToString(rdr["HomeAddress3"]);
profile.homeaddress4 = Convert.ToString(rdr["HomeAddress4"]);
profile.homepincode = Convert.ToString(rdr["HomePincode"]);
profile.hometelno = Convert.ToString(rdr["HomeTelno"]);
profile.homemobileno = Convert.ToString(rdr["HomeMobileNo"]);
profile.homeemail = Convert.ToString(rdr["HomeEmail"]);
profile.officeemail = Convert.ToString(rdr["OfficeEmail"]);
profile.officeaddress1 = Convert.ToString(rdr["OfficeAddress1"]);
profile.officeaddress2 = Convert.ToString(rdr["OfficeAddress2"]);
profile.officeaddress3 = Convert.ToString(rdr["OfficeAddress3"]);
profile.officeaddress4 = Convert.ToString(rdr["OfficeAddress4"]);
profile.officetelno = Convert.ToString(rdr["OfficeTelno"]);
profile.officemobileno = Convert.ToString(rdr["OfficeMobileNo"]);
profile.officepincode = Convert.ToString(rdr["OfficePincode"]);
profile.fb = Convert.ToString(rdr["fb"]);
profile.twitter = Convert.ToString(rdr["twitter"]);
profile.linkedin = Convert.ToString(rdr["linkedin"]);
profile.batchcode = Convert.ToInt32(rdr["BatchCode"].ToString());
profile.coursetypecode = Convert.ToInt32(rdr["CourseTypeCode"].ToString());
profile.coursecode = Convert.ToInt32(rdr["CourseCode"].ToString());
profile.homecity = Convert.ToInt32(rdr["HomeCity"].ToString());
profile.officecity = Convert.ToInt32(rdr["OfficeCity"].ToString());
profile.homestatecode = Convert.ToInt32(rdr["HomeStateCode"].ToString());
profile.officestatecode = Convert.ToInt32(rdr["OfficeStateCode"].ToString());
profile.homecountrycode = Convert.ToInt32(rdr["HomeCountryCode"].ToString());
profile.officecountrycode = Convert.ToInt32(rdr["OfficeCountryCode"].ToString());
profile.specicode = Convert.ToInt32(rdr["specicode"].ToString());
profile.studentimage = Convert.ToBase64String((byte[])rdr["picture"]);
}
con.Close();
}
}
Detils.userprofile = profile;
return(Detils);
}
// Called from Create (Get)
// When someone tries to create a User Profile, if a User Profile already exists for that Registered Account
// Display the existing UserProfile in Detail View. From there, they can Edit it, or return to Index
public ActionResult ProfileExists(UserProfileDetail model)
{
TempData["SaveResult"] = "A User Profile for this Account already exists.";
return(View(model));
}
/// <summary>
/// Get the user profile card attachment for given user profile.
/// </summary>
/// <param name="userProfile">User profile details.</param>
/// <param name="profileCardId">User profile unique activity card Id.</param>
/// <returns>User profile details card attachment for given user.</returns>
public static Attachment GetMyProfileCard(UserProfileDetail userProfile, string profileCardId)
{
var skills = userProfile.Skills.Count > 0 ? string.Join(";", userProfile.Skills) : Strings.NoneText;
var interests = userProfile.Interests.Count > 0 ? string.Join(";", userProfile.Interests) : Strings.NoneText;
var schools = userProfile.Schools.Count > 0 ? string.Join(";", userProfile.Schools) : Strings.NoneText;
var myProfileCard = new AdaptiveCard(new AdaptiveSchemaVersion(1, 0))
{
Body = new List <AdaptiveElement>
{
new AdaptiveTextBlock
{
HorizontalAlignment = AdaptiveHorizontalAlignment.Left,
Text = userProfile.DisplayName,
Wrap = true,
Weight = AdaptiveTextWeight.Bolder,
},
new AdaptiveTextBlock
{
HorizontalAlignment = AdaptiveHorizontalAlignment.Left,
Text = userProfile.JobTitle,
Wrap = true,
IsSubtle = true,
Weight = AdaptiveTextWeight.Default,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveTextBlock
{
HorizontalAlignment = AdaptiveHorizontalAlignment.Left,
Text = userProfile.AboutMe,
Wrap = true,
Spacing = AdaptiveSpacing.Small,
},
},
Actions = new List <AdaptiveAction>
{
new AdaptiveSubmitAction
{
Title = Strings.EditProfileTitle,
Data = new AdaptiveCardAction
{
MsteamsCardAction = new CardAction
{
Type = Constants.FetchActionType,
},
Command = Constants.MyProfile,
MyProfileCardId = profileCardId,
},
},
new AdaptiveShowCardAction
{
Title = Strings.DetailsTitle,
Card = new AdaptiveCard(new AdaptiveSchemaVersion(1, 0))
{
Body = new List <AdaptiveElement>
{
new AdaptiveTextBlock
{
Text = Strings.SkillsTitle,
Separator = true,
Wrap = true,
Weight = AdaptiveTextWeight.Bolder,
},
new AdaptiveTextBlock
{
Text = skills,
Wrap = true,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveTextBlock
{
Text = Strings.InterestTitle,
Separator = true,
Wrap = true,
Weight = AdaptiveTextWeight.Bolder,
},
new AdaptiveTextBlock
{
Text = interests,
Wrap = true,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveTextBlock
{
Text = Strings.SchoolsTitle,
Separator = true,
Wrap = true,
Weight = AdaptiveTextWeight.Bolder,
},
new AdaptiveTextBlock
{
Text = schools,
Wrap = true,
Spacing = AdaptiveSpacing.None,
},
},
Actions = new List <AdaptiveAction>
{
new AdaptiveOpenUrlAction
{
Title = GoToProfileCommand,
Url = new Uri($"{GoToProfileUrl}?u={userProfile.Id}&v=profiledetails"),
},
},
},
},
},
};
var adaptiveCardAttachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = myProfileCard,
};
return(adaptiveCardAttachment);
}
/// <summary>
/// Get the user profile edit card for given user profile.
/// </summary>
/// <param name="userProfile">User profile details.</param>
/// <param name="profileCardId">User profile unique card Id.</param>
/// <param name="appBaseUrl">Applicaion base uri.</param>
/// <returns>User profile details edit card attachment for given user.</returns>
public static Attachment GetEditProfileCard(UserProfileDetail userProfile, string profileCardId, string appBaseUrl)
{
var skills = userProfile.Skills.Count > 0 ? string.Join(";", userProfile.Skills) : Strings.NoneText;
var interests = userProfile.Interests.Count > 0 ? string.Join(";", userProfile.Interests) : Strings.NoneText;
var schools = userProfile.Schools.Count > 0 ? string.Join(";", userProfile.Schools) : Strings.NoneText;
var myProfileCard = new AdaptiveCard(new AdaptiveSchemaVersion(1, 0))
{
Body = new List <AdaptiveElement>
{
new AdaptiveContainer
{
Items = new List <AdaptiveElement>
{
new AdaptiveTextBlock
{
Text = Strings.FullNameTitle,
Size = AdaptiveTextSize.Small,
Wrap = true,
},
new AdaptiveTextBlock
{
Text = userProfile.DisplayName,
Wrap = true,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveTextBlock
{
Text = Strings.AboutMeTitle,
Wrap = true,
Size = AdaptiveTextSize.Small,
},
new AdaptiveTextInput
{
Placeholder = Strings.AboutMePlaceHolderText,
IsMultiline = true,
Style = AdaptiveTextInputStyle.Text,
Id = "aboutme",
MaxLength = 300,
Value = userProfile.AboutMe,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveColumnSet
{
Columns = new List <AdaptiveColumn>
{
new AdaptiveColumn
{
Width = AdaptiveColumnWidth.Auto,
Items = new List <AdaptiveElement>
{
new AdaptiveImage
{
Url = new Uri($"{appBaseUrl}/Artifacts/validationIcon.png"),
},
},
},
new AdaptiveColumn
{
Width = AdaptiveColumnWidth.Auto,
Items = new List <AdaptiveElement>
{
new AdaptiveTextBlock
{
Text = Strings.ValidationTaskModuleMessage,
Wrap = true,
},
},
},
},
},
new AdaptiveTextBlock
{
Text = Strings.InterestTitle,
Wrap = true,
Size = AdaptiveTextSize.Small,
},
new AdaptiveTextInput
{
Placeholder = Strings.InterestsPlaceHolderText,
IsMultiline = true,
Style = AdaptiveTextInputStyle.Text,
Id = "interests",
MaxLength = 100,
Value = interests,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveTextBlock
{
Text = Strings.SchoolsTitle,
Wrap = true,
Size = AdaptiveTextSize.Small,
},
new AdaptiveTextInput
{
Placeholder = Strings.SchoolsPlaceHolderText,
IsMultiline = true,
Style = AdaptiveTextInputStyle.Text,
Id = "schools",
MaxLength = 200,
Value = schools,
Spacing = AdaptiveSpacing.None,
},
new AdaptiveTextBlock
{
Text = Strings.SkillsTitle,
Wrap = true,
Size = AdaptiveTextSize.Small,
},
new AdaptiveTextInput
{
Placeholder = Strings.SkillsPlaceHolderText,
IsMultiline = true,
Style = AdaptiveTextInputStyle.Text,
Id = "skills",
MaxLength = 100,
Value = skills,
Spacing = AdaptiveSpacing.None,
},
},
},
},
Actions = new List <AdaptiveAction>
{
new AdaptiveSubmitAction()
{
Title = Strings.UpdateTitle,
Data = new AdaptiveCardAction
{
Command = Constants.MyProfile,
MyProfileCardId = profileCardId,
},
},
},
};
var adaptiveCardAttachment = new Attachment()
{
ContentType = AdaptiveCard.ContentType,
Content = myProfileCard,
};
return(adaptiveCardAttachment);
}
public ActionResult UserProfile(UserProfile userprofilemodel)
{
var user = dbobj.Users.Where(x => x.EmailID == User.Identity.Name).FirstOrDefault();
if (ModelState.IsValid)
{
if (userprofilemodel.ProfilePicture != null)
{
//image size limit 10MB
var profilepicsize = userprofilemodel.ProfilePicture.ContentLength;
if (profilepicsize > 10 * 1024 * 1024)
{
// error if image size is more than 10MB
ModelState.AddModelError("ProfilePicture", "Image size limit is 10 MB");
userprofilemodel.CountryList = dbobj.Countries.Where(x => x.IsActive == true).ToList();
userprofilemodel.GenderList = dbobj.ReferenceData.Where(x => x.RefCategory == "Gender" && x.IsActive == true).ToList();
return(View(userprofilemodel));
}
}
var profile = dbobj.UserProfileDetail.Where(x => x.UserID == user.ID).FirstOrDefault();
//edit profile
if (profile != null)
{
profile.DOB = userprofilemodel.DOB;
profile.Gender = userprofilemodel.Gender;
profile.CountryCode = userprofilemodel.CountryCode.Trim();
profile.PhoneNumber = userprofilemodel.PhoneNumber.Trim();
profile.AddressLine1 = userprofilemodel.AddressLine1.Trim();
profile.AddressLine2 = userprofilemodel.AddressLine2.Trim();
profile.City = userprofilemodel.City.Trim();
profile.State = userprofilemodel.State.Trim();
profile.ZipCode = userprofilemodel.ZipCode.Trim();
profile.Country = userprofilemodel.Country.Trim();
profile.University = userprofilemodel.University.Trim();
profile.College = userprofilemodel.College.Trim();
profile.ModifiedDate = DateTime.Now;
profile.ModifiedBy = user.ID;
// delete old profilepic
if (userprofilemodel.ProfilePicture != null && profile.ProfilePicture != null)
{
string path = Server.MapPath(profile.ProfilePicture);
FileInfo file = new FileInfo(path);
if (file.Exists)
{
file.Delete();
}
}
// if user upload profile picture then save it and store path in database
if (userprofilemodel.ProfilePicture != null)
{
string filename = System.IO.Path.GetFileName(userprofilemodel.ProfilePicture.FileName);
string fileextension = System.IO.Path.GetExtension(userprofilemodel.ProfilePicture.FileName);
string newfilename = "DP_" + DateTime.Now.ToString("ddMMyyyy_hhmmss") + fileextension;
string profilepicturepath = "~/Members/" + profile.UserID + "/";
CreateNewDirectory(profilepicturepath);
string path = Path.Combine(Server.MapPath(profilepicturepath), newfilename);
profile.ProfilePicture = profilepicturepath + newfilename;
userprofilemodel.ProfilePicture.SaveAs(path);
}
dbobj.Entry(profile).State = EntityState.Modified;
dbobj.SaveChanges();
user.FirstName = userprofilemodel.FirstName.Trim();
user.LastName = userprofilemodel.LastName.Trim();
dbobj.Entry(user).State = EntityState.Modified;
dbobj.SaveChanges();
}
// new userprofile
else
{
UserProfileDetail userprofile = new UserProfileDetail();
userprofile.UserID = user.ID;
userprofile.DOB = userprofilemodel.DOB;
userprofile.Gender = userprofilemodel.Gender;
userprofile.CountryCode = userprofilemodel.CountryCode.Trim();
userprofile.PhoneNumber = userprofilemodel.PhoneNumber.Trim();
userprofile.AddressLine1 = userprofilemodel.AddressLine1.Trim();
userprofile.AddressLine2 = userprofilemodel.AddressLine2.Trim();
userprofile.City = userprofilemodel.City.Trim();
userprofile.State = userprofilemodel.State.Trim();
userprofile.ZipCode = userprofilemodel.ZipCode.Trim();
userprofile.Country = userprofilemodel.Country.Trim();
userprofile.University = userprofilemodel.University.Trim();
userprofile.College = userprofilemodel.College.Trim();
userprofile.CreatedDate = DateTime.Now;
userprofile.CreatedBy = user.ID;
if (userprofilemodel.ProfilePicture != null)
{
string filename = System.IO.Path.GetFileName(userprofilemodel.ProfilePicture.FileName);
string fileextension = System.IO.Path.GetExtension(userprofilemodel.ProfilePicture.FileName);
string newfilename = "DP_" + DateTime.Now.ToString("ddMMyyyy_hhmmss") + fileextension;
string profilepicturepath = "~/Members/" + userprofile.UserID + "/";
CreateNewDirectory(profilepicturepath);
string path = Path.Combine(Server.MapPath(profilepicturepath), newfilename);
userprofile.ProfilePicture = profilepicturepath + newfilename;
userprofilemodel.ProfilePicture.SaveAs(path);
}
dbobj.UserProfileDetail.Add(userprofile);
dbobj.SaveChanges();
user.FirstName = userprofilemodel.FirstName.Trim();
user.LastName = userprofilemodel.LastName.Trim();
dbobj.Entry(user).State = EntityState.Modified;
dbobj.SaveChanges();
}
return(RedirectToAction("SearchNotes", "SearchNotes"));
}
//for invalid ModelState
else
{
userprofilemodel.CountryList = dbobj.Countries.Where(x => x.IsActive == true).ToList();
userprofilemodel.GenderList = dbobj.ReferenceData.Where(x => x.RefCategory == "Gender" && x.IsActive == true).ToList();
return(View(userprofilemodel));
}
}
public ActionResult MemberDetail(int member, string sort, int?page)
{
ViewBag.Sort = sort;
ViewBag.PageNumber = page;
ViewBag.Member = member;
// get id of note status draft
var draftid = dobj.ReferenceData.Where(x => x.Value.ToLower() == "draft").Select(x => x.ID).FirstOrDefault();
// get member
Context.Users users = dobj.Users.Where(x => x.ID == member).FirstOrDefault();
UserProfileDetail userprofiles = dobj.UserProfileDetail.Where(x => x.UserID == users.ID).FirstOrDefault();
// get member's notes excluding note status draft
var notes = dobj.NoteDetail.Where(x => x.SellerID == users.ID && x.Status != draftid).ToList();
// create list of MemberDetail.MembersNote
var notelist = new List <MemberDetail.MembersNote>();
foreach (var note in notes)
{
// get data of downloaded notes for count how many people downloaded notes and get total earning
var downloadednoteslist = dobj.Downloads.Where(x => x.NoteID == note.ID && x.IsSellerHasAllowedDownload == true && x.AttachmentPath != null);
// create membernote object of MemberDetail.MembersNote
var membernote = new MemberDetail.MembersNote();
membernote.ID = note.ID;
membernote.Title = note.Title;
membernote.Category = note.NoteCategories.Name;
membernote.Status = note.ReferenceData.Value;
membernote.DownloadedNotes = downloadednoteslist.Count();
membernote.TotalEarning = downloadednoteslist.Select(x => x.PurchasedPrice).Sum();
membernote.DateAdded = note.CreatedDate;
membernote.PublishedDate = note.PublishedDate;
// add membernote object to notelist
notelist.Add(membernote);
}
// create object of MemberDetail
MemberDetail members = new MemberDetail();
members.FirstName = users.FirstName;
members.LastName = users.LastName;
members.Email = users.EmailID;
if (userprofiles != null)
{
members.DOB = userprofiles.DOB;
members.PhoneNumberCountryCode = userprofiles.CountryCode;
members.PhoneNumber = userprofiles.PhoneNumber;
members.College = userprofiles.University;
members.Address1 = userprofiles.AddressLine1;
members.Address2 = userprofiles.AddressLine2;
members.City = userprofiles.City;
members.State = userprofiles.State;
members.ZipCode = userprofiles.ZipCode;
members.Country = userprofiles.Country;
members.ProfilePicture = userprofiles.ProfilePicture;
}
IEnumerable <MemberDetail.MembersNote> note1 = notelist.AsEnumerable();
// sorting member notes result
note1 = SortTableMemberNotes(sort, note1);
members.Notes = note1.ToList().AsQueryable().ToPagedList(page ?? 1, 5);
return(View(members));
}
