/// <summary> /// Function to insert values and return id /// </summary> /// <param name="financialyearinfo"></param> /// <returns></returns> public decimal FinancialYearAddWithReturnIdentity(FinancialYearInfo financialyearinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("FinancialYearAddWithReturnIdentity", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@fromDate", SqlDbType.DateTime); sprmparam.Value = financialyearinfo.FromDate; sprmparam = sccmd.Parameters.Add("@toDate", SqlDbType.DateTime); sprmparam.Value = financialyearinfo.ToDate; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = financialyearinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = financialyearinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = financialyearinfo.Extra2; decIdentity = Convert.ToDecimal(sccmd.ExecuteScalar().ToString()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decIdentity; }
/// <summary> /// Function to insert values to FinancialYear Table /// </summary> /// <param name="financialyearinfo"></param> public void FinancialYearAdd(FinancialYearInfo financialyearinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("FinancialYearAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@fromDate", SqlDbType.DateTime); sprmparam.Value = financialyearinfo.FromDate; sprmparam = sccmd.Parameters.Add("@toDate", SqlDbType.DateTime); sprmparam.Value = financialyearinfo.ToDate; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = financialyearinfo.ExtraDate; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to Update values in FinancialYear Table /// </summary> /// <param name="financialyearinfo"></param> public void FinancialYearEdit(FinancialYearInfo financialyearinfo) { try { SPFinancialYear.FinancialYearEdit(financialyearinfo); } catch (Exception ex) { MessageBox.Show("FY2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values and return id /// </summary> /// <param name="financialyearinfo"></param> /// <returns></returns> public decimal FinancialYearAddWithReturnIdentity(FinancialYearInfo financialyearinfo) { decimal decIdentity = 0; try { decIdentity = SPFinancialYear.FinancialYearAddWithReturnIdentity(financialyearinfo); } catch (Exception ex) { MessageBox.Show("FY8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decIdentity; }
/// <summary> /// Function to get particular values from FinancialYear table For AccountLedger based on the parameter /// </summary> /// <param name="financialYearId"></param> /// <returns></returns> public FinancialYearInfo FinancialYearViewForAccountLedger(decimal financialYearId) { FinancialYearInfo financialyearinfo = new FinancialYearInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("FinancialYearViewForAccountLedger", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = financialYearId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { financialyearinfo.FinancialYearId = decimal.Parse(sdrreader[0].ToString()); financialyearinfo.FromDate = DateTime.Parse(sdrreader[1].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return financialyearinfo; }
/// <summary> /// Function to get particular values from FinancialYear table For AccountLedger based on the parameter /// </summary> /// <param name="financialYearId"></param> /// <returns></returns> public FinancialYearInfo FinancialYearViewForAccountLedger(decimal financialYearId) { FinancialYearInfo financialyearinfo = new FinancialYearInfo(); try { financialyearinfo = SPFinancialYear.FinancialYearViewForAccountLedger(financialYearId); } catch (Exception ex) { MessageBox.Show("FY5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return financialyearinfo; }