public ReceiptsAndPaymentsListDto GetAllReceiptsAndPayments() { List <ReceiptsAndPaymentsDto> lst = new List <ReceiptsAndPaymentsDto>(); int GroupId = GroupInfo.GroupID; SqlCommand cmd = new SqlCommand("uspGroupReceiptAndPayments", con); cmd.Parameters.Add(new SqlParameter("GroupID", GroupId)); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandTimeout = 0; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ReceiptsAndPaymentsListDto objdto = new ReceiptsAndPaymentsListDto(); while (dr.Read()) { ReceiptsAndPaymentsDto obj = new ReceiptsAndPaymentsDto(); obj.Ahid = dr["Ahid"] == DBNull.Value ? default(Int32) : Convert.ToInt32(dr["Ahid"]); obj.SLAccountHead = dr["SLAccountHead"] == DBNull.Value ? string.Empty : Convert.ToString(dr["SLAccountHead"]); obj.OpeningBalance = dr["OpeningBalance"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OpeningBalance"]); obj.April = dr["Apr"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Apr"]); obj.May = dr["May"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["May"]); obj.June = dr["Jun"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Jun"]); obj.July = dr["Jul"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Jul"]); obj.August = dr["Aug"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Aug"]); obj.Sep = dr["Sep"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Sep"]); obj.Oct = dr["Oct"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Oct"]); obj.Nov = dr["Nov"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Nov"]); obj.Dec = dr["Dec"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Dec"]); obj.Jan = dr["Jan"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Jan"]); obj.Feb = dr["Feb"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Feb"]); obj.March = dr["Mar"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Mar"]); lst.Add(obj); } objdto.lstReceiptDto = lst; while (dr.NextResult()) { while (dr.Read()) { ReceiptsAndPaymentsDto obj = new ReceiptsAndPaymentsDto(); obj.Ahid = dr["Ahid"] == DBNull.Value ? default(Int32) : Convert.ToInt32(dr["Ahid"]); obj.SLAccountHead = dr["SLAccountHead"] == DBNull.Value ? string.Empty : Convert.ToString(dr["SLAccountHead"]); obj.OpeningBalance = dr["OpeningBalance"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["OpeningBalance"]); obj.April = dr["Apr"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Apr"]); obj.May = dr["May"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["May"]); obj.June = dr["Jun"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Jun"]); obj.July = dr["Jul"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Jul"]); obj.August = dr["Aug"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Aug"]); obj.Sep = dr["Sep"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Sep"]); obj.Oct = dr["Oct"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Oct"]); obj.Nov = dr["Nov"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Nov"]); obj.Dec = dr["Dec"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Dec"]); obj.Jan = dr["Jan"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Jan"]); obj.Feb = dr["Feb"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Feb"]); obj.March = dr["Mar"] == DBNull.Value ? default(double) : Convert.ToDouble(dr["Mar"]); } } objdto.lstPaymentsDto = lst; return(objdto); }
public ActionResult IncomeAndExpenditure() { OrganizationService objIOrganizationService = new OrganizationService(); OrganizationDto organizationDto = objIOrganizationService.GetAll(); ViewBag.OrganizationDetails = organizationDto; ReceiptsAndPaymentsDto reptsAndpmts = new ReceiptsAndPaymentsDto(); ReceiptsAndPaymentsListDto lstreptsAndpmts = GetAllIncomeAndExpenditure(); return(View(lstreptsAndpmts)); }