private void frm_showUserInfo_Load(object sender, EventArgs e) /// s.25
{
try
{
//var query = (from U in database.Vw_Users where U.userID == this.Get_UserId select U).ToList(); s.33
// s.33
var query = (database.SP_Show_AllUserInfo(this.Get_UserId).ToList());
if (query.Count == 1)
{
lbl_FistName.Text = query[0].UserFirstName;
lbl_Family.Text = query[0].UserFamily;
lbl_tel.Text = query[0].UserTel;
lbl_PersonalCode.Text = query[0].PersonalCode;
lbl_BirthDayDate.Text = query[0].BirthDayDate;
lbl_Activity.Text = query[0].farsiActivity;
lbl_Email.Text = query[0].Email;
lbl_gender.Text = query[0].farsiGender;
lbl_UserName.Text = query[0].Username;
lbl_job.Text = query[0].jobsName;
var dataUserImage = (Byte[])(query[0].UserImage);
var stream_UserImage = new MemoryStream(dataUserImage);
pictureBox_userImage.Image = Image.FromStream(stream_UserImage);
var dataUserSignature = (Byte[])(query[0].Signatures);
var stream_UserSignature = new MemoryStream(dataUserSignature);
pictureBox_signature.Image = Image.FromStream(stream_UserSignature);
}
}
catch
{
MessageBox.Show("There was a problem communicating with the server. Please try again.");
}
}