/// <summary> /// Function to Update values in BudgetDetails Table /// </summary> /// <param name="budgetdetailsinfo"></param> public void BudgetDetailsEdit(BudgetDetailsInfo budgetdetailsinfo) { try { SPBudgetDetails.BudgetDetailsEdit(budgetdetailsinfo); } catch (Exception ex) { MessageBox.Show("BGBll2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get particular values from BudgetDetails table based on the parameter /// </summary> /// <param name="budgetDetailsId"></param> /// <returns></returns> public BudgetDetailsInfo BudgetDetailsView(decimal budgetDetailsId) { BudgetDetailsInfo budgetdetailsinfo = new BudgetDetailsInfo(); try { budgetdetailsinfo = SPBudgetDetails.BudgetDetailsView(budgetDetailsId); } catch (Exception ex) { MessageBox.Show("BGBll5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(budgetdetailsinfo); }
public BudgetDetailsInfo BudgetDetailsView(decimal budgetDetailsId) { BudgetDetailsInfo budgetdetailsinfo = new BudgetDetailsInfo(); SqlDataReader sdrreader = null; try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("BudgetDetailsView", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam2 = new SqlParameter(); sprmparam2 = sccmd.Parameters.Add("@budgetDetailsId", SqlDbType.Decimal); sprmparam2.Value = budgetDetailsId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { budgetdetailsinfo.BudgetDetailsId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString()); budgetdetailsinfo.BudgetMasterId = decimal.Parse(((DbDataReader)sdrreader)[1].ToString()); budgetdetailsinfo.Particular = ((DbDataReader)sdrreader)[2].ToString(); budgetdetailsinfo.Credit = decimal.Parse(((DbDataReader)sdrreader)[3].ToString()); budgetdetailsinfo.Debit = decimal.Parse(((DbDataReader)sdrreader)[4].ToString()); budgetdetailsinfo.Extra1 = ((DbDataReader)sdrreader)[5].ToString(); budgetdetailsinfo.Extra2 = ((DbDataReader)sdrreader)[6].ToString(); budgetdetailsinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[7].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); base.sqlcon.Close(); } return(budgetdetailsinfo); }
public void BudgetDetailsEdit(BudgetDetailsInfo budgetdetailsinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("BudgetDetailsEdit", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam8 = new SqlParameter(); sprmparam8 = sccmd.Parameters.Add("@budgetDetailsId", SqlDbType.Decimal); sprmparam8.Value = budgetdetailsinfo.BudgetDetailsId; sprmparam8 = sccmd.Parameters.Add("@budgetMasterId", SqlDbType.Decimal); sprmparam8.Value = budgetdetailsinfo.BudgetMasterId; sprmparam8 = sccmd.Parameters.Add("@particular", SqlDbType.VarChar); sprmparam8.Value = budgetdetailsinfo.Particular; sprmparam8 = sccmd.Parameters.Add("@credit", SqlDbType.Decimal); sprmparam8.Value = budgetdetailsinfo.Credit; sprmparam8 = sccmd.Parameters.Add("@debit", SqlDbType.Decimal); sprmparam8.Value = budgetdetailsinfo.Debit; sprmparam8 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam8.Value = budgetdetailsinfo.Extra1; sprmparam8 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam8.Value = budgetdetailsinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }