public IUserModel GetByEmailAddress(string email)
{
UserModel model = null;
SQLConnector.Retrieve(x => {
x.CommandText = "dbo.Select_User_By_Email";
x.Parameters.AddWithValue("@Email", email);
},
(DataRow dr) =>
{
if (dr != null)
{
model = new UserModel
{
UserId = dr.Field <int>("Id"),
DisplayName = dr.Field <String>("DisplayName"),
Email = dr.Field <String>("Email"),
Password = dr.Field <String>("Password"),
UserName = dr.Field <String>("UserName")
};
}
});
return(model);
}
public string Get(int imageId)
{
string base64 = string.Empty;
SQLConnector.Retrieve(x =>
{
x.CommandText = "dbo.Get_Image_By_Id";
x.Parameters.AddWithValue("@ImageId", imageId);
},
(DataRow dr) => {
base64 = dr.Field <String>("Base64Image");
});
return(base64);
}
public PhotoEntryModel GetDetails(int photoId)
{
PhotoEntryModel model = null;
SQLConnector.Retrieve(x =>
{
x.CommandText = "dbo.Get_Image_Details_By_Id";
x.Parameters.AddWithValue("@ImageId", photoId);
},
(DataRow dr) => {
model = new PhotoEntryModel();
model.PhotoId = dr.Field <int>("Id");
model.Base64 = dr.Field <String>("Base64Image");
model.UploadDate = dr.Field <DateTime>("UploadDateTime");
model.VisitorName = dr.Field <String>("VisitorName");
});
return(model);
}
