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;
}
}