private void ShowUserInfo()
{
var query = database.SP_Show_AllUserInfo2(PublicVariable.gUserId).ToList();
if (query.Count == 1)
{
lblBirthDayDate.Text = query[0].BirthDayDate;
lblFamily.Text = query[0].UserFamily;
lblFirstname.Text = query[0].UserFirstName;
lblGender.Text = query[0].farsiGender;
lblJob.Text = query[0].jobsName;
lbl_jobId.Text = query[0].JobId.ToString();
lblPersonalCode.Text = query[0].PersonalCode;
PublicVariable.gDetermineJobsLevel = Convert.ToInt32(query[0].DetermineJobsLevel);
//// Image
var dataUserImage = (Byte[])(query[0].UserImage);
var stream_UserImage = new MemoryStream(dataUserImage);
pictureBox_UserImage.Image = Image.FromStream(stream_UserImage);
/// letter count
var query_letterCount = database.SP_letterCount(PublicVariable.gUserId).ToList();
lblRecievedLetters.Text = query_letterCount[0].recieveLettersCount.ToString();
lblSentLetter.Text = query_letterCount[0].sentLettersCount.ToString();
lblEnterTime.Text = DateTime.Now.Hour + ":" + DateTime.Now.Minute + ":" + DateTime.Now.Second;
lblEnterDate.Text = PublicVariable.TodayDate;
}
else
{
MessageBox.Show("This username does not have a job. Login is not allowed.");
System.Environment.Exit(0);
}
}