private void Form2_Load(object sender, EventArgs e)
{
// MessageBox.Show("");
try
{
context = new DBDataContext();
var result = from l in context.TBL_LICENSE_GENERATEs select l;
dataGridView1.DataSource = result;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public DataTable ShowAllCurrencyToComboBox()
{
_context = new DBDataContext();
var result = from s in _context.TLKP_CURRENCies
select s;
DataTable dt = new DataTable();
dt.Columns.Add("CURRENCY_ID");
dt.Columns.Add("CURRENCY_NAME");
DataRow row1 = dt.NewRow();
row1["CURRENCY_ID"] = 0;
row1["CURRENCY_NAME"] = Properties.Resources.ALL_CURRENCY;
dt.Rows.Add(row1);
foreach (var q in result)
{
DataRow row = dt.NewRow();
row["CURRENCY_ID"] = q.CURRENCY_ID;
row["CURRENCY_NAME"] = q.CURRENCY_NAME;
dt.Rows.Add(row);
}
return(dt);
}
public DataTable ShowAllConnectionTypeToComboBox()
{
_context = new DBDataContext();
var result = from s in _context.TLKP_CUSTOMER_CONNECTION_TYPEs
select s;
DataTable dt = new DataTable();
dt.Columns.Add("CUSTOMER_CONNECTION_TYPE_ID");
dt.Columns.Add("CUSTOMER_CONNECTION_TYPE_NAME");
DataRow row1 = dt.NewRow();
row1["CUSTOMER_CONNECTION_TYPE_ID"] = 0;
row1["CUSTOMER_CONNECTION_TYPE_NAME"] = Properties.Resources.ALL_CUSTOMER_CON_TYPE;
dt.Rows.Add(row1);
foreach (var q in result)
{
DataRow row = dt.NewRow();
row["CUSTOMER_CONNECTION_TYPE_ID"] = q.CUSTOMER_CONNECTION_TYPE_ID;
row["CUSTOMER_CONNECTION_TYPE_NAME"] = q.CUSTOMER_CONNECTION_TYPE_NAME;
dt.Rows.Add(row);
}
return(dt);
}
