public ActionResult CreateTrialBalance_Group() { OrganizationService objIOrganizationService = new OrganizationService(); OrganizationDto organizationDto = objIOrganizationService.GetAll(); ViewBag.OrganizationDetails = organizationDto; TrialBalanceTotalsDto objTotals = new TrialBalanceTotalsDto(); List <TrialBalanceDto> lstTrialBalance = GetAllTrialBalanceReport_Group(objTotals); ViewBag.TrialBalanceTotals = objTotals; return(View("CreateTrialBalance", lstTrialBalance)); }
public List <TrialBalanceDto> GetAllTrialBalanceReport(TrialBalanceTotalsDto objTotals = null) { if (objTotals == null) { objTotals = new TrialBalanceTotalsDto(); } List <TrialBalanceDto> lstTrialBalance = new List <TrialBalanceDto>(); SqlCommand cmd = new SqlCommand("uspTrialBalanceReport", con); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrialBalanceDto obj = new TrialBalanceDto(); obj.Ahcode = dr["AHCODE"] == DBNull.Value ? string.Empty : dr["AHCODE"].ToString(); obj.Accounthaedname = dr["ACCOUNTHEADNAME"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ACCOUNTHEADNAME"]); obj.Debit1 = dr["OPENING_BALANCE_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OPENING_BALANCE_DEBIT"]); obj.Credit1 = dr["OPENING_BALANCE_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OPENING_BALANCE_CREDIT"]); obj.Debit2 = dr["TRAN_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_DEBIT"]); obj.Credit2 = dr["TRAN_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_CREDIT"]); obj.Debit3 = dr["CLOSING_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_DEBIT"]); obj.Credit3 = dr["CLOSING_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_CREDIT"]); lstTrialBalance.Add(obj); } if (dr.NextResult()) { if (dr.Read()) { objTotals.TotalRecords = dr["TOTAL_RECORDS"] == DBNull.Value ? default(int) : Convert.ToInt32(dr["TOTAL_RECORDS"]); objTotals.OpeningBalDrSum = dr["OB_DR_Sum"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OB_DR_Sum"]); objTotals.OpeningBalCrSum = dr["OB_CR_SUM"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OB_CR_SUM"]); objTotals.TranBalDrSum = dr["TRAN_DR_SUM"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_DR_SUM"]); objTotals.TranBalCrSum = dr["TRAN_CR_SUM"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_CR_SUM"]); objTotals.ClosingBalDrSum = dr["CLOSING_DR_SUM"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_DR_SUM"]); objTotals.ClosingBalCrSum = dr["CLOSING_CR_SUM"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_CR_SUM"]); } } return(lstTrialBalance); }
public List <TrialBalanceDto> GetAllTrialBalanceReport_Group(TrialBalanceTotalsDto objTotals = null) { OrganizationService objIOrganizationService = new OrganizationService(); OrganizationDto organizationDto = objIOrganizationService.GetAll(); int GroupID = GroupInfo != null ? GroupInfo.GroupID : 0; if (objTotals == null) { objTotals = new TrialBalanceTotalsDto(); } List <TrialBalanceDto> lstTrialBalance = new List <TrialBalanceDto>(); SqlCommand cmd = new SqlCommand("uspTrialBalanceReport", con); cmd.Parameters.Add(new SqlParameter("GroupID", GroupID)); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { TrialBalanceDto obj = new TrialBalanceDto(); obj.OrganizationName = organizationDto.OrgName; obj.OrganizationAddress = organizationDto.Address; obj.Ahcode = dr["AHCODE"] == DBNull.Value ? string.Empty : dr["AHCODE"].ToString(); obj.AhType = dr["AHType"] == DBNull.Value ? default(Int32) : Convert.ToInt32(dr["AHType"]); obj.Accounthaedname = dr["ACCOUNTHEADNAME"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ACCOUNTHEADNAME"]); obj.Debit1 = dr["OPENING_BALANCE_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OPENING_BALANCE_DEBIT"]); obj.Credit1 = dr["OPENING_BALANCE_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OPENING_BALANCE_CREDIT"]); obj.Debit2 = dr["TRAN_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_DEBIT"]); obj.Credit2 = dr["TRAN_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_CREDIT"]); obj.Debit3 = dr["CLOSING_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_DEBIT"]); obj.Credit3 = dr["CLOSING_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_CREDIT"]); lstTrialBalance.Add(obj); } if (dr.NextResult()) { if (dr.Read()) { if (Convert.ToInt32(dr["TOTAL_RECORDS"]) != 0) { objTotals.TotalRecords = Convert.ToInt32(dr["TOTAL_RECORDS"]); } if (dr["OB_DR_Sum"] != DBNull.Value) { objTotals.OpeningBalDrSum = Convert.ToDouble(dr["OB_DR_Sum"]); } if (dr["OB_CR_SUM"] != DBNull.Value) { objTotals.OpeningBalCrSum = Convert.ToDouble(dr["OB_CR_SUM"]); } if (dr["TRAN_DR_SUM"] != DBNull.Value) { objTotals.TranBalDrSum = Convert.ToDouble(dr["TRAN_DR_SUM"]); } if (dr["TRAN_CR_SUM"] != DBNull.Value) { objTotals.TranBalCrSum = Convert.ToDouble(dr["TRAN_CR_SUM"]); } if (dr["CLOSING_DR_SUM"] != DBNull.Value) { objTotals.ClosingBalDrSum = Convert.ToDouble(dr["CLOSING_DR_SUM"]); } if (dr["CLOSING_CR_SUM"] != DBNull.Value) { objTotals.ClosingBalCrSum = Convert.ToDouble(dr["CLOSING_CR_SUM"]); } } } return(lstTrialBalance); }
public List <TrialBalanceDto> GetAllTrialBalanceReport_Group(int groupID, TrialBalanceTotalsDto objTotals = null) { if (objTotals == null) { objTotals = new TrialBalanceTotalsDto(); } List <TrialBalanceDto> lstTrialBalance = new List <TrialBalanceDto>(); AdoHelper objado = new AdoHelper(); SqlParameter[] parms = new SqlParameter[1]; parms[0] = new SqlParameter("@GroupID", groupID); parms[0].SqlDbType = System.Data.SqlDbType.Int; SqlDataReader dr = objado.ExecDataReaderProc("uspTrialBalanceReport", parms); while (dr.Read()) { TrialBalanceDto obj = new TrialBalanceDto(); obj.Ahcode = dr["AHCODE"] == DBNull.Value ? string.Empty : dr["AHCODE"].ToString(); obj.AhType = dr["AHType"] == DBNull.Value ? default(Int32) : Convert.ToInt32(dr["AHType"]); obj.Accounthaedname = dr["ACCOUNTHEADNAME"] == DBNull.Value ? string.Empty : Convert.ToString(dr["ACCOUNTHEADNAME"]); obj.Debit1 = dr["OPENING_BALANCE_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OPENING_BALANCE_DEBIT"]); obj.Credit1 = dr["OPENING_BALANCE_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OPENING_BALANCE_CREDIT"]); obj.Debit2 = dr["TRAN_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_DEBIT"]); obj.Credit2 = dr["TRAN_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["TRAN_CREDIT"]); obj.Debit3 = dr["CLOSING_DEBIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_DEBIT"]); obj.Credit3 = dr["CLOSING_CREDIT"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["CLOSING_CREDIT"]); lstTrialBalance.Add(obj); } if (dr.NextResult()) { if (dr.Read()) { if (Convert.ToInt32(dr["TOTAL_RECORDS"]) != 0) { objTotals.TotalRecords = Convert.ToInt32(dr["TOTAL_RECORDS"]); } if (dr["OB_DR_Sum"] != DBNull.Value) { objTotals.OpeningBalDrSum = Convert.ToDouble(dr["OB_DR_Sum"]); } if (dr["OB_CR_SUM"] != DBNull.Value) { objTotals.OpeningBalCrSum = Convert.ToDouble(dr["OB_CR_SUM"]); } if (dr["TRAN_DR_SUM"] != DBNull.Value) { objTotals.TranBalDrSum = Convert.ToDouble(dr["TRAN_DR_SUM"]); } if (dr["TRAN_CR_SUM"] != DBNull.Value) { objTotals.TranBalCrSum = Convert.ToDouble(dr["TRAN_CR_SUM"]); } if (dr["CLOSING_DR_SUM"] != DBNull.Value) { objTotals.ClosingBalDrSum = Convert.ToDouble(dr["CLOSING_DR_SUM"]); } if (dr["CLOSING_CR_SUM"] != DBNull.Value) { objTotals.ClosingBalCrSum = Convert.ToDouble(dr["CLOSING_CR_SUM"]); } } } return(lstTrialBalance); }