public static int AddAccountingYear(tAccountingYear tAccountingYear)
{
int rowsAdded;
try
{
using (IDbConnection connection = DbConnectionHelper.GetConnection())
{
var query =
new StringBuilder(
"INSERT INTO tAccountingYear(CompanyId, AccountYearId,StartMonth,EndMonth,StartVoucherNo,EndVoucherNo,StartPostingDate,EndPostingDate,SetDateTime,EntryUser)");
query.Append("VALUES( @CompanyId, @AccountYearId,@StartMonth,@EndMonth,@StartVoucherNo,@EndVoucherNo,@StartPostingDate,@EndPostingDate,@SetDateTime,@EntryUser)");
rowsAdded = connection.Execute(query.ToString(), tAccountingYear);
}
}
catch (SqlException ex)
{
//LoggerHelper.Write(TraceEventType.Error, "Error in AddAccountingYear. " + ex,
// new[] { Constants.LOGGING_CATEGORY_EXCEPTION });
throw ex;
}
return rowsAdded;
}
public static int AddAccountingYear(tAccountingYear tAccountingYear)
{
try
{
return AccountingDataProvider.AddAccountingYear(tAccountingYear);
}
catch (SqlException ex)
{
throw new BusinessApplicationException("Error in busines logic of AddAccountingYear", ex);
}
//catch (Exception exception)
//{
// throw new Exception(exception.Message);
//}
}
public static int UpdateAccountingYear(tAccountingYear tAccountingYear)
{
int rowsUpdated;
try
{
using (IDbConnection connection = DbConnectionHelper.GetConnection())
{
var query =
new StringBuilder("UPDATE tAccountingYear SET AccountYearId = @AccountYearId,StartMonth=@StartMonth,EndMonth=@EndMonth,StartVoucherNo=@StartVoucherNo, EndVoucherNo=@EndVoucherNo");
query.Append(" , StartPostingDate= @StartPostingDate,EndPostingDate=@EndPostingDate,SetDateTime=@SetDateTime,EntryUser=@EntryUser");
query.Append(" WHERE CompanyId=@CompanyId and AccountYearId = @AccountYearId");
rowsUpdated = connection.Execute(query.ToString(), tAccountingYear);
}
}
catch (SqlException ex)
{
throw ex ;
}
return rowsUpdated;
}
public static int DeleteAccountingYear(tAccountingYear tAccountingYear)
{
int rowsDeleted;
using (IDbConnection connection = DbConnectionHelper.GetConnection())
{
var query =
new StringBuilder("DELETE FROM tAccountingYear WHERE CompanyId=@CompanyId and AccountYearId = @AccountYearId");
rowsDeleted = connection.Execute(query.ToString(), tAccountingYear);
}
return rowsDeleted;
}
public static int UpdateAccountingYear(tAccountingYear tAccountingYear)
{
try
{
return AccountingDataProvider.UpdateAccountingYear(tAccountingYear);
}
catch (SqlException ex)
{
throw new BusinessApplicationException("Error in busines logic of UpdateAccountingYear", ex);
}
}
public static int DeleteAccountingYear(tAccountingYear tAccountingYear)
{
try
{
return AccountingDataProvider.DeleteAccountingYear(tAccountingYear);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
private void UpdateFields(tAccountingYear tAccountingYear)
{
_selectedYeareId =tAccountingYear.AccountYearId;
txtAccountingYear.Text = tAccountingYear.AccountYearId.ToString();
cboStartFromMonth.SelectedIndex = tAccountingYear.StartMonth-1;
cboEndFromMonth.SelectedIndex = tAccountingYear.EndMonth - 1;
txtFirstVoucherNo.Text = tAccountingYear.StartVoucherNo.ToString();
txtLastVoucherNo.Text = tAccountingYear.EndVoucherNo.ToString();
dpkFirstPostingDate.Text = tAccountingYear.StartPostingDate.ToShortDateString();
dpkLastPostingDate.Text = tAccountingYear.EndPostingDate.ToShortDateString();
chkLocked.IsChecked = tAccountingYear.IsLocked;
}
private tAccountingYear AccountingYearBuilder()
{
var chartOfAccount = new tAccountingYear
{
CompanyId = ShatedData.ApplicationState.SelectedCompanyId,
AccountYearId = Convert.ToInt64(txtAccountingYear.Text),
StartMonth = cboStartFromMonth.SelectedIndex + 1,
EndMonth = cboEndFromMonth.SelectedIndex + 1,
StartVoucherNo = Convert.ToInt64(txtFirstVoucherNo.Text),
EndVoucherNo = Convert.ToInt64(txtLastVoucherNo.Text),
StartPostingDate = DateTime.Parse(dpkFirstPostingDate.Text),
EndPostingDate = DateTime.Parse(dpkLastPostingDate.Text),
IsLocked = chkLocked.IsChecked == true,
EntryUser = ShatedData.ApplicationState.LoginUserName,
SetDateTime = DateTime.Now,
UpdateDateTime = DateTime.Now
};
return chartOfAccount;
}