//get suplier details #region METHOD TO Get Suplier Details for Purchase return public PurchaseReturnBLL GetSuplierForPurchaseReturn(int keyword) { PurchaseReturnBLL prBLL = new PurchaseReturnBLL(); SqlConnection conn = new SqlConnection(myconnstrng); DataTable dt = new DataTable(); try { string sql = "select * from Purchase_Transactions,Supplier_Master where Purchase_Transactions.Sup_ID = Supplier_Master.SupplierID and Purchase_Transactions.Purchase_ID = " + keyword; SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); conn.Open(); adapter.Fill(dt); if (dt.Rows.Count > 0) { //p.Item_Code = dt.Rows[0]["Item_Code"].ToString(); prBLL.Sup_Name = dt.Rows[0]["CompanyName"].ToString(); prBLL.Sup_Contact = dt.Rows[0]["Phone_No"].ToString(); prBLL.Sup_Address = dt.Rows[0]["Address"].ToString(); prBLL.Sup_Email = dt.Rows[0]["Email"].ToString(); prBLL.Transaction_Type = dt.Rows[0]["Transaction_Type"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(prBLL); }
public bool insertPurchaseReturn(PurchaseReturnBLL br, out int Invoice_No) { bool isSuccess = false; Invoice_No = -1; SqlConnection con = new SqlConnection(myconnstrng); try { String sql = "INSERT INTO Purchase_Return_Transactions(Purchase_ID,Transaction_Type,Sup_ID,Sub_Total,TDiscount,TSGST,TCGST,TIGST,Grand_Total,Reson) VALUES(@Purchase_ID,@Transaction_Type,@Sup_ID,@Sub_Total,@TDiscount,@TSGST,@TCGST,@TIGST,@Grand_Total,@Reson);select @@IDENTITY;"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@Purchase_ID", br.Purchase_ID); cmd.Parameters.AddWithValue("@Invoice_No", br.Invoice_No); cmd.Parameters.AddWithValue("@Transaction_Type", br.Transaction_Type); cmd.Parameters.AddWithValue("@Sup_ID", br.Sup_ID); cmd.Parameters.AddWithValue("@Sub_Total", br.Sub_Total); cmd.Parameters.AddWithValue("@TDiscount", br.TDiscount); cmd.Parameters.AddWithValue("@TSGST", br.TSGST); cmd.Parameters.AddWithValue("@TCGST", br.TCGST); cmd.Parameters.AddWithValue("@TIGST", br.TIGST); cmd.Parameters.AddWithValue("@Grand_Total", br.Grand_Total); cmd.Parameters.AddWithValue("@Reson", br.Reson); con.Open(); object o = cmd.ExecuteScalar(); if (o != null) { isSuccess = true; Invoice_No = int.Parse(o.ToString()); } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } return(isSuccess); }
private void comboPurchaseID_SelectedIndexChanged(object sender, EventArgs e) { int PurchaseID; int.TryParse(comboPurchaseID.Text, out PurchaseID); PurchaseReturnBLL crBLL = PurchaseReturnDAL.GetSuplierForPurchaseReturn(PurchaseID); comboPurchaseType.Text = crBLL.Transaction_Type; textSupplierName.Text = crBLL.Sup_Name; textContact.Text = crBLL.Sup_Contact; textEmail.Text = crBLL.Sup_Email; textAddress.Text = crBLL.Sup_Address; comboItemName.DataSource = null; DataTable dti = PurchaseReturnDetailsDAL.SelectItemName(PurchaseID); comboItemName.DisplayMember = "Product_Name"; comboItemName.Items.Add("Select Product Name"); comboItemName.DataSource = dti; PClear(); }