private void dgrdFinancialYear_SelectionChanged(object sender, EventArgs e)
        {
            if (dgrdFinancialYear.SelectedRows.Count != 0)
            {

                SelectedYearID = Convert.ToInt32(dgrdFinancialYear.SelectedRows[0].Cells[0].Value);
                financialyear = FinancialYearList.Find(a => a.YearID == SelectedYearID);
                if (financialyear != null)
                {
                    ShowGUI(financialyear);
                }
            }
        }
        public static List<FinancialYear> GetAllFinancialYears()
        {
            NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);
            List<FinancialYear> FinancialYearsList = new List<FinancialYear>();
            var financialyear = newAppsCnn.Gnrl_FinancialYear.ToList();
            foreach (var financial in financialyear)
            {
                FinancialYear year = new FinancialYear();
                year.YearID = financial.YearId;
                year.YearName = financial.YearName;
                year.YearBegin = financial.YearBegin;
                year.YearEnd = financial.YearEnd;
                year.IsDefaultYear = financial.IsDefaultYear;
                year.IsClosedYear = financial.IsClosedYear;
                year.prefix = financial.prefix;

                FinancialYearsList.Add(year);
            }

            return FinancialYearsList;
        }
        private Gnrl_FinancialYear BuildDBRecord(Gnrl_FinancialYear _GnrlFinancilaYear, FinancialYear _FinancialYear)
        {
            if (_FinancialYear.YearID != -1)
            {
                _GnrlFinancilaYear.YearId = _FinancialYear.YearID;

            }
            _GnrlFinancilaYear.YearName = _FinancialYear.YearName;
            _GnrlFinancilaYear.YearEnd = _FinancialYear.YearEnd;
            _GnrlFinancilaYear.YearBegin = _FinancialYear.YearBegin;
            _GnrlFinancilaYear.IsDefaultYear = _FinancialYear.IsDefaultYear;
            _GnrlFinancilaYear.IsClosedYear = _FinancialYear.IsClosedYear;
            _GnrlFinancilaYear.prefix = _FinancialYear.prefix;
            return _GnrlFinancilaYear;
        }
        public DataSaveResult Save(FinancialYear _FinancilaYear)
        {
            try
            {
                NewAppsCnn newAppsCnn = new NewAppsCnn(AppSettings.CrAppSettings.NewAppsConnectionString);

                if (_FinancilaYear.IsDefaultYear == true)
                {
                    var _Gnrl_FinancialYear = newAppsCnn.Gnrl_FinancialYear.ToList();
                    foreach (Gnrl_FinancialYear G in _Gnrl_FinancialYear)
                    {

                        G.IsDefaultYear = false;
                        //G.IsClosedYear = GnrlFinancialYear.IsClosedYear;
                        //G.YearBegin = GnrlFinancialYear.YearBegin;
                        //G.YearEnd = GnrlFinancialYear.YearEnd;
                        //G.YearId = GnrlFinancialYear.YearId;
                        //G.YearName = GnrlFinancialYear.YearName;

                    }
                }
                Gnrl_FinancialYear Gnrl_FinancialYear;
                Gnrl_FinancialYear = newAppsCnn.Gnrl_FinancialYear.Where(a => a.YearId == _FinancilaYear.YearID).FirstOrDefault();

                if (Gnrl_FinancialYear != null)
                {
                    BuildDBRecord(Gnrl_FinancialYear, _FinancilaYear);

                }

                else
                {

                    Gnrl_FinancialYear = new Gnrl_FinancialYear();
                    Gnrl_FinancialYear = BuildDBRecord(Gnrl_FinancialYear, _FinancilaYear);
                    newAppsCnn.Gnrl_FinancialYear.Add(Gnrl_FinancialYear);
                }

                newAppsCnn.SaveChanges();
                //   Audit.AddDataAudit(Audit.AuditActionTypes.AddNew, "Acc_VouchersType", this);

                return new DataSaveResult() { SaveStatus = true };
            }
            catch (Exception ex)
            {
                return new DataSaveResult() { SaveStatus = false };
            }
        }
 private void ShowGUI(FinancialYear _FinancialYear)
 {
     if (!string.IsNullOrEmpty(_FinancialYear.YearName))
     {
         txtYearName.Text = _FinancialYear.YearName;
     }
     if (_FinancialYear.YearBegin != null)
     {
         dtbYearBegin.Value = _FinancialYear.YearBegin;
     }
     if (_FinancialYear.YearEnd != null)
     {
         dtbYearEnd.Value = _FinancialYear.YearEnd;
     }
     if (_FinancialYear.IsDefaultYear != null)
     {
         chkIsDefault.Checked = _FinancialYear.IsDefaultYear;
     }
     if (_FinancialYear.IsClosedYear != null)
     {
         chkIsClosed.Checked = _FinancialYear.IsClosedYear;
     }
     if (_FinancialYear.prefix != null)
     {
         txtPrefix.Text = _FinancialYear.prefix.ToString();
     }
 }
 private void GetDataFromGUI()
 {
     financialyear = new FinancialYear();
     financialyear.YearID = SelectedYearID;
     financialyear.YearName = txtYearName.Text;
     financialyear.YearBegin = dtbYearBegin.Value.Date;
     financialyear.YearEnd = dtbYearEnd.Value.Date;
     financialyear.IsDefaultYear = chkIsDefault.Checked;
     financialyear.IsClosedYear = chkIsClosed.Checked;
     financialyear.prefix = Convert.ToInt32(txtPrefix.Text);
 }
        private void frmFinancialYear_Save(object sender, ref bool _status)
        {
            FinancialYear Year = new FinancialYear();
            GetDataFromGUI();

            DataSaveResult saveResult = Year.Save(financialyear);
            if (saveResult.SaveStatus == false)
            {
                _status = false;

            }
            else
            {
                FinancialYearList = FinancialYear.GetAllFinancialYears();
                LoadDataGrid(FinancialYearList);
            }
            dgrdFinancialYear.Enabled = true;
            dgrdFinancialYear.Rows[SelectedRow].Selected = true;
            dgrdFinancialYear_SelectionChanged(dgrdFinancialYear, new EventArgs());
        }
 private void frmFinancialYear_Delete(object sender, ref bool _status)
 {
     financialyear = new FinancialYear();
     if (SelectedYearID == -1)
     {
         _status = false;
         return;
     }
     DataDeleteResult result = financialyear.Delete(SelectedYearID);
     _status = result.DeleteStatus;
     if (result.DeleteStatus == false)
     {
         MessageBox.Show(result.ErrorMessage);
     }
     else
     {
         FinancialYearList = FinancialYear.GetAllFinancialYears();
         LoadDataGrid(FinancialYearList);
         dgrdFinancialYear.Rows[0].Selected = true;
     }
 }