private void Save() { PurchaseContractBL purchaseContractBL = new PurchaseContractBL(); PurchaseContractDetailBL contractDetailBL = new PurchaseContractDetailBL(); var sellerID = int.Parse(cmbSeller.SelectedValue.ToString()); var userID = (cmbUserMaster.SelectedValue.ToString()); var ApprovedBy = (cmbUserMaster.SelectedValue.ToString()); if (table == null) { //var sellerID = int.Parse(((DataRowView)cmbSeller.SelectedItem)[1].ToString()); purchaseContractId = purchaseContractBL.AddPurchaseContract(dtpPurchaseContractDate.Value, userID, sellerID, ApprovedBy); } else { purchaseContractId = (int)table.Rows[0]["PurchaseContractID"]; purchaseContractBL.UpdatePurchaseContract(dtpPurchaseContractDate.Value, userID, sellerID, purchaseContractId, ApprovedBy); contractDetailBL.DeletePurchaseContractDetail(purchaseContractId); } foreach (DataGridViewRow row in dgvPurchaseContract.Rows) //for (int i=0;i< dgvPurchaseContract.Rows.Count;i++) { //var row = dgvPurchaseContract.Rows[i]; var weight = Decimal.Parse(row.Cells["Weight"].Value.ToString()); var price = Decimal.Parse(row.Cells["Price"].Value.ToString()); var totalAmount = Decimal.Parse(row.Cells["TotalAmount"].Value.ToString()); var rawmaterialID = int.Parse(row.Cells["Product"].Value.ToString()); contractDetailBL.AddPurchaseContractDetail(weight, price, totalAmount, purchaseContractId, rawmaterialID); } }
private void button2_Click(object sender, EventArgs e) { PurchaseContractDetailBL contractDetailBL = new PurchaseContractDetailBL(); PurchaseContractBL productBL = new PurchaseContractBL(); if (dgvPurchaseContract.SelectedRows.Count > 0) { var id = (int)dgvPurchaseContract.SelectedRows[0].Cells["PurchaseContractID"].Value; contractDetailBL.DeletePurchaseContractDetail(id); productBL.DeletePurchaseContract(id); LoadPurchaseContract(); } }
public void SetPurchaseContract(int ID) { PurchaseContractBL sellerMasterBL = new PurchaseContractBL(); table = sellerMasterBL.GetPurchaseContractByID(ID); dtpPurchaseContractDate.Value = DateTime.Parse(table.Rows[0]["PurchaseContractDate"].ToString()); cmbUserMaster.SelectedValue = table.Rows[0]["PreparedBy"].ToString(); cmbSeller.SelectedValue = table.Rows[0]["SellerID"]; //txtCompanyName.Text = table.Rows[0]["CompanyName"].ToString(); PurchaseContractDetailBL contractDetailBL = new PurchaseContractDetailBL(); var tbl = contractDetailBL.GetPurchaseContractDetailByID((int)table.Rows[0]["PurchaseContractID"]); //foreach (var row in tbl.Rows) for (int i = 0; i < tbl.Rows.Count; i++) { var index = dgvPurchaseContract.Rows.Add(); dgvPurchaseContract.Rows[index].Cells["Weight"].Value = tbl.Rows[i]["Weight"]; dgvPurchaseContract.Rows[index].Cells["Price"].Value = tbl.Rows[i]["Price"]; dgvPurchaseContract.Rows[index].Cells["TotalAmount"].Value = tbl.Rows[i]["TotalAmount"]; dgvPurchaseContract.Rows[index].Cells["Product"].Value = tbl.Rows[i]["ProductID"]; } if ((bool)table.Rows[0]["Approve"]) { dtpPurchaseContractDate.Enabled = false; cmbApprovedBy.Enabled = false; cmbUserMaster.Enabled = false; cmbSeller.Enabled = false; dgvPurchaseContract.Enabled = false; btnSave.Enabled = false; btnDelete.Enabled = false; btnApprove.Enabled = false; btnAdd.Enabled = false; } // dtpPurchaseContractDate.Enabled = false; }