public static ACC_SubBasicAccount GetACC_SubBasicAccountBySubBasicAccountID(int SubBasicAccountID)
{
ACC_SubBasicAccount aCC_SubBasicAccount = new ACC_SubBasicAccount();
SqlACC_SubBasicAccountProvider sqlACC_SubBasicAccountProvider = new SqlACC_SubBasicAccountProvider();
aCC_SubBasicAccount = sqlACC_SubBasicAccountProvider.GetACC_SubBasicAccountBySubBasicAccountID(SubBasicAccountID);
return aCC_SubBasicAccount;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
ACC_SubBasicAccount aCC_SubBasicAccount = new ACC_SubBasicAccount();
// aCC_SubBasicAccount.SubBasicAccountID= int.Parse(ddlSubBasicAccountID.SelectedValue);
aCC_SubBasicAccount.SubBasicAccountCode = "";
aCC_SubBasicAccount.SubBasicAccountName = txtSubBasicAccountName.Text;
aCC_SubBasicAccount.Description = txtDescription.Text;
aCC_SubBasicAccount.BasicAccountID = int.Parse(ddlBasicAccountID.SelectedValue);
aCC_SubBasicAccount.AddedBy = Profile.card_id;
aCC_SubBasicAccount.AddedDate = DateTime.Now;
aCC_SubBasicAccount.UpdatedBy = Profile.card_id;
aCC_SubBasicAccount.UpdateDate = DateTime.Now;
aCC_SubBasicAccount.RowStatusID = 1;
int resutl = ACC_SubBasicAccountManager.InsertACC_SubBasicAccount(aCC_SubBasicAccount);
Response.Redirect("AdminDisplayACC_SubBasicAccount.aspx");
}
catch (Exception ex)
{
}
}
public bool UpdateACC_SubBasicAccount(ACC_SubBasicAccount aCC_SubBasicAccount)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateACC_SubBasicAccount", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SubBasicAccountID", SqlDbType.Int).Value = aCC_SubBasicAccount.SubBasicAccountID;
cmd.Parameters.Add("@SubBasicAccountCode", SqlDbType.NVarChar).Value = aCC_SubBasicAccount.SubBasicAccountCode;
cmd.Parameters.Add("@SubBasicAccountName", SqlDbType.NVarChar).Value = aCC_SubBasicAccount.SubBasicAccountName;
cmd.Parameters.Add("@Description", SqlDbType.NText).Value = aCC_SubBasicAccount.Description;
cmd.Parameters.Add("@BasicAccountID", SqlDbType.Int).Value = aCC_SubBasicAccount.BasicAccountID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = aCC_SubBasicAccount.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = aCC_SubBasicAccount.UpdateDate;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = aCC_SubBasicAccount.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public ACC_SubBasicAccount GetACC_SubBasicAccountFromReader2(IDataReader reader)
{
try
{
ACC_SubBasicAccount aCC_SubBasicAccount = new ACC_SubBasicAccount
(
DataAccessObject.IsNULL<int>(reader["SubBasicAccountID"]),
DataAccessObject.IsNULL<int>(reader["BasicAccountID"])
);
return aCC_SubBasicAccount;
}
catch (Exception ex)
{
return null;
}
}
public ACC_SubBasicAccount GetACC_SubBasicAccountFromReader(IDataReader reader)
{
try
{
ACC_SubBasicAccount aCC_SubBasicAccount = new ACC_SubBasicAccount
(
DataAccessObject.IsNULL<int>(reader["SubBasicAccountID"]),
DataAccessObject.IsNULL<string>(reader["SubBasicAccountCode"]),
DataAccessObject.IsNULL<string>(reader["SubBasicAccountName"]),
DataAccessObject.IsNULL<string>(reader["Description"]),
DataAccessObject.IsNULL<int>(reader["BasicAccountID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"]),
DataAccessObject.IsNULL<int>(reader["RowStatusID"])
);
return aCC_SubBasicAccount;
}
catch(Exception ex)
{
return null;
}
}
public static ACC_SubBasicAccount GetCOMN_RowStatusByRowStatusID(int RowStatusID)
{
ACC_SubBasicAccount aCC_SubBasicAccount = new ACC_SubBasicAccount();
SqlACC_SubBasicAccountProvider sqlACC_SubBasicAccountProvider = new SqlACC_SubBasicAccountProvider();
aCC_SubBasicAccount = sqlACC_SubBasicAccountProvider.GetACC_SubBasicAccountByRowStatusID(RowStatusID);
return aCC_SubBasicAccount;
}
public static bool UpdateACC_SubBasicAccount(ACC_SubBasicAccount aCC_SubBasicAccount)
{
SqlACC_SubBasicAccountProvider sqlACC_SubBasicAccountProvider = new SqlACC_SubBasicAccountProvider();
return sqlACC_SubBasicAccountProvider.UpdateACC_SubBasicAccount(aCC_SubBasicAccount);
}
public static int InsertACC_SubBasicAccount(ACC_SubBasicAccount aCC_SubBasicAccount)
{
SqlACC_SubBasicAccountProvider sqlACC_SubBasicAccountProvider = new SqlACC_SubBasicAccountProvider();
return sqlACC_SubBasicAccountProvider.InsertACC_SubBasicAccount(aCC_SubBasicAccount);
}
public void _loadReport()
{
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
try
{
startDate = txtStartDate.Text != "" ? Convert.ToDateTime(txtStartDate.Text) : DateTime.Parse("1 / 1 / 1753");
startDate = startDate.AddDays(1);
}
catch (Exception ex)
{
startDate = DateTime.MinValue;
}
try
{
DateTime date = new DateTime();
date = txtEndDate.Text != "" ? Convert.ToDateTime(txtEndDate.Text) : DateTime.Now.AddDays(1);
endDate = date.AddDays(1);
}
catch (Exception ex)
{
endDate = DateTime.Now;
}
decimal sumAssets = 0, sumCapital = 0, sumLiability=0;
List<ACC_SubBasicAccount> assets = new List<ACC_SubBasicAccount>();
List<ACC_SubBasicAccount> capital = new List<ACC_SubBasicAccount>();
List<ACC_SubBasicAccount> liability = new List<ACC_SubBasicAccount>();
List<ACC_SubBasicAccount> balanseSheet = new List<ACC_SubBasicAccount>();
List<ACC_SubBasicAccount> subBasicAccounts = ACC_SubBasicAccountManager.ViewACC_BalanceSheetByDateRange(startDate, endDate);
foreach (ACC_SubBasicAccount subBasicAccount in subBasicAccounts)
{
decimal credit = 0, debit = 0;
string headName = "";
if (subBasicAccount.BasicAccountID == 1)
{
List<ACC_Account> accounts = ACC_AccountManager.GetAllAccountBySubBasicAccountID(subBasicAccount.SubBasicAccountID);
foreach (ACC_Account account in accounts)
{
List<ACC_Journal> accountJournals = ACC_JournalManager.ViewAllACC_JournalsByAccountID(account.AccountID, startDate, endDate);
foreach (ACC_Journal accountJournal in accountJournals)
{
credit = credit + accountJournal.Credit;
debit = debit + accountJournal.Debit;
headName = accountJournal.HeadName;
}
}
subBasicAccount.HeadName = headName;
subBasicAccount.SubBasicAccountName = ACC_SubBasicAccountManager.GetACC_SubBasicAccountBySubBasicAccountID(subBasicAccount.SubBasicAccountID).SubBasicAccountName;
subBasicAccount.Asset = debit - credit;
sumAssets = sumAssets + subBasicAccount.Asset;
subBasicAccount.SumAsset = sumAssets;
subBasicAccount.AssetAccountName = subBasicAccount.SubBasicAccountName;
assets.Add(subBasicAccount);
}
else if (subBasicAccount.BasicAccountID == 4)
{
List<ACC_Account> accounts = ACC_AccountManager.GetAllAccountBySubBasicAccountID(subBasicAccount.SubBasicAccountID);
foreach (ACC_Account account in accounts)
{
List<ACC_Journal> accountJournals = ACC_JournalManager.ViewAllACC_JournalsByAccountID(account.AccountID, startDate, endDate);
foreach (ACC_Journal accountJournal in accountJournals)
{
credit = credit + accountJournal.Credit;
debit = debit + accountJournal.Debit;
headName = accountJournal.HeadName;
}
}
subBasicAccount.HeadName = headName;
subBasicAccount.SubBasicAccountName = ACC_SubBasicAccountManager.GetACC_SubBasicAccountBySubBasicAccountID(subBasicAccount.SubBasicAccountID).SubBasicAccountName;
subBasicAccount.Liability = credit - debit;
sumLiability = sumLiability + subBasicAccount.Liability;
subBasicAccount.SumLiability = sumLiability;
subBasicAccount.LiabilityAccountName = subBasicAccount.SubBasicAccountName;
liability.Add(subBasicAccount);
}
else if (subBasicAccount.BasicAccountID == 5)
{
List<ACC_Account> accounts = ACC_AccountManager.GetAllAccountBySubBasicAccountID(subBasicAccount.SubBasicAccountID);
foreach (ACC_Account account in accounts)
{
List<ACC_Journal> accountJournals = ACC_JournalManager.ViewAllACC_JournalsByAccountID(account.AccountID, startDate, endDate);
foreach (ACC_Journal accountJournal in accountJournals)
{
credit = credit + accountJournal.Credit;
debit = debit + accountJournal.Debit;
headName = accountJournal.HeadName;
}
}
subBasicAccount.HeadName = headName;
subBasicAccount.SubBasicAccountName = ACC_SubBasicAccountManager.GetACC_SubBasicAccountBySubBasicAccountID(subBasicAccount.SubBasicAccountID).SubBasicAccountName;
subBasicAccount.Capital = credit - debit;
sumCapital = sumCapital + subBasicAccount.Capital;
subBasicAccount.SumCapital = sumCapital;
subBasicAccount.CapitalAccountName = subBasicAccount.SubBasicAccountName;
capital.Add(subBasicAccount);
}
}
ACC_SubBasicAccount subBasic = new ACC_SubBasicAccount();
subBasic.StartDate = txtStartDate.Text;
subBasic.EndDate = txtEndDate.Text;
//if (sumExpense > 0 && sumIncome > sumExpense)
//{
// subBasic.NetIncome = sumIncome - sumExpense;
//}
//else
//{
// subBasic.NetIncome = 0;
//}
balanseSheet.Add(subBasic);
ReportDocument rptDoc = new ReportDocument();
rptDoc.Load(Server.MapPath("~/Accounting/Report/BalanceSheetView.rpt"));
rptDoc.OpenSubreport("AssetBalanceSheet.rpt").SetDataSource(assets);
rptDoc.OpenSubreport("CapitalBalanceSheet.rpt").SetDataSource(capital);
rptDoc.OpenSubreport("LiabilityBalanceSheet.rpt").SetDataSource(liability);
rptDoc.SetDataSource(balanseSheet);
this.crvBalanceSheet.EnableDatabaseLogonPrompt = false;
crvBalanceSheet.ReportSource = rptDoc;
crvBalanceSheet.Zoom(83);
}
private void showACC_SubBasicAccountData()
{
ACC_SubBasicAccount aCC_SubBasicAccount = new ACC_SubBasicAccount ();
aCC_SubBasicAccount = ACC_SubBasicAccountManager.GetACC_SubBasicAccountBySubBasicAccountID(Int32.Parse(Request.QueryString["ID"]));
txtSubBasicAccountName.Text =aCC_SubBasicAccount.SubBasicAccountName.ToString();
txtDescription.Text =aCC_SubBasicAccount.Description.ToString();
ddlBasicAccountID.SelectedValue =aCC_SubBasicAccount.BasicAccountID.ToString();
}
