public MonthlySalesPurchase GetSalesPurchase(MonthlySalesPurchase data) { MonthlySalesPurchase monthlySales = new MonthlySalesPurchase(); monthlySales.MonthlyItemList = new List <MonthlySalesPurchaseItem>(); MonthlySalesPurchaseItem MSP = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[Accounts].[MonthlySalesPurchase]"; cmd.Parameters.Add("@SummaryType", SqlDbType.NVarChar, 10).Value = data.summarytype; cmd.Parameters.Add("@IsInternal", SqlDbType.Bit).Value = data.IsInternal; cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { while (sdr.Read()) { MSP = new MonthlySalesPurchaseItem(); MSP.Period = (sdr["Period"].ToString() != "" ? (sdr["Period"].ToString()) : MSP.Period); MSP.Sales = (sdr["Sales"].ToString() != "" ? decimal.Parse(sdr["Sales"].ToString()) : MSP.Sales); MSP.Purchase = (sdr["Purchase"].ToString() != "" ? decimal.Parse(sdr["Purchase"].ToString()) : MSP.Purchase); monthlySales.MonthlyItemList.Add(MSP); } } } } } } catch (Exception ex) { throw ex; } return(monthlySales); }
public MonthlySalesPurchase GetSalesPurchase(MonthlySalesPurchase data) { MonthlySalesPurchase Result = _dashboardRepository.GetSalesPurchase(data); if (Result != null) { foreach (MonthlySalesPurchaseItem m in Result.MonthlyItemList) { Result.TotalIncome = Result.TotalIncome + m.Sales; Result.TotalExpense = Result.TotalExpense + m.Purchase; } Result.Caption = Result.MonthlyItemList[0].Period + "-" + Result.MonthlyItemList[11].Period; } return(Result); }