private void InvoiceForm_Load(object sender, EventArgs e)
{
APCContext = new APCEntities();
List <Project> projectList = BLProject.GetAllProject(APCContext);
ddlProject.DataSource = projectList;
ddlProject.DisplayMember = "Name";
ddlProject.ValueMember = "Id";
dgInvoiceProduct.AutoGenerateColumns = false;
dgInvoiceProduct.DataSource = createInvoiceProductTable();
//dgInvoiceProduct.Columns.Remove("Name");
//dgInvoiceProduct.Columns.Remove("Kurs");
//dgInvoiceProduct.Columns.Remove("SubCon");
DataGridViewComboBoxColumn colName = BLHelper.ReturnDataGridComboBoxColumn("Name", "Name", "Name", "Name");
colName.AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet;
colName.DataSource = APCContext.Category;
DataGridViewComboBoxColumn colKurs = BLHelper.ReturnDataGridComboBoxColumn("Name", "Name", "Name", "Name");
colName.AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet;
colKurs.DataSource = APCContext.Kurs;
DataGridViewCheckBoxColumn colSubCon = BLHelper.ReturnDataGridCBColumn("SubCon");
//dgInvoiceProduct.Columns.Insert(0, colName);
//dgInvoiceProduct.Columns.Insert(5, colKurs);
dgInvoiceProduct.Columns.Add(colName);
dgInvoiceProduct.Columns.Add(colKurs);
dgInvoiceProduct.Columns.Add(colSubCon);
}
public List <PO> searchById(int id)
{
if (id != 0)
{
List <PO> poList = BLPO.GetPOListById(APCContext, id);
if (poList != null)
{
tbId.Text = poList[0].Id.ToString();
cbSupplier.SelectedValue = poList[0].Supplier.Id;
cbProject.SelectedValue = poList[0].Project.Id;
List <PO_Product> poProductList = BLPO_Product.GetPO_ProductByPOId(APCContext, id);
dgPOProduct.DataSource = createPO_ProductTableFromList(poProductList);
dgPOProduct.Columns.Remove("Name");
dgPOProduct.Columns.Remove("SubCon");
DataGridViewComboBoxColumn colName = BLHelper.ReturnDataGridComboBoxColumn("Name", "Name", "Name", "Name");
colName.DataSource = APCContext.Category;
DataGridViewCheckBoxColumn colSubCon = BLHelper.ReturnDataGridCBColumn("SubCon");
dgPOProduct.Columns.Insert(0, colName);
dgPOProduct.Columns.Add(colSubCon);
return(poList);
}
else
{
MessageBox.Show("PO Id not found");
}
}
else
{
MessageBox.Show("PO Id not found");
}
return(null);
}
private void POForm_Load(object sender, EventArgs e)
{
APCContext = new APCEntities();
cbSupplier.DataSource = APCContext.Supplier;
cbProject.DataSource = APCContext.Project;
cbSupplier.DisplayMember = "Name";
cbSupplier.ValueMember = "Id";
cbProject.DisplayMember = "Name";
cbProject.ValueMember = "Id";
dgPOProduct.DataSource = createPOProductTable();
dgPOProduct.Columns.Remove("Name");
dgPOProduct.Columns.Remove("SubCon");
DataGridViewComboBoxColumn colName = BLHelper.ReturnDataGridComboBoxColumn("Name", "Name", "Name", "Name");
colName.DataSource = APCContext.Category;
DataGridViewCheckBoxColumn colSubCon = BLHelper.ReturnDataGridCBColumn("SubCon");
dgPOProduct.Columns.Insert(0, colName);
dgPOProduct.Columns.Add(colSubCon);
}
