private void FormLicenseAvailableByCreateOn_Load(object sender, EventArgs e)
 {
     lblHeader.Text = ControlSurvey.SEASON_NAME;
     lblDate.Text   = ControlSurvey.DATE.ToLongDateString() + " " + ControlSurvey.DATE.ToShortTimeString();
     lblBy.Text     = ControlSurvey.BY;
     using (TBL_LICENSE_GENERATE_DATA_ACCESS lgda = new TBL_LICENSE_GENERATE_DATA_ACCESS())
     {
         dataGridViewFollowUP.DataSource = lgda.ShowLicenseByCreateOn(ControlSurvey.DATE);
     }
 }
 private void btnGenerate_Click(object sender, EventArgs e)
 {
     frmmain = new FormMain();
     try
     {
         using (TBL_LICENSE_GENERATE_DATA_ACCESS lgda = new TBL_LICENSE_GENERATE_DATA_ACCESS())
         {
             List <int> SCHEDULE_ID = new List <int>();
             List <int> temp        = new List <int>();
             List <int> result      = new List <int>();
             //MessageBox.Show(SEASON_ID.ToString());
             foreach (var schedule_id in lgda.RunningAvailableLicenseBySeasonID(SEASON_ID))
             {
                 SCHEDULE_ID.Add(schedule_id.SCHEDULE_ID);
                 //  MessageBox.Show(schedule_id.SCHEDULE_ID.ToString());
             }
             Random rnd = new Random();
             for (int i = 0; i < SCHEDULE_ID.Count; i++)
             {
                 int num = rnd.Next(SCHEDULE_ID.Count);
                 if (!temp.Contains(num))
                 {
                     temp.Add(num);
                     result.Add(SCHEDULE_ID[num]);
                 }
                 else
                 {
                     i--;
                 }
             }
             try
             {
                 //  MessageBox.Show(cboUser.Text.ToString());
                 foreach (var item in result.Take(Convert.ToInt32(cboTake.SelectedItem)))
                 {
                     using (_context = new LicenseDataContext())
                     {
                         TBL_LICENSE_GENERATE lg = new TBL_LICENSE_GENERATE()
                         {
                             SCHEDULE_ID   = Convert.ToInt32(item),
                             CREATE_ON     = Convert.ToDateTime(dateTimePickerLicenseGenerate.Value.ToString("yyy-MM-dd hh:mm")),
                             CREATE_BY     = cboUser.Text,
                             NOTE          = "Not yet.",
                             FOLLOW_UP_BY  = cboFollowUpBy.Text,
                             LAST_MODIFIED = DateTime.Now,
                             IS_ACTIVE     = true
                         };
                         lgda.SaveLicenseGenerate(lg);
                     }
                 }
                 var dialog = MetroMessageBox.Show(this, Properties.Resources.SUCCESSFULL, Properties.Resources.INFORMATION, MessageBoxButtons.OK);
                 if (dialog == System.Windows.Forms.DialogResult.OK)
                 {
                     frmmain.RefreshMain();
                     frmmain.ShowWork(null, null);
                     this.Close();
                 }
             }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
                 this.Close();
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
     }
 }