public void setId(int invoiceId, APCEntities APCContext1)
 {
     APCContext = APCContext1;
     DataTable dtPaymentFromCustomer = BLInvoice.GetInvoiceById(invoiceId);
     if (dtPaymentFromCustomer.Rows.Count > 0)
     {
         DataRow invoiceRow = dtPaymentFromCustomer.Rows[0];
         //int invoiceId = int.Parse(invoiceRow["Id"].ToString());
         tbInvoiceId.Text = invoiceRow["Id"].ToString();
         tbPaymentDue.Text = ((decimal.Parse(invoiceRow["TotalDue"].ToString())) - TotalPaid(invoiceId)).ToString("N");
     }
 }
예제 #2
0
 private void PaymentToSupplierForm_Load(object sender, EventArgs e)
 {
     lblTodaysDate.Text = DateTime.Today.ToShortDateString();
     lblPurchaseNotInvoiced.Text = calculateBalance(false, false, false).ToString();
     lblArconInvoiceNotPaid.Text = calculateBalance(true, false, false).ToString();
     lblPaymentDueForSupplier.Text = calculateBalance(false, false, true).ToString();
     APCContext = new APCEntities();
     cbPaid.Enabled = false;
     cbInvoiced.Enabled = false;
     cbALL.Checked = true;
     DataTable dt = BLSupplierInvoice.GetSupplierInvoiceDueDatePOInvoicedAndPaid(DateTime.Today.AddDays(14), cbInvoiced.Checked, cbPaid.Checked, cbALL.Checked);
     dgReminderSupplierPayment.DataSource = dt;
 }
 public void setId(int SupplierInvoiceId, APCEntities APCContext1)
 {
     APCContext = APCContext1;
     DataTable dtSupplierInvoice = BLSupplierInvoice.GetSupplierInvoiceById(SupplierInvoiceId);
     if (dtSupplierInvoice.Rows.Count > 0)
     {
         DataRow supplierInvoiceRow = dtSupplierInvoice.Rows[0];
         int supplierInvoiceId = int.Parse(supplierInvoiceRow["Id"].ToString());
         tbSupplierInvoiceId.Text = supplierInvoiceRow["Id"].ToString();
         tbSupplierInvoiceOriginalNo.Text = supplierInvoiceRow["SupplierOriNo"].ToString();
         tbPONo.Text = supplierInvoiceRow["POId"].ToString();
         tbPaymentDue.Text = ((decimal.Parse(supplierInvoiceRow["PaymentDue"].ToString())) - TotalPaid(supplierInvoiceId)).ToString("N");
     }
 }
예제 #4
0
 private void CategoryForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
     DataTable tableDt = new DataTable();
     tableDt.Columns.Add("Name");
     DataRow dr = tableDt.NewRow();
     dr["Name"] = "Supplier";
     DataRow dr1 = tableDt.NewRow();
     dr1["Name"] = "Client";
     DataRow dr2 = tableDt.NewRow();
     dr2["Name"] = "Workers";
     DataRow dr3 = tableDt.NewRow();
     dr3["Name"] = "Product";
     DataRow dr4 = tableDt.NewRow();
     dr4["Name"] = "PO";
     DataRow dr5 = tableDt.NewRow();
     dr5["Name"] = "SupplierInvoice";
     DataRow dr6 = tableDt.NewRow();
     dr6["Name"] = "Invoice";
     DataRow dr7 = tableDt.NewRow();
     dr7["Name"] = "Project";
     DataRow dr8 = tableDt.NewRow();
     dr8["Name"] = "Please select table";
     tableDt.Rows.Add(dr8);
     tableDt.Rows.Add(dr);
     tableDt.Rows.Add(dr1);
     tableDt.Rows.Add(dr2);
     tableDt.Rows.Add(dr3);
     tableDt.Rows.Add(dr4);
     tableDt.Rows.Add(dr5);
     tableDt.Rows.Add(dr6);
     tableDt.Rows.Add(dr7);
     comboBox1.DataSource = tableDt;
     comboBox1.DisplayMember = "Name";
     comboBox1.ValueMember = "Name";
     cbFields.DisplayMember = "column_name";
     cbFields.ValueMember = "DATA_TYPE";
 }
예제 #5
0
 private void ProjectForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
     cbClient.DataSource = APCContext.Client;
     cbClient.DisplayMember = "Name";
     cbClient.ValueMember = "Id";
 }
예제 #6
0
        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);
        }
예제 #7
0
        private void Report_UsageForm_Load(object sender, EventArgs e)
        {
            APCContext = new APCEntities();

            ddlProject.DataSource = APCContext.Project;
            ddlProject.DisplayMember = "Name";
            ddlProject.ValueMember = "Id";

            ddlCategory.DataSource = APCContext.Category;
            ddlCategory.DisplayMember = "Name";
            ddlCategory.ValueMember = "Id";

            calFrom.Value = DateTime.Today.AddDays(-14);
            calTo.Value = DateTime.Today;
        }
예제 #8
0
 private void SupplierForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
 }
예제 #9
0
 private void WorkersForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
 }
예제 #10
0
 private void CategoryForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
 }
 private void Report_UsagePerProjectForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
     DataTable dt = ProjectArcon.DataLayer.Report.GetSummaryPerProject();
     dgProject.DataSource = GetTotalPerProject(dt);
 }
예제 #12
0
        private void Project_WorkersForm_Load(object sender, EventArgs e)
        {
            APCContext = new APCEntities();
            ddlWorker.DataSource = APCContext.Workers;
            ddlWorker.DisplayMember = "Name";
            ddlWorker.ValueMember = "Id";

            ddlProject.DataSource = APCContext.Project;
            ddlProject.DisplayMember = "Name";
            ddlProject.ValueMember = "Id";

            showWorkerSalary();
        }
        private void Project_WorkersForm_Load(object sender, EventArgs e)
        {
            APCContext = new APCEntities();

            ddlSearchWorkers.DataSource = APCContext.Workers;
            ddlSearchWorkers.DisplayMember = "Name";
            ddlSearchWorkers.ValueMember = "Id";

            ddlSearchProject.DataSource = APCContext.Project;
            ddlSearchProject.DisplayMember = "Name";
            ddlSearchProject.ValueMember = "Id";
        }
예제 #14
0
 private void SupplierInvoiceForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
     ddlPO.DataSource = BLPO.GetAllPO(APCContext);
     ddlPO.DisplayMember = "Id";
     ddlPO.ValueMember = "Id";
 }
예제 #15
0
 private void PaymentFromCustomerForm_Load(object sender, EventArgs e)
 {
     APCContext = new APCEntities();
 }
예제 #16
0
        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);
        }