public void PurchaseDetailsEdit(PurchaseDetailsInfo infoPurchaseDetails) { try { spPurchaseDetails.PurchaseDetailsEdit(infoPurchaseDetails); } catch (Exception ex) { MessageBox.Show("PD2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void PurchaseOrderDetailsViewWithRemaining(PurchaseDetailsInfo infoPurchaseDetails) { // decimal decId = 0; try { spPurchaseDetails.PurchaseDetailsAdd(infoPurchaseDetails); } catch (Exception ex) { MessageBox.Show("SB1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } //return decId; }
public void PurchaseDetailsEdit(PurchaseDetailsInfo purchasedetailsinfo) { PurchaseDetailsSP SPPurchaseDetails = new PurchaseDetailsSP(); try { SPPurchaseDetails.PurchaseDetailsEdit(purchasedetailsinfo); } catch (Exception ex) { MessageBox.Show("PIBll 31:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values to PurchaseDetails Table /// </summary> /// <param name="purchasedetailsinfo"></param> public void PurchaseDetailsAdd(PurchaseDetailsInfo purchasedetailsinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PurchaseDetailsAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@purchaseMasterId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.PurchaseMasterId; sprmparam = sccmd.Parameters.Add("@receiptDetailsId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.ReceiptDetailsId; sprmparam = sccmd.Parameters.Add("@orderDetailsId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.OrderDetailsId; sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.ProductId; sprmparam = sccmd.Parameters.Add("@qty", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.Qty; sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.Rate; sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.UnitId; sprmparam = sccmd.Parameters.Add("@unitConversionId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.UnitConversionId; sprmparam = sccmd.Parameters.Add("@discount", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.Discount; sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.TaxId; sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.BatchId; sprmparam = sccmd.Parameters.Add("@godownId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.GodownId; sprmparam = sccmd.Parameters.Add("@rackId", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.RackId; sprmparam = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.TaxAmount; sprmparam = sccmd.Parameters.Add("@grossAmount", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.GrossAmount; sprmparam = sccmd.Parameters.Add("@netAmount", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.NetAmount; sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = purchasedetailsinfo.Amount; sprmparam = sccmd.Parameters.Add("@slNo", SqlDbType.Int); sprmparam.Value = purchasedetailsinfo.SlNo; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = purchasedetailsinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = purchasedetailsinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = purchasedetailsinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to get particular values from PurchaseDetails table based on the parameter /// </summary> /// <param name="purchaseDetailsId"></param> /// <returns></returns> public PurchaseDetailsInfo PurchaseDetailsView(decimal purchaseDetailsId) { PurchaseDetailsInfo purchasedetailsinfo = new PurchaseDetailsInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PurchaseDetailsView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@purchaseDetailsId", SqlDbType.Decimal); sprmparam.Value = purchaseDetailsId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { purchasedetailsinfo.PurchaseDetailsId = decimal.Parse(sdrreader[0].ToString()); purchasedetailsinfo.PurchaseMasterId = decimal.Parse(sdrreader[1].ToString()); purchasedetailsinfo.ReceiptDetailsId = decimal.Parse(sdrreader[2].ToString()); purchasedetailsinfo.OrderDetailsId = decimal.Parse(sdrreader[3].ToString()); purchasedetailsinfo.ProductId = decimal.Parse(sdrreader[4].ToString()); purchasedetailsinfo.Qty = decimal.Parse(sdrreader[5].ToString()); purchasedetailsinfo.Rate = decimal.Parse(sdrreader[6].ToString()); purchasedetailsinfo.UnitId = decimal.Parse(sdrreader[7].ToString()); purchasedetailsinfo.UnitConversionId = decimal.Parse(sdrreader[8].ToString()); purchasedetailsinfo.Discount = decimal.Parse(sdrreader[9].ToString()); purchasedetailsinfo.TaxId = decimal.Parse(sdrreader[10].ToString()); purchasedetailsinfo.BatchId = decimal.Parse(sdrreader[11].ToString()); purchasedetailsinfo.GodownId = decimal.Parse(sdrreader[12].ToString()); purchasedetailsinfo.RackId = decimal.Parse(sdrreader[13].ToString()); purchasedetailsinfo.TaxAmount = decimal.Parse(sdrreader[14].ToString()); purchasedetailsinfo.GrossAmount = decimal.Parse(sdrreader[15].ToString()); purchasedetailsinfo.NetAmount = decimal.Parse(sdrreader[16].ToString()); purchasedetailsinfo.Amount = decimal.Parse(sdrreader[17].ToString()); purchasedetailsinfo.SlNo = int.Parse(sdrreader[18].ToString()); purchasedetailsinfo.PurchaseDetailsId = decimal.Parse(sdrreader[19].ToString()); purchasedetailsinfo.ExtraDate = DateTime.Parse(sdrreader[20].ToString()); purchasedetailsinfo.Extra1 = sdrreader[21].ToString(); purchasedetailsinfo.Extra2 = sdrreader[22].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return purchasedetailsinfo; }