private void btnSave_Click(object sender, EventArgs e) { try { if (SaveValidate()) { if (btnSave.Text == "Save_Print") { DataSet ds = obj_SaleTransaction.getData(rst); int count = ds.Tables[0].Rows.Count; int cnt = 0; for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { int SaleTransactionDetailID = 0; int SaleTansactionID = rst; int ProductID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductID"]); int WarehouseID = Convert.ToInt32(ds.Tables[0].Rows[i]["WarehouseID"]); double Quantity = Convert.ToDouble(ds.Tables[0].Rows[i]["Quantity"]); double SellingPrice = Convert.ToDouble(ds.Tables[0].Rows[i]["SalePrice"]); string IsActive = "Yes"; string IsDelete = "No"; string Result = obj_SaleTransaction.saveSaleTransaction(SaleTransactionDetailID, SaleTansactionID, ProductID, Quantity, SellingPrice, IsActive, IsDelete,WarehouseID); int ret = obj_SaleTransaction.AddMedicalStock(dtpDate.Text, Quantity, MedID, ProductID); if ((Result == "2" || Result == "1") && (ret == 2)) { cnt++; } } if (cnt == count) { DiscountAmount = FinalDiscountAmount;//Convert.ToDouble(txtDiscount.Text); BalanceAmount = Convert.ToDouble(txtBalanceAmount.Text); int UpdatedByUserID = 1; string newResult = obj_SaleTransaction.UpdateBalance(DiscountAmount, BalanceAmount, rst, UpdatedByUserID); if (newResult == "1") { AmountPaid = Convert.ToDouble(txtAmountPaid.Text); string AmountPaidDate = dtpDate.Text; //genrate payment invoice no BLMedicalPayment obj_MedicalPayment = new BLMedicalPayment(); DataTable dt = obj_MedicalPayment.getMedicalPaymentID(); string MedicalPaymentNo = dt.Rows[0][0].ToString(); //end gerate payment Invoice no string Place = cbWarehouse.Text; string ReceivedBy = txtBillGenrateBy.Text; double newBalanceAmount = Convert.ToDouble(txtBalanceAmount.Text); int MedicalResult = obj_SaleTransaction.SaveMedicalShopPayment(rst, AmountPaid, AmountPaidDate, UpdatedByUserID, ReceivedBy, Place, MedicalPaymentNo, newBalanceAmount); if (MedicalResult == 2) { string res = obj_SaleTransaction.deletetempdata(rst); MessageBox.Show("Sale Transactin Details Saved Successfully..."); //string res = obj_SaleTransaction.Temp_SaleProduct(rst); dgvSellTransaction.DataSource = null; TempRST = rst; FormSaleTransaction_Print ob = new FormSaleTransaction_Print(rst); ob.Show(); } else { MessageBox.Show("Payment Not Saved"); } } else { MessageBox.Show("Remaining Balance Not Stored"); } } else { MessageBox.Show("Some Records Not Saved"); } clearAllFields(); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void Usp_BindMedicalPaymentGrid() { try { DataTable dt = new DataTable(); BLMedicalPayment objBL = new BLMedicalPayment(); dt = objBL.BindFullGrid(); if (dt.Rows.Count > 0) { dgvMedicalPayment.DataSource = dt; } else { dgvMedicalPayment.DataSource = null; } dgvMedicalPayment.Refresh(); dgvMedicalPayment.Show(); { dgvMedicalPayment.DataSource = dt; //dgvMedicalPayment.Columns[0].HeaderCell.Value = "Sale Invoice Number"; dgvMedicalPayment.Columns[0].Visible = false; dgvMedicalPayment.AllowUserToAddRows = false; dgvMedicalPayment.AllowUserToDeleteRows = false; ////dgvMedicalPayment.Columns[1].HeaderCell.Value = "Total Amount"; //dgvMedicalPayment.Columns[1].HeaderCell.Value = "Paid Amount"; ////dgvMedicalPayment.Columns[3].HeaderCell.Value = "Remaining Balance"; //dgvMedicalPayment.Columns[2].HeaderCell.Value = "Payment Date"; dgvMedicalPayment.Refresh(); dgvMedicalPayment.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void dgvMedicalPayment_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dgvMedicalPayment.SelectedRows.Count > 0) { //cbMedical.Text = Convert.ToString(dgvMedicalPayment.SelectedRows[0].Cells[2].Value); cmbSaleinvoiceno.Text = Convert.ToString(dgvMedicalPayment.SelectedRows[0].Cells[0].Value); txtTotalbalance.Text = Convert.ToString(dgvMedicalPayment.SelectedRows[0].Cells[1].Value); string Totalbalance = txtTotalbalance.Text; BLMedicalPayment objMedicalPayment = new BLMedicalPayment(); DataTable dt = objMedicalPayment.GetID(Totalbalance); if (dt.Rows.Count != 0) { lblID.Text = dt.Rows[0]["MedicalPaymentID"].ToString(); } txtPaidamount.Text = Convert.ToString(dgvMedicalPayment.SelectedRows[0].Cells[2].Value); txtRemaingbalance.Text = Convert.ToString(dgvMedicalPayment.SelectedRows[0].Cells[3].Value); btnSave.Text = "Update"; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }