public void Invoke_ValidData_ReturnsCorrectModel()
{
var userFromDb = new DataAccess.Models.User()
{
Id = 1,
Name = "Name",
Email = "*****@*****.**"
};
// prepare
var findByResult = new List <DataAccess.Models.User>()
{
userFromDb
};
var mockedUserRepository = new Mock <IUserRepository>();
mockedUserRepository.Setup(r => r.FindBy(It.IsAny <Expression <Func <DataAccess.Models.User, bool> > >()))
.Returns(findByResult.AsQueryable);
var action = new GetUserDetails(mockedUserRepository.Object);
// action
var user = action.Invoke("*****@*****.**");
// check
Assert.Equal(1, user.Id);
Assert.Equal("Name", user.Name);
Assert.Equal("*****@*****.**", user.Email);
}
public IEnumerable <GetUserDetails> GetAll()
{
List <GetUserDetails> users = new List <GetUserDetails>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GetUsers", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var user = new GetUserDetails();
user.Id = dr["Id"].ToString();
user.LastName = dr["LastName"].ToString();
user.FirstName = dr["FirstName"].ToString();
user.FullName = dr["FullName"].ToString();
user.Email = dr["Email"].ToString();
user.Role = dr["Role"].ToString();
users.Add(user);
}
}
}
return(users);
}
private IList <GetUserDetails> FillGetUserDetailsModel(DataTable dtUsers)
{
var GetUserDetailsList = new List <GetUserDetails>();
if (null != dtUsers && dtUsers.Rows.Count > 0)
{
foreach (DataRow row in dtUsers.Rows)
{
var UserDetails = new GetUserDetails();
UserDetails.custvendAdminID = Convert.ToInt32(row["CUST_VEND_ADMIN_ID"]);
UserDetails.FirstName = Convert.ToString(row["FIRST_NAME"]);
UserDetails.LastName = Convert.ToString(row["LAST_NAME"]);
UserDetails.ContactNumber = Convert.ToString(row["CONTACT_NUMBER"]);
UserDetails.LoginId = Convert.ToString(row["LOGIN_ID"]);
UserDetails.Password = Convert.ToString(row["LOGIN_PWD"]);
UserDetails.AddressLine1 = Convert.ToString(row["ADDR_LINE1"]);
UserDetails.AddressLine2 = Convert.ToString(row["ADDR_LINE2"]);
UserDetails.City = Convert.ToString(row["CITY"]);
UserDetails.State = Convert.ToString(row["STATE"]);
UserDetails.Country = Convert.ToString(row["COUNTRY"]);
UserDetails.ZIPCode = Convert.ToString(row["ZIP_CODE"]);
GetUserDetailsList.Add(UserDetails);
}
}
return(GetUserDetailsList);
}
public IList <GetUserDetails> getuserDetails(GetUserDetails userdetail)
{
string GetUserDetailsInfo = $"SELECT CUST_VEND_ADMIN_ID, FIRST_NAME, LAST_NAME, CONTACT_NUMBER, LOGIN_ID, LOGIN_PWD, ADDR_LINE1, ADDR_LINE2, CITY, STATE, COUNTRY, ZIP_CODE from USER_TBL U LEFT JOIN CUST_INFO ci ON ci.FK_CUST_VEND_ADMIN_ID = U.CUST_VEND_ADMIN_ID LEFT JOIN CUST_ADDRESS ca ON ca.FK_CUST_INFO_ID = ci.CUST_INFO_ID LEFT JOIN CUST_PHONE cp ON cp.FK_CUST_ADDRESS_ID = ca.CUST_ADDR_ID WHERE CUST_VEND_ADMIN_ID = '{userdetail.custvendAdminID}' and FK_USER_TYPE_ID=1";
var dtResult = mySqlHelper.ExecuteQuery(GetUserDetailsInfo);
var result = FillGetUserDetailsModel(dtResult);
return(result);
}
public View_Connections(IUser user)
{
this.user = user;
ToDate = DateTime.Today;
FromDate = DateTime.Today.AddMonths(-1);
location = new GetLocation();
userDetails = new GetUserDetails(this.user);
profileGraph = new Graph(user, FromDate, ToDate);
}
public IHttpActionResult getuserDetails([FromBody] GetUserDetails UserDetails)
{
var userRepo = new UserRepository();
var result = userRepo.getuserDetails(UserDetails);
if (result == null || result.Count == 0)
{
return(NotFound());
}
return(Ok(result));
}
public View_Profile(IUser user)
{
HandleName = user.ScreenName;
ToDate = DateTime.Today;
FromDate = DateTime.Today.AddDays(-14);
mostDetails = new GetMostDetails(user, FromDate, ToDate);
userDetails = new GetUserDetails(user, FromDate, ToDate);
userStats = new UserStats(user, FromDate, ToDate);
hashtags = new GetUserMostHashtags(user, FromDate, ToDate);
profileGraph = new Graph(user, FromDate, ToDate);
Tweets_Date = "tweets from " + FromDate.Date.ToString() + " to " + ToDate.Date.ToString();
}
public ActionResult MyAccount()
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "Home", new
{
area = ""
}));
}
GetUserDetails objUser = BindUserDetails();
return(View(objUser));
}
public void Invoke_InvalidData_EmptyRepository()
{
// prepare
var findByResult = new List <DataAccess.Models.User>();
var mockedUserRepository = new Mock <IUserRepository>();
mockedUserRepository.Setup(r => r.FindBy(It.IsAny <Expression <Func <DataAccess.Models.User, bool> > >()))
.Returns(findByResult.AsQueryable);
var action = new GetUserDetails(mockedUserRepository.Object);
// action
var user = action.Invoke("*****@*****.**");
// check
Assert.Null(user);
}
public object Get(GetUserDetails request)
{
var session = this.GetSession();
return(session.ConvertTo <GetUserDetailsResponse>());
}
public object Get(GetUserDetails request)
{
return(Request.GetSession().ConvertTo <GetUserDetailsResponse>());
}
public ActionResult MyAccount(string firstName, HttpPostedFileBase profilePhoto, string middlename, string lastName, string nickName, string Gender, string dateOfBirth, string isAgeSecret, string anniversaryDate, string mobileNo, string newPassword, int HintQuestion, string newHintQuestion, string Answer, string Address, int Country, int State, int City, string PinCode)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "Home", new
{
area = ""
}));
}
GetUserDetails objUser = BindUserDetails();
string virtualFilePath = objUser.UserPhoto;
string serverFilepath = string.Empty;
if (profilePhoto != null)
{
string fileType = profilePhoto.ContentType;
if (fileType == "image/jpg" || fileType == "image/jpeg" || fileType == "image/png" || fileType == "image/gif" || fileType == "image/bmp")
{
int fileSize = profilePhoto.ContentLength;
if (fileSize <= 512000)
{
string serverFolderpath = Server.MapPath("../../Images/UserPhotos\\");
if (!Directory.Exists(serverFolderpath))
{
Directory.CreateDirectory(serverFolderpath);
}
string fileName = Path.GetFileName(profilePhoto.FileName);
string primaryFileName = Path.GetFileNameWithoutExtension(fileName);
string fileExtensionName = Path.GetExtension(fileName);
//Generate New fileName
Random objRandom = new Random();
int num = objRandom.Next(999999999);
DateTime dt = DateTime.Now;
string newFileName = primaryFileName + num.ToString() + dt.Day.ToString() + dt.Month.ToString() + dt.Year.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString() + dt.Millisecond.ToString() + fileExtensionName;
serverFilepath = serverFolderpath + newFileName;
virtualFilePath = "../../Images/UserPhotos/" + newFileName;
}
else
{
ViewBag.FileUploadError = "Please upload max 500kb size file only";
return(View(objUser));
}
}
else
{
ViewBag.FileUploadError = "please upload image file only.";
return(View(objUser));
}
}
bool ageSecret;
if (isAgeSecret == "on")
{
ageSecret = true;
}
else
{
ageSecret = false;
}
if (!string.IsNullOrEmpty(newPassword))
{
newPassword = Utility.Encript(newPassword, "ER");
}
db.SP_UpdateUserProfile(Convert.ToInt32(Session["UserId"]), newPassword, HintQuestion, newHintQuestion, Answer, firstName, middlename, lastName, nickName, dateOfBirth, anniversaryDate, Gender, ageSecret, mobileNo, virtualFilePath, Address, Country, State, City, PinCode);
if (profilePhoto != null)
{
string oldFilePath = Server.MapPath(objUser.UserPhoto);
if (System.IO.File.Exists(oldFilePath))
{
}
}
ViewBag.Status = "User Profile has been updated suceesfully";
return(View(BindUserDetails()));
}
private GetUserDetails BindUserDetails()
{
int userId = Convert.ToInt32(Session["UserId"]);
GetUserDetails objUser = db.SP_GetUserDetails(userId).ToList().FirstOrDefault();
List <BindHintQuestion> HintQuestionList = db.SP_BindHintQuestion().ToList();
HintQuestionList.Add(new BindHintQuestion()
{
HintQuestion = "Other", HintQuestionId = 0, IsActive = true
});
HintQuestionList.Insert(0, new BindHintQuestion()
{
HintQuestion = "Select", HintQuestionId = 0, IsActive = true
});
ViewBag.HintQuestionList = new SelectList(HintQuestionList, "HintQuestionId", "HintQuestion", objUser.HintQuetionId);
// Bind Country
List <BindCountry> CountryList = db.SP_BindCountry().ToList();
CountryList.Insert(0, new BindCountry()
{
CountryName = "Select",
CountryId = 0,
IsActive = true
});
ViewBag.CountryList = new SelectList(CountryList, "CountryId", "CountryName", objUser.CountryId);
// Bind State
List <BindState> StateList = db.SP_BindState(objUser.CountryId).ToList();
StateList.Insert(0, new BindState()
{
StateName = "Select",
StateId = 0,
IsActive = true
});
ViewBag.StateList = new SelectList(StateList, "StateId", "StateName", objUser.StateId);
// Bind City
List <BindCity> CityList = db.SP_BindCity(objUser.StateId).ToList();
CityList.Insert(0, new BindCity()
{
CityName = "Select",
CityId = 0,
IsActive = true
});
ViewBag.CityList = new SelectList(CityList, "CityId", "CityName", objUser.CityId);
if (objUser.Gender == "M")
{
if (string.IsNullOrEmpty(objUser.UserPhoto))
{
objUser.UserPhoto = "/../../Images/bf.PNG";
}
}
else if (objUser.Gender == "F")
{
if (string.IsNullOrEmpty(objUser.UserPhoto))
{
objUser.UserPhoto = "/../../Images/gf.PNG";
}
}
return(objUser);
}
public async Task <ActionResult <UserDetailsDto> > Get([FromRoute] GetUserDetails query)
{
var data = await _dispatcher.QueryAsync(query);
return(Ok(data));
}
