public async Task <UserProfileResponse> Authenticate(UserProfileRequest request)
{
UserProfileResponse response = new UserProfileResponse();
try
{
request.Password = EncryptString(request.Password);
var queryResult = await iUserProfile.GetUserProfile(request.Email, request.Password);
if (queryResult != null)
{
response.UserProfile = new UserProfileViewModel()
{
UserId = queryResult.UserId,
Email = queryResult.Email,
Password = queryResult.Password,
GenderId = queryResult.GenderId,
FirstName = queryResult.FirstName,
LastName = queryResult.LastName,
Age = queryResult.Age
};
return(response);
}
response.IsSuccess = false;
response.Message = "Email and Password not Found!!!";
}
catch (Exception ex)
{
response.Message = "Something Error in Our System : " + ex.Message;
response.IsSuccess = false;
}
return(response);
}
//Get: user/profile
public ActionResult GetProfile()
{
int userId = Convert.ToInt32(Session["UserId"]);
try
{
//bool result = int.TryParse(Session["UserId"], out userId);
//if (result)
//{
var result = _userProfileRepo.CheckuserProfileExists(userId);
if (result)
{
var profile = _userProfileRepo.GetUserProfile(userId);
return(View(profile));
}
else
{
return(RedirectToAction("AddProfile"));
}
//}
}
catch (Exception e)
{
return(View());
}
return(View());
}
/// <summary>
/// Gets a UserProfile
/// </summary>
/// <param name="id">User ID</param>
/// <returns>UserProfile Detail view</returns>
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
// create new reference to the existing user profile in the database
UserProfile profile = await _profiles.GetUserProfile(id);
if (profile == null)
{
return(NotFound());
}
return(View(profile));
}
public IHttpActionResult GetUserProfile([FromUri(Name = "UserId")] int id)
{
try
{
var result = _userProfile.GetUserProfile(id);
return(Ok <UserProfile>(result));
}
catch (Exception e)
{
//throw;
return(BadRequest("User profile does not exist. Please add user profile using website."));
}
}
public async Task <UserVoteResponse> Add(UserVoteRequest request)
{
UserVoteResponse response = new UserVoteResponse();
try
{
if (!await iUserVote.DuplicateVote(request.VotingID, request.CurrentLogin))
{
if (!await iUserVote.IsVoteExpired(request.VotingID))
{
UserVote userVote = new UserVote();
userVote.UserProfileId = (await iUserProfile.GetUserProfile(request.CurrentLogin)).UserId;
userVote.VotingId = request.VotingID;
userVote.Created = DateTime.Now;
userVote.CreatedBy = request.CurrentLogin;
userVote.RowStatus = true;
if (await iUserVote.Add <UserVote>(userVote))
{
return(response);
}
response.IsSuccess = false;
response.Message = "Failed to Add";
}
else
{
response.IsSuccess = false;
response.Message = "Vote time has been expired!!!";
}
}
else
{
response.IsSuccess = false;
response.Message = "Cannot Vote this item more than 1 time";
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = "Something Error in Our System : " + ex.Message;
}
return(response);
}
public IHttpActionResult GetUserProfile([FromUri] GetUserProfileRequest getUserProfileRequest)
{
var responses = new Responses();
try
{
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
if (getUserProfileRequest == null)
{
getUserProfileRequest = new GetUserProfileRequest();
}
if (getUserProfileRequest.PageSize == null)
{
getUserProfileRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
var userProfile = new UserProfile()
{
UserId = getUserProfileRequest.UserId,
SearchText = getUserProfileRequest.SearchText,
IsActive = getUserProfileRequest.IsActive,
PageNumber = getUserProfileRequest.PageNumber,
PageSize = Convert.ToInt32(getUserProfileRequest.PageSize),
IsPagingRequired = (getUserProfileRequest.PageNumber != null) ? true : false,
OrderBy = getUserProfileRequest.OrderBy,
OrderByDirection = getUserProfileRequest.OrderByDirection
};
var userProfiles = iUserProfile.GetUserProfile(userProfile);
var userProfileList = new List <GetUserProfileResponse>();
foreach (var userProfileItem in userProfiles)
{
userProfileList.Add(new GetUserProfileResponse()
{
UserId = userProfileItem.UserId,
FirstName = userProfileItem.FirstName,
LastName = userProfileItem.LastName,
CompanyName = userProfileItem.CompanyName,
ProfessionalQualificationId = userProfileItem.ProfessionalQualificationId,
ProfessionalQualificationName = userProfileItem.ProfessionalQualificationName,
SubscriptionStatus = userProfileItem.SubscriptionStatus,
City = userProfileItem.City,
UserName = userProfileItem.UserName,
Mobile = userProfileItem.Mobile,
Gender = userProfileItem.Gender,
SubscriptionId = userProfileItem.SubscriptionId,
IsActive = Convert.ToBoolean(userProfileItem.IsActive),
CreatedBy = userProfileItem.CreatedBy,
TotalPageCount = userProfileItem.TotalPageCount,
TotalRecord = userProfileItem.TotalRecord
});
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "UserProfile retrieved successfully";
responses.Response = userProfileList;
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while retrieving UserProfile.";
Utility.WriteLog("GetUserProfile", getUserProfileRequest, "Error while retrieving UserProfile. (UserProfileAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult UpdateSubscription(UpdateSubscriptionRequest updateSubscriptionRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (Utility.UserId < 0)
{
return(BadRequest(Utility.INVALID_USER));
}
var Subscription = new Subscription()
{
SubscriptionId = updateSubscriptionRequest.SubscriptionId,
StartDate = updateSubscriptionRequest.StartDate,
PaymentDate = updateSubscriptionRequest.PaymentDate,
IsExpired = updateSubscriptionRequest.IsExpired,
IsActive = updateSubscriptionRequest.IsActive,
ModifiedBy = Utility.UserId
};
int result = iSubscription.UpdateSubscription(Subscription);
switch (result)
{
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Subscription already exists.";
break;
case -3:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Subscription doesn't exist.";
break;
default:
if (result > 0)
{
string userName = string.Empty;
var userProfile = new UserProfile()
{
UserId = updateSubscriptionRequest.UserId
};
var userProfiles = iUserProfile.GetUserProfile(userProfile);
if (userProfiles != null)
{
userName = userProfiles.First().UserName;
var SubscriptionEmailHtmlCode = System.IO.File.ReadAllText(string.Format("{0}", HttpContext.Current.Server.MapPath(string.Format("{0}{1}", ConfigurationManager.AppSettings["EmailTemplatePath"], (updateSubscriptionRequest.StartDate != null ? ConfigurationManager.AppSettings["SubscriptionUpdateEmailTemplateForUser"] : ConfigurationManager.AppSettings["UnsubscriptionEmailTemplateForUser"])))));
var mainTemplateHtmlCode = System.IO.File.ReadAllText(string.Format("{0}", HttpContext.Current.Server.MapPath(string.Format("{0}{1}", ConfigurationManager.AppSettings["EmailTemplatePath"], ConfigurationManager.AppSettings["MainEmailTemplate"]))));
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[SITEURL]", ConfigurationManager.AppSettings["SiteUrl"]);
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[SITENAME]", ConfigurationManager.AppSettings["SiteName"]);
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[PAGECONTENT]", SubscriptionEmailHtmlCode);
string subject = "Subscription | Demystify Fema";
string body = mainTemplateHtmlCode;
string displayName = ConfigurationManager.AppSettings["SiteName"];
string emailTo = userName;
bool isMailSentToUser = Utility.SendMail(emailTo, string.Empty, string.Empty, subject, body, displayName, string.Empty, true);
try
{
var subscriptionHistory = new SubscriptionHistory()
{
SubscriptionHistoryId = result,
IsMailSentToUser = isMailSentToUser,
ModifiedBy = Utility.UserId
};
iSubscription.UpdateSubscriptionHistoryMailSent(subscriptionHistory);
}
catch (Exception ex)
{
Utility.WriteLog("AddSubscription", updateSubscriptionRequest, "Error while updating Subscription History mail sent. (SubscriptionUserController)", ex.ToString());
}
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "Subscription updated successfully.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating Subscription.";
}
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating Subscription.";
Utility.WriteLog("UpdateSubscription", updateSubscriptionRequest, "Error while updating Subscription. (SubscriptionAdminController)", ex.ToString());
}
return(Ok(responses));
}
public IHttpActionResult AddSubscription(AddSubscriptionRequest addSubscriptionRequest)
{
var responses = new Responses();
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var subscription = new Subscription()
{
UserId = Utility.UserId,
PackageId = addSubscriptionRequest.PackageId,
CreatedBy = Utility.UserId
};
int result = iSubscription.AddSubscription(subscription);
switch (result)
{
case -2:
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Subscription already exists.";
break;
default:
if (result > 0)
{
string userName = string.Empty;
var userProfile = new UserProfile()
{
UserId = Utility.UserId
};
var userProfiles = iUserProfile.GetUserProfile(userProfile);
if (userProfiles != null)
{
userName = userProfiles.First().UserName;
var SubscriptionEmailHtmlCode = System.IO.File.ReadAllText(string.Format("{0}", HttpContext.Current.Server.MapPath(string.Format("{0}{1}", ConfigurationManager.AppSettings["EmailTemplatePath"], ConfigurationManager.AppSettings["SubscriptionAddEmailTemplateForUser"]))));
var mainTemplateHtmlCode = System.IO.File.ReadAllText(string.Format("{0}", HttpContext.Current.Server.MapPath(string.Format("{0}{1}", ConfigurationManager.AppSettings["EmailTemplatePath"], ConfigurationManager.AppSettings["MainEmailTemplate"]))));
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[SITEURL]", ConfigurationManager.AppSettings["SiteUrl"]);
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[SITENAME]", ConfigurationManager.AppSettings["SiteName"]);
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[PAGECONTENT]", SubscriptionEmailHtmlCode);
string subject = "Subscription | Demystify Fema";
string body = mainTemplateHtmlCode;
string displayName = ConfigurationManager.AppSettings["SiteName"];
string emailTo = userName;
bool isMailSentToUser = Utility.SendMail(emailTo, string.Empty, string.Empty, subject, body, displayName, string.Empty, true);
SubscriptionEmailHtmlCode = string.Empty;
SubscriptionEmailHtmlCode = System.IO.File.ReadAllText(string.Format("{0}", HttpContext.Current.Server.MapPath(string.Format("{0}{1}", ConfigurationManager.AppSettings["EmailTemplatePath"], ConfigurationManager.AppSettings["SubscriptionAddEmailTemplateForAdmin"]))));
SubscriptionEmailHtmlCode = SubscriptionEmailHtmlCode.Replace("[USERNAME]", userName);
mainTemplateHtmlCode = string.Empty;
mainTemplateHtmlCode = System.IO.File.ReadAllText(string.Format("{0}", HttpContext.Current.Server.MapPath(string.Format("{0}{1}", ConfigurationManager.AppSettings["EmailTemplatePath"], ConfigurationManager.AppSettings["MainEmailTemplate"]))));
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[SITEURL]", ConfigurationManager.AppSettings["SiteUrl"]);
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[SITENAME]", ConfigurationManager.AppSettings["SiteName"]);
mainTemplateHtmlCode = mainTemplateHtmlCode.Replace("[PAGECONTENT]", SubscriptionEmailHtmlCode);
subject = "Subscription | Demystify Fema";
body = mainTemplateHtmlCode;
displayName = ConfigurationManager.AppSettings["SiteName"];
bool isMailSentToAdmin = Utility.SendMail(ConfigurationManager.AppSettings["AdminEmailId"], string.Empty, string.Empty, subject, body, displayName, string.Empty, true);
try
{
var objSubscription = new Subscription()
{
SubscriptionId = result,
IsMailSentToUser = isMailSentToUser,
IsMailSentToAdmin = isMailSentToAdmin,
ModifiedBy = Utility.UserId
};
iSubscription.UpdateSubscriptionMailSent(objSubscription);
}
catch (Exception ex)
{
Utility.WriteLog("AddSubscription", addSubscriptionRequest, "Error while updating Subscription mail sent. (SubscriptionUserController)", ex.ToString());
}
}
responses.Status = Utility.SUCCESS_STATUS_RESPONSE;
responses.Description = "Subscription added successfully.";
}
else
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while updating Subscription.";
}
break;
}
}
catch (Exception ex)
{
responses.Status = Utility.ERROR_STATUS_RESPONSE;
responses.Description = "Error while adding Subscription.";
Utility.WriteLog("AddSubscription", addSubscriptionRequest, "Error while adding Subscription. (SubscriptionUserController)", ex.ToString());
}
return(Ok(responses));
}
/// <summary>
/// 取得某个用户信息
/// </summary>
/// <param name="userCode"></param>
/// <returns></returns>
public UserProfileInfo GetUserProfile(string userCode)
{
DataSet ds = dal.GetUserProfile(userCode);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
UserProfileInfo info = new UserProfileInfo();
info.ID = dr["ID"].ToString();
info.CHName = dr["CHName"].ToString();
info.ENName = dr["ENName"].ToString();
info.ADAccount = dr["ADAccount"].ToString();
info.Email = dr["Email"].ToString();
info.EmailOrig = dr["EmailOrig"].ToString();
info.OfficePhone = dr["OfficePhone"].ToString();
info.CellPhone = dr["CellPhone"].ToString();
info.WorkPlace = dr["WorkPlace"].ToString();
info.HireDate = dr["HireDate"].ToString();
info.Birthdate = dr["Birthdate"].ToString();
try
{
if (dr["PositionGuid"] != null && !string.IsNullOrEmpty(dr["PositionGuid"].ToString()))
{
info.PositionGuid = new Guid(dr["PositionGuid"].ToString());
}
else
{
info.PositionGuid = Guid.Empty;
}
}
catch
{
info.PositionGuid = Guid.Empty;
}
info.PositionName = dr["PositionName"].ToString();
info.ManagerAccount = dr["ManagerAccount"].ToString();
info.EmployeeAccount = dr["EmployeeAccount"].ToString();
info.CostCenter = dr["CostCenter"].ToString();
int _state = -1;
int.TryParse(dr["State"].ToString(), out _state);
info.State = _state;
info.FAX = dr["FAX"].ToString();
info.BlackBerry = dr["BlackBerry"].ToString();
info.GraduateFrom = dr["GraduateFrom"].ToString();
info.OAC = dr["OAC"].ToString();
info.PoliticalAffiliation = dr["PoliticalAffiliation"].ToString();
info.Gender = dr["Gender"].ToString();
info.EducationalBackground = dr["EducationalBackground"].ToString();
info.WorkExperienceBefore = dr["WorkExperienceBefore"].ToString();
info.WorkExperienceNow = dr["WorkExperienceNow"].ToString();
info.PhotoUrl = dr["PhotoUrl"].ToString();
info.CreatedBy = dr["CreatedBy"].ToString();
info.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
int _orderNo = 0;
int.TryParse(dr["OrderNo"].ToString(), out _orderNo);
info.OrderNo = _orderNo;
return(info);
}
}
return(null);
}
