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); } }