void GridBind() { //dtDeletingPurchassOrderDetail.Rows.Clear(); dataGridView1.Rows.Clear(); BindControl(); try { int PurchasesOrderId = SelectedPurchasesOrder.Purchases_Order_Id; //Convert.ToInt32(ListPurchaseOrder.SelectedValue); textPuchasesOrderNo.Text = SelectedPurchasesOrder.Purchases_Order_No; dateTimePickerPurchasesOrderDate.Value = SelectedPurchasesOrder.Date; PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); List <PurchasesOrderDetailEL> lstPurchasesOrderDetail = objPurchasesOrderDetailDL.GetPurchasesOrderDetailByOrderId(PurchasesOrderId); //dataGridView1.DataSource = dt; for (int i = 0; i < lstPurchasesOrderDetail.Count; i++) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Purchase_Order_Detail_Id"].Value = lstPurchasesOrderDetail[i].Purchase_Order_Detail_Id; //dataGridView1.Rows[i].Cells["Item_Name"].Value = lstPurchasesOrderDetail[i].Item_Name; dataGridView1.Rows[i].Cells["ItemName"].Value = lstPurchasesOrderDetail[i].Item_id; dataGridView1.Rows[i].Cells["Item_Quantity"].Value = lstPurchasesOrderDetail[i].Item_Quantity; dataGridView1.Rows[i].Cells["Item_Rate"].Value = lstPurchasesOrderDetail[i].Item_Rate; dataGridView1.Rows[i].Cells["Total_Amount"].Value = lstPurchasesOrderDetail[i].Total_Amount; } } catch { } }
private void btnDelete_Click(object sender, EventArgs e) { string str = MessageBox.Show("Are you want to delete this Company", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).ToString(); if (str.Equals("Yes")) { SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { PurchaseOrderDL objPurchasesOrderDL = new PurchaseOrderDL(); List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>(); PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); int PurchasesOrderId = SelectedPurchasesOrder.Purchases_Order_Id; lstPurchasesOrderDetailEL = objPurchasesOrderDetailDL.GetPurchasesOrderDetailByOrderId(PurchasesOrderId); lstPurchasesOrderDetailEL.ForEach(r => objPurchasesOrderDetailDL.Delete(objSqlTransaction, r)); objPurchasesOrderDL.Delete(objSqlTransaction, SelectedPurchasesOrder); objSqlTransaction.Commit(); Common.MessageDelete(); FillListBox(); ControlClear(); } catch { objSqlTransaction.Rollback(); } } }
private void GetGlobalVariableData() { BillingDelivertDetailDL objBillingDelivertDetailDL = new BillingDelivertDetailDL(); lstBillingDelivertDetail = objBillingDelivertDetailDL.GetBillingDelivertDetail(companyEL); PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); lstPurchasesOrderDetail = objPurchasesOrderDetailDL.GetPurchasesOrderDetail(); }
private void btnSave_Click(object sender, EventArgs e) { if (textPuchasesOrderNo.Text.Trim() == "") { Common.MessageAlert("First enter Purchases Order No"); return; } if (dataGridView1.Rows.Count - 1 <= 0) { Common.MessageAlert("First Enter Item Detail"); return; } SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { PurchaseOrderEL objPurchaseOrderEL = new PurchaseOrderEL(); PurchaseOrderDL objPurchasesOrderDL = new PurchaseOrderDL(); PurchasesOrderDetailEL objPurchasesOrderDetailEL; List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>(); PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); objPurchaseOrderEL.Company_id = companyEL.Company_id; objPurchaseOrderEL.Date = dateTimePickerPurchasesOrderDate.Value; objPurchaseOrderEL.Purchases_Order_No = textPuchasesOrderNo.Text.Trim(); int PurchaseOrderId = objPurchasesOrderDL.Insert(objSqlTransaction, objPurchaseOrderEL); for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { objPurchasesOrderDetailEL = new PurchasesOrderDetailEL(); //objPurchasesOrderDetailEL.Item_Name = dataGridView1.Rows[i].Cells["Item_Name"].Value.ToString().Trim(); objPurchasesOrderDetailEL.Item_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["ItemName"].Value); objPurchasesOrderDetailEL.Item_Quantity = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Quantity"].Value); objPurchasesOrderDetailEL.Item_Rate = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Rate"].Value); objPurchasesOrderDetailEL.Purchases_Order_Id = PurchaseOrderId; lstPurchasesOrderDetailEL.Add(objPurchasesOrderDetailEL); } lstPurchasesOrderDetailEL.ForEach(r => objPurchasesOrderDetailDL.Insert(objSqlTransaction, r)); objSqlTransaction.Commit(); Common.MessageSave(); FillListBox(); ControlClear(); } catch { objSqlTransaction.Rollback(); Common.MessageAlert("First enter data in correct format"); } }
void CreateReport() { //DisposeReport(); try { PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); DataSet ds = objPurchasesOrderDetailDL.GetPurchasesBillReportData(CompanyId, PurchasesOrderId); objRpt = new PurchasesBill(); objRpt.SetDataSource(ds); crystalReportViewer1.ReportSource = objRpt; } catch { } }
void GridBind() { //dtDeletingPurchassOrderDetail.Rows.Clear(); dataGridView1.Rows.Clear(); BindControl(); try { int PurchasesOrderId = SelectedPurchasesOrder.Purchases_Order_Id; //Convert.ToInt32(ListPurchaseOrder.SelectedValue); textPuchasesOrderNo.Text = SelectedPurchasesOrder.Purchases_Order_No; dateTimePickerPurchasesOrderDate.Value = SelectedPurchasesOrder.Date; textTax.Text = SelectedPurchasesOrder.Tax_Percentage.ToString(); txtOtherAmount.Text = SelectedPurchasesOrder.Other_Amount.ToString(); txtRequisitioner.Text = SelectedPurchasesOrder.Requisitioner.ToString(); txtCreditTerm.Text = SelectedPurchasesOrder.Credit_Term.ToString(); txtShippingTerm.Text = SelectedPurchasesOrder.Shipping_Term.ToString(); txtComments.Text = SelectedPurchasesOrder.Comments.ToString(); PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); List <PurchasesOrderDetailEL> lstPurchasesOrderDetail = objPurchasesOrderDetailDL.GetPurchasesOrderDetailByOrderId(PurchasesOrderId); //dataGridView1.DataSource = dt; for (int i = 0; i < lstPurchasesOrderDetail.Count; i++) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["Purchase_Order_Detail_Id"].Value = lstPurchasesOrderDetail[i].Purchase_Order_Detail_Id; //dataGridView1.Rows[i].Cells["Item_Name"].Value = lstPurchasesOrderDetail[i].Item_Name; dataGridView1.Rows[i].Cells["ItemName"].Value = lstPurchasesOrderDetail[i].Item_id; dataGridView1.Rows[i].Cells["Item_Quantity"].Value = lstPurchasesOrderDetail[i].Item_Quantity; dataGridView1.Rows[i].Cells["Item_Rate"].Value = lstPurchasesOrderDetail[i].Item_Rate; dataGridView1.Rows[i].Cells["Item_Unit"].Value = lstPurchasesOrderDetail[i].Item_Unit; dataGridView1.Rows[i].Cells["Total_Amount"].Value = lstPurchasesOrderDetail[i].Total_Amount; } } catch { } }
private void btnSave_Click(object sender, EventArgs e) { //if ((string.IsNullOrEmpty( textPuchasesOrderNo.Text.Trim()))) //{ // Common.MessageAlert("First enter Purchases Order No"); // return; //} decimal result; if (string.IsNullOrEmpty(textTax.Text.Trim()) || !decimal.TryParse(textTax.Text, out result)) { Common.MessageAlert("First enter Tax Percentage"); return; } if (dataGridView1.Rows.Count - 1 <= 0) { Common.MessageAlert("First Enter Item Detail"); return; } SQLHelper objSQLHelper = new SQLHelper(); SqlTransaction objSqlTransaction = objSQLHelper.BeginTrans(); try { PurchaseOrderEL objPurchaseOrderEL = new PurchaseOrderEL(); PurchaseOrderDL objPurchasesOrderDL = new PurchaseOrderDL(); PurchasesOrderDetailEL objPurchasesOrderDetailEL; List <PurchasesOrderDetailEL> lstPurchasesOrderDetailEL = new List <PurchasesOrderDetailEL>(); PurchasesOrderDetailDL objPurchasesOrderDetailDL = new PurchasesOrderDetailDL(); objPurchaseOrderEL.Company_id = SelectedCompany.Company_id; objPurchaseOrderEL.Date = dateTimePickerPurchasesOrderDate.Value; objPurchaseOrderEL.Tax_Percentage = Convert.ToDecimal(textTax.Text); if (string.IsNullOrEmpty(txtOtherAmount.Text.Trim())) { objPurchaseOrderEL.Other_Amount = 0; } else { objPurchaseOrderEL.Other_Amount = Convert.ToDecimal(txtOtherAmount.Text); } objPurchaseOrderEL.Requisitioner = txtRequisitioner.Text; objPurchaseOrderEL.Credit_Term = txtCreditTerm.Text; objPurchaseOrderEL.Shipping_Term = txtShippingTerm.Text; objPurchaseOrderEL.Comments = txtComments.Text; objPurchaseOrderEL.Purchases_Order_No = textPuchasesOrderNo.Text.Trim(); int PurchaseOrderId = objPurchasesOrderDL.Insert(objSqlTransaction, objPurchaseOrderEL); for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { objPurchasesOrderDetailEL = new PurchasesOrderDetailEL(); //objPurchasesOrderDetailEL.Item_Name = dataGridView1.Rows[i].Cells["Item_Name"].Value.ToString().Trim(); objPurchasesOrderDetailEL.Item_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["ItemName"].Value); objPurchasesOrderDetailEL.Item_Quantity = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Quantity"].Value); objPurchasesOrderDetailEL.Item_Rate = Convert.ToDouble(dataGridView1.Rows[i].Cells["Item_Rate"].Value); objPurchasesOrderDetailEL.Item_Unit = dataGridView1.Rows[i].Cells["Item_Unit"].Value.ToString(); objPurchasesOrderDetailEL.Purchases_Order_Id = PurchaseOrderId; lstPurchasesOrderDetailEL.Add(objPurchasesOrderDetailEL); } lstPurchasesOrderDetailEL.ForEach(r => objPurchasesOrderDetailDL.Insert(objSqlTransaction, r)); objSqlTransaction.Commit(); Common.MessageSave(); FillListBox(); ControlClear(); } catch { objSqlTransaction.Rollback(); Common.MessageAlert("First enter data in correct format"); } }