public long Add(SalesForecast obj)
{
try
{
SqlParameter SFNO = new SqlParameter();
SFNO.Direction = ParameterDirection.Output;
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@RevisionNo", obj.RevisionNo),
new SqlParameter("@Year", obj.Year),
new SqlParameter("@Month", obj.Month),
new SqlParameter("@WeekID", obj.WeekID),
new SqlParameter("@Accuracy", obj.Accuracy),
new SqlParameter("@State", obj.State),
new SqlParameter("@EenteredBy", obj.EenteredBy),
new SqlParameter("@ProductCategory", obj.ProductCategory),
new SqlParameter("@outParam", SqlDbType.Int, 120)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_Output(Connection, "SPADD_SalesForecast", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public void Calculate(object Sender, EventArgs e)
{
SalesForecast salesForecast = new SalesForecast();
Console.WriteLine("Hello from calculate");
salesForecast.Date = ValidateDate(salesForecastView.DateText);
salesForecast.TicketsSold = Validate(salesForecastView.TicketsSoldText);
salesForecast.TVCover = Validate(salesForecastView.TVCoverText);
salesForecast.SportsVisitors = Validate(salesForecastView.SportsVisitorsText);
salesForecast.FitnessSubscribers = Validate(salesForecastView.FitnessSubscribersText);
salesForecast.VisitorsAppear = Validate(salesForecastView.VisitorsAppearText);
salesForecastView.TotalSalesText = ValidationCheck ?
salesForecast.CalculateSales().ToString("C2", CultureInfo.CreateSpecificCulture("da-DK")) : "";
salesForecastView.TotalExpensesText = ValidationCheck ?
salesForecast.CalculateExpenses().ToString("C2", CultureInfo.CreateSpecificCulture("da-DK")) : "";
salesForecastView.TotalEarningsText = ValidationCheck ?
salesForecast.CalculateEarnings().ToString("C2", CultureInfo.CreateSpecificCulture("da-DK")) : "";
}
//------------------------------------------------------------------------------------------------------------
//public long test(String year, String month, String week, String fcastid, String pid,String qty)
public long test(SalesForecast obj1, SalesForecastDetails obj2)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@prmYear", obj1.Year),
new SqlParameter("@prmMonth", obj1.Month),
new SqlParameter("@prmWeekID", obj1.WeekID),
new SqlParameter("@SalesForecastID", obj2.SalesForecastID),
new SqlParameter("@ProductCode", obj2.ProductCode),
new SqlParameter("@Qty", obj2.Qty),
new SqlParameter("@outParam", SqlDbType.Int, 120)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "zzz5", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private List <SalesForecast> PopulateSalesForecast(string lifeCycleStage, string parentCustomer)
{
SalesForecast salesForecast;
List <SalesForecast> list = new List <SalesForecast>();
try
{
using (SqlConnection connection = new SqlConnection("Server=eeisql1;Database=MONITOR;User Id=Andre;"))
{
SqlCommand command = new SqlCommand("eeiuser.usp_WP_SalesForecastSummaries_LifeCycle_MaterialPercentage", connection);
command.CommandTimeout = 180;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@Filter", SqlDbType.VarChar).Value = lifeCycleStage;
command.Parameters.Add("@ParentCustomerFilter", SqlDbType.VarChar).Value = parentCustomer;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
salesForecast = new SalesForecast();
salesForecast.Customer = reader["Customer"].ToString();
salesForecast.BasePart = reader["BasePart"].ToString();
salesForecast.DisplaySOP = reader["DisplaySOP"].ToString();
salesForecast.DisplayEOP = reader["DisplayEOP"].ToString();
salesForecast.MaterialPercentage = reader["MaterialPercentage"].ToString();
salesForecast.Sales_2016 = ReaderToDecimal(reader, "Sales_2016");
salesForecast.Sales_2017 = ReaderToDecimal(reader, "Sales_2017");
salesForecast.Sales_2018 = ReaderToDecimal(reader, "Sales_2018");
salesForecast.Sales_2019 = ReaderToDecimal(reader, "Sales_2019");
salesForecast.Sales_2020 = ReaderToDecimal(reader, "Sales_2020");
salesForecast.Sales_2021 = ReaderToDecimal(reader, "Sales_2021");
salesForecast.Sales_2022 = ReaderToDecimal(reader, "Sales_2022");
salesForecast.Sales_2023 = ReaderToDecimal(reader, "Sales_2023");
salesForecast.Sales_2024 = ReaderToDecimal(reader, "Sales_2024");
salesForecast.Sales_2025 = ReaderToDecimal(reader, "Sales_2025");
salesForecast.Change_2017 = ReaderToDecimal(reader, "Change_2017");
salesForecast.Change_2018 = ReaderToDecimal(reader, "Change_2018");
salesForecast.Change_2019 = ReaderToDecimal(reader, "Change_2019");
salesForecast.Change_2020 = ReaderToDecimal(reader, "Change_2020");
salesForecast.Change_2021 = ReaderToDecimal(reader, "Change_2021");
salesForecast.Change_2022 = ReaderToDecimal(reader, "Change_2022");
salesForecast.Change_2023 = ReaderToDecimal(reader, "Change_2023");
salesForecast.Change_2024 = ReaderToDecimal(reader, "Change_2024");
salesForecast.Change_2025 = ReaderToDecimal(reader, "Change_2025");
list.Add(salesForecast);
}
}
connection.Close();
}
}
catch (Exception ex)
{
RadWindowManager1.RadAlert("Error: " + ex.Message, 330, 180, "Error at Summaries Material Percentage", "");
}
//foreach(var item in list)
//{
// RadWindowManager1.RadAlert("ListItem: " + item.Customer, 330, 180, "Message", "");
//}
return(list);
}
