protected void firstButton_Click(object sender, EventArgs e) { SupplierBillPayment supplierBillPayment = supplierBillPaymentManager.GetSupplierBillPayment(0); GetData(supplierBillPayment); Session["active"] = 0; }
protected void saveButton_Click(object sender, EventArgs e) { SupplierBillPayment supplierBillPayment = new SupplierBillPayment(); supplierBillPayment.SupplierDate = dateTextBox.Value; supplierBillPayment.BillNo = billNoTextBox.Text; supplierBillPayment.SupId = int.Parse(supplierNameDropDownList.SelectedValue); supplierBillPayment.PaymentMode = paymentModeDropDownList.SelectedValue; supplierBillPayment.BankId = int.Parse(bankNameDropDownList.SelectedValue); supplierBillPayment.CheckNo = checkNoTextBox.Text; supplierBillPayment.CheckDate = checkDateTextBox.Value; string amount = amountTextBox.Text; if (dateTextBox.Value == "" || billNoTextBox.Text == "" || paymentModeDropDownList.Text == "" || checkNoTextBox.Text == "" || checkDateTextBox.Value == "" || amountTextBox.Text == "") { messageLabel.InnerText = "All Fields are Required!!"; } else { supplierBillPayment.Amount = Convert.ToDouble(amount); messageLabel.InnerText = supplierBillPaymentManager.Save(supplierBillPayment); } ClearTextBoxes(); }
private void dgv_Bills_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { int billID = int.Parse(dgv_Bills.SelectedRows[0].Cells[0].Value.ToString()); supplierBill = context.SupplierBills.FirstOrDefault(b => b.ID == billID); //label3.Text = supplierBill.suppliers.Name; dtp_GBillDate.Value = supplierBill.BillDate; numTotalCost.Value = 0; numTotalCost.Value = Convert.ToDecimal(supplierBill.BillValue); ///sales order payment supplierBillPayment = context.supplierBillPayment.FirstOrDefault(b => b.SupplierBill_Id == billID); numericPaiedCost.Value = 0; numericPaiedCost.Value = Convert.ToDecimal(supplierBillPayment.Paied); numResCost.Value = 0; numResCost.Value = Convert.ToDecimal(supplierBillPayment.Rest); details = context.SuppliersBillDetails.Where(b => b.SupplierBill_Id == billID).ToList(); dgv_SuplierBill.Rows.Clear(); for (var item = 0; item < details.Count; item++) { int pID = details[item].products_Id; var product = context.products.FirstOrDefault(p => p.ID == pID); string pName = product.ProductName; double quantity = product.quantityPerProducts; double price = product.Price_customer; double discount = product.Discount; // error we have to add discount column to generalBillDetail table dgv_SuplierBill.Rows.Add(discount, price, quantity, pName, pID); } }
public string Save(SupplierBillPayment supplierBillPayment) { if (supplierBillPaymentGateway.Insert(supplierBillPayment) > 0) { return("Saved Successfully!!"); } return("Could Not Save data in Database!!"); }
protected void lastButton_Click(object sender, EventArgs e) { List <SupplierBillPayment> supplierBillPaymentList = (List <SupplierBillPayment>)(Session["supplierBillPayment"]); int x = supplierBillPaymentList.Count - 1; SupplierBillPayment supplierBillPayment = supplierBillPaymentManager.GetSupplierBillPayment(x); GetData(supplierBillPayment); Session["active"] = x; }
private void GetData(SupplierBillPayment supplierBillPayment) { dateTextBox.Value = supplierBillPayment.SupplierDate; billNoTextBox.Text = supplierBillPayment.BillNo; supplierNameDropDownList.Text = supplierBillPayment.SupplierName; paymentModeDropDownList.Text = supplierBillPayment.PaymentMode; bankNameDropDownList.Text = supplierBillPayment.BankAccountName; checkNoTextBox.Text = supplierBillPayment.CheckNo; checkDateTextBox.Value = supplierBillPayment.CheckDate; amountTextBox.Text = supplierBillPayment.Amount.ToString(); }
private static void GetValueFromDatabase(SupplierBillPayment supplierBillPayment, SqlDataReader reader) { supplierBillPayment.SupplierBillPaymentId = int.Parse(reader["id"].ToString()); supplierBillPayment.SupplierDate = reader["date"].ToString(); supplierBillPayment.BillNo = reader["bill_no"].ToString(); supplierBillPayment.SupplierName = reader["supplier_id"].ToString(); supplierBillPayment.PaymentMode = reader["payment_mode"].ToString(); supplierBillPayment.BankAccountName = reader["bank_id"].ToString(); supplierBillPayment.CheckNo = reader["check_no"].ToString(); supplierBillPayment.CheckDate = reader["check_date"].ToString(); supplierBillPayment.Amount = Convert.ToDouble(reader["amount"].ToString()); }
public int Insert(SupplierBillPayment supplierBillPayment) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_supplierBillPayment VALUES('" + supplierBillPayment.SupplierDate + "','" + supplierBillPayment.BillNo + "','" + supplierBillPayment.SupId + "','" + supplierBillPayment.PaymentMode + "','" + supplierBillPayment.BankId + "','" + supplierBillPayment.CheckNo + "','" + supplierBillPayment.CheckDate + "','" + supplierBillPayment.Amount + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
protected void nextButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; active++; List <SupplierBillPayment> supplierBillPaymentList = (List <SupplierBillPayment>)(Session["supplierBillPayment"]); if (active >= supplierBillPaymentList.Count) { active = 0; } SupplierBillPayment supplierBillPayment = supplierBillPaymentManager.GetSupplierBillPayment(active); GetData(supplierBillPayment); Session["active"] = active; }
public SupplierBillPayment GetSupplierBillPayment(int i) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_supplierBillPayment ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); SupplierBillPayment supplierBillPayment = new SupplierBillPayment(); while (reader.Read()) { GetValueFromDatabase(supplierBillPayment, reader); } reader.Close(); connection.Close(); return(supplierBillPayment); }
private string LoadNextBillNo() { SupplierBillPayment supplierBillPayment = supplierBillPaymentManager.GetNextBillNo(); string billNo = supplierBillPayment.BillNo; int count; if (billNo == null) { count = 1; } else { count = (billNo[4] - '0') * 10 + (billNo[5] - '0') + 1; } string nextBillNo = "Bi-0" + count.ToString("00"); return(nextBillNo); }
public SupplierBillPayment GetNextBillNo() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT TOP 1 * FROM tbl_supplierBillPayment ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); SupplierBillPayment supplierBillPayment = new SupplierBillPayment(); while (reader.Read()) { supplierBillPayment.SupplierBillPaymentId = int.Parse(reader["id"].ToString()); supplierBillPayment.BillNo = reader["bill_no"].ToString(); } reader.Close(); connection.Close(); return(supplierBillPayment); }
public List <SupplierBillPayment> GetAllSupplierBillPaymentList() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_supplierBillPayment"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <SupplierBillPayment> supplierBillPaymentList = new List <SupplierBillPayment>(); while (reader.Read()) { SupplierBillPayment supplierBillPayment = new SupplierBillPayment(); GetValueFromDatabase(supplierBillPayment, reader); supplierBillPaymentList.Add(supplierBillPayment); } reader.Close(); connection.Close(); return(supplierBillPaymentList); }