public void RejectionInDetailsAdd(RejectionInDetailsInfo rejectionindetailsinfo) { try { spRejectionInDetails.RejectionInDetailsAdd(rejectionindetailsinfo); } catch (Exception ex) { MessageBox.Show("RI4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values to RejectionInDetails Table /// </summary> /// <param name="rejectionindetailsinfo"></param> public void RejectionInDetailsAdd(RejectionInDetailsInfo rejectionindetailsinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("RejectionInDetailsAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@rejectionInMasterId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.RejectionInMasterId; sprmparam = sccmd.Parameters.Add("@deliveryNoteDetailsId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.DeliveryNoteDetailsId; sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.ProductId; sprmparam = sccmd.Parameters.Add("@qty", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.Qty; sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.Rate; sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.UnitId; sprmparam = sccmd.Parameters.Add("@unitConversionId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.UnitConversionId; sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.BatchId; sprmparam = sccmd.Parameters.Add("@godownId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.GodownId; sprmparam = sccmd.Parameters.Add("@rackId", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.RackId; sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = rejectionindetailsinfo.Amount; sprmparam = sccmd.Parameters.Add("@slNo", SqlDbType.Int); sprmparam.Value = rejectionindetailsinfo.SlNo; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = rejectionindetailsinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = rejectionindetailsinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }