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