public void SaveLicenseGenerate(TBL_LICENSE_GENERATE lg)
{
using (_context = new LicenseDataContext())
{
_context.TBL_LICENSE_GENERATEs.InsertOnSubmit(lg);
_context.SubmitChanges();
};
}
private void dataGridViewFollowUP_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = this.dataGridViewFollowUP.Rows[e.RowIndex];
// var dialog = MessageBox.Show(this, "Are you sure to change this?", "", MessageBoxButtons.OKCancel);
if (row != null)
{
try
{
int license_generate_id = Convert.ToInt32(row.Cells["LICENSE_GENERATE_ID"].Value);
string note;
// MessageBox.Show(row.Cells["CREATE_BY"].Value.ToString());
if (row.Cells["NOTE"].Value == null)
{
note = "";
//MessageBox.Show("NullExpection");
}
else
{
note = row.Cells["NOTE"].Value.ToString();
}
//MessageBox.Show(license_generate_id.ToString());
using (_context = new LicenseDataContext())
{
TBL_LICENSE_GENERATE lg = (from l in _context.TBL_LICENSE_GENERATEs
where l.LICENSE_GENERATE_ID == license_generate_id
select l).FirstOrDefault();
lg.NOTE = note;
lg.LAST_MODIFIED = DateTime.Now;
lg.FOLLOW_UP_BY = row.Cells["FOLLOW_UP_BY"].Value.ToString();
_context.SubmitChanges();
};
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
}
}
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);
}
}
