public void UpdateSf(GetSalesForecastUpdated_Result u)
{
using (var context = new MONITOREntities1())
{
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
DateTime?verifiedEopDate = null;
switch (u.VerifiedEop)
{
case "CSM":
verifiedEopDate = u.CsmEop;
break;
case "Empire":
verifiedEopDate = u.EmpireEop;
break;
case "MidModel":
verifiedEopDate = u.MidModelYear;
break;
}
context.usp_Web_SalesForecastUpdated_UpdateBasePartCloseouts(OperatorCode, u.BasePart, u.VerifiedEop, verifiedEopDate, u.SchedulerResponsible, u.RfMpsLink, u.SchedulingTeamComments,
u.MaterialsComments, u.ShipToLocation, u.FgInventoryAfterBuildout, u.CostEach, u.ExcessFgAfterBuildout, u.ExcessRmAfterBuildout, u.ProgramExposure,
u.DateToSendCoLetter, u.ObsolescenceCost, tranDT, result);
}
}
public void GetSchedulers()
{
Error = "";
var tranDt = new ObjectParameter("TranDT", typeof(DateTime?));
var res = new ObjectParameter("Result", typeof(int?));
var debugMsg = new ObjectParameter("DebugMsg", typeof(string));
int debug = 0;
SchedulersList.Clear();
using (var context = new MONITOREntities1())
{
try
{
var empty = new SchedulersDataModel();
empty.Scheduler = "";
SchedulersList.Add(empty);
var query = context.usp_PlanningSnapshot_Q_GetSchedulers(tranDt, res, debug, debugMsg);
foreach (var item in query)
{
var scheduler = new SchedulersDataModel();
scheduler.SchedulerId = item.SchedulerID;
scheduler.Scheduler = item.SchedulerName;
SchedulersList.Add(scheduler);
}
}
catch (Exception ex)
{
Error = (ex.InnerException == null) ? ex.Message : ex.InnerException.Message;
}
}
}
public int SearchForExistingSalesLead(int combinedLightingId)
{
var res = new ObjectParameter("Result", typeof(Int32));
var td = new ObjectParameter("TranDT", typeof(DateTime));
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
_context.usp_ST_SalesLeadLog_Hitlist_SearchForSalesLeads(combinedLightingId, td, res);
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = error;
_messageBox.ShowDialog();
return(0);
}
return(1);
}
public void GetSalesLeadContactInfo(int rowId)
{
var res = new ObjectParameter("Result", typeof(Int32));
var td = new ObjectParameter("TranDT", typeof(DateTime));
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
var queryResult = _context.usp_ST_SalesLeadLog_GetContactInfo(rowId, td, res);
foreach (var item in queryResult.ToList())
{
ContactName = item.ContactName;
ContactPhone = item.ContactPhoneNumber;
ContactEmail = item.ContactPhoneNumber;
}
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = string.Format("Failed to return contact info. Error: {0}", error);
_messageBox.ShowDialog();
}
}
public int SaveSalesLeadActivity(string operatorCode, int?combinedLightingId, int?salesLeadId, int salesLeadStatus, int?activityRowId, string activity,
DateTime activityDate, string meetingLoc, string contactName, string contactPhone, string contactEmail, decimal duration, string notes, string quoteNumber, int?awardedVolume)
{
var res = new ObjectParameter("Result", typeof(Int32));
var td = new ObjectParameter("TranDT", typeof(DateTime));
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
_context.usp_ST_SalesLeadLog_Hitlist_Update(operatorCode, combinedLightingId, salesLeadId, salesLeadStatus, activityRowId, activity,
activityDate, meetingLoc, contactName, contactPhone, contactEmail, duration, notes, quoteNumber, awardedVolume, td, res);
_messageBox.Message = "Success.";
_messageBox.ShowDialog();
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = string.Format("Failed to save sales lead activity. Error: {0}", error);
_messageBox.ShowDialog();
return(0);
}
return(1);
}
public List <GetSalesForecastUpdated_Result> GetSf(int eop, int filter)
{
List <GetSalesForecastUpdated_Result> sfList;
using (var context = new MONITOREntities1())
{
sfList = context.usp_Web_SalesForecastUpdated_GetSalesForecastUpdated(eop, filter).ToList();
}
return(sfList);
}
public int GetGridDataAllCustomersAllYears()
{
SalesLeadsList.Clear();
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
var q = from cl in _context.vw_ST_LightingStudy_Hitlist_2016
where cl.SOPYear == 2017 || cl.SOPYear == 2018 || cl.SOPYear == 2019
orderby cl.SOP, cl.Program
select cl;
foreach (var item in q.ToList())
{
_salesLeadDataModel = new SalesLeadDataModel
{
Customer = item.Customer,
Program = item.Program,
Application = item.Application,
Sop = item.SOP,
Eop = item.EOP,
Volume = string.Format("{0:n0}", item.PeakYearlyVolume),
Status = item.Status,
AwardedVolume = (item.AwardedVolume.HasValue) ? string.Format("{0:n0}", item.AwardedVolume) : "",
ID = item.ID
};
SalesLeadsList.Add(_salesLeadDataModel);
}
if (SalesLeadsList.Count < 1)
{
_messageBox.Message = "No sales leads were found.";
_messageBox.ShowDialog();
return(0);
}
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = string.Format("Failed to return sales lead data. Error: {0}", error);
_messageBox.ShowDialog();
return(0);
}
return(1);
}
public void GetSalesLeadsBySalesPerson(string operatorCode)
{
var res = new ObjectParameter("Result", typeof(Int32));
var td = new ObjectParameter("TranDT", typeof(DateTime));
try
{
SalesLeadList.Clear();
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
var queryResult = _context.usp_ST_SalesLeadLog_Hitlist_GetActivity(operatorCode, td, res);
foreach (var item in queryResult.ToList())
{
_salesLeadActivityDataModel = new SalesLeadActivityDataModel
{
Customer = item.Customer,
Program = item.Program,
Application = item.Application,
Sop = item.SOP,
Eop = item.EOP,
Status = item.Status,
PeakVolume = string.Format("{0:n0}", item.PeakYearlyVolume),
LastSalesActivity = item.LastSalesActivity,
ID = item.ID,
SalesLeadID = item.SalesLeadID
};
SalesLeadList.Add(_salesLeadActivityDataModel);
}
if (SalesLeadList.Count < 1)
{
_messageBox.Message = "You have no open sales leads.";
_messageBox.ShowDialog();
}
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = string.Format("Failed to return sales lead data. Error: {0}", error);
_messageBox.ShowDialog();
}
}
public void GetSalesActivityHistory(int salesLeadId)
{
var res = new ObjectParameter("Result", typeof(Int32));
var td = new ObjectParameter("TranDT", typeof(DateTime));
SalesLeadHistoryList.Clear();
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
var queryResult = _context.usp_ST_SalesLeadLog_GetActivityHistory(salesLeadId, td, res);
foreach (var item in queryResult.ToList())
{
_salesLeadHistoryDataModel = new SalesLeadHistoryDataModel
{
SalesPerson = item.SalesPerson,
Status = item.StatusType,
Activity = item.Activity,
ActivityDate = item.ActivityDate,
Duration = item.Duration,
ContactName = item.ContactName,
ContactEmailAddress = item.ContactEmailAddress,
ContactPhoneNumber = item.ContactPhoneNumber,
Notes = item.Notes,
QuoteNumber = item.QuoteNumber,
AwardedVolume = (item.AwardedVolume.HasValue) ? item.AwardedVolume.ToString() : "",
RowId = item.RowID
};
SalesLeadHistoryList.Add(_salesLeadHistoryDataModel);
}
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = string.Format("Failed to return activity history for this sales lead. Error: {0}", error);
_messageBox.ShowDialog();
}
}
public void GetEopYears()
{
Error = "";
EopYearList.Clear();
using (var context = new MONITOREntities1())
{
try
{
var query = context.usp_Web_SalesForecastUpdated_GetEopYears();
foreach (var item in query)
{
var eopYear = new EopYearDataModel();
eopYear.EmpireEopYear = item.EopYear;
EopYearList.Add(eopYear);
}
}
catch (Exception ex)
{
Error = (ex.InnerException == null) ? ex.Message : ex.InnerException.Message;
}
}
}
public List <string> GetCustomers(out string error)
{
error = "";
var customersList = new List <string>();
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
_context.vw_ST_LightingStudy_Hitlist_2016.Load();
if (!_context.vw_ST_LightingStudy_Hitlist_2016.Any())
{
return(null);
}
var q = from cl in _context.vw_ST_LightingStudy_Hitlist_2016
group cl by new { cl.Customer }
into clGroup
orderby clGroup.Key.Customer
select new { cust = clGroup.Key.Customer };
customersList.Add("");
customersList.Add("All");
customersList.AddRange(q.Select(item => item.cust));
return(customersList);
}
}
catch (Exception ex)
{
error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
}
return(null);
}
public SalesLeadsActivityController()
{
_context = new MONITOREntities1();
_messageBox = new CustomMessageBox();
}
public SalesLeadsController()
{
_context = new MONITOREntities1();
_messageBox = new CustomMessageBox();
//BindingSource = new BindingSource();
}
public int GetGridDataOneCustomerOneYear(string customer, string year)
{
//var res = new ObjectParameter("Result", typeof(Int32));
//var td = new ObjectParameter("TranDT", typeof(DateTime));
//BindingSource = null;
//BindingSource = new BindingSource();
int iYear;
try
{
iYear = Convert.ToInt32(year);
}
catch (Exception ex)
{
_messageBox.Message = string.Format("Year must be numeric");
_messageBox.ShowDialog();
return(0);
}
SalesLeadsList.Clear();
try
{
if (_context != null)
{
_context.Dispose();
_context = new MONITOREntities1();
}
if (_context != null)
{
//_context.ST_Csm_SalesForecast.Where(sf => sf.parent_customer == parentCustomer).Load();
//if (!_context.ST_Csm_SalesForecast.Any()) return;
//BindingSource.DataSource = _context.ST_Csm_SalesForecast.Local;
var q = from cl in _context.vw_ST_LightingStudy_Hitlist_2016
where cl.Customer == customer && cl.SOPYear == iYear
orderby cl.SOP, cl.Program
select cl;
foreach (var item in q.ToList())
{
_salesLeadDataModel = new SalesLeadDataModel
{
Customer = item.Customer,
Program = item.Program,
Application = item.Application,
Sop = item.SOP,
Eop = item.EOP,
Volume = string.Format("{0:n0}", item.PeakYearlyVolume),
Status = item.Status,
SalesPerson = item.SalesPerson,
AwardedVolume = (item.AwardedVolume.HasValue) ? string.Format("{0:n0}", item.AwardedVolume) : "",
ID = item.ID
};
SalesLeadsList.Add(_salesLeadDataModel);
}
if (SalesLeadsList.Count < 1)
{
_messageBox.Message = string.Format("No sales leads were found for {0}.", customer);
_messageBox.ShowDialog();
return(0);
}
}
}
catch (Exception ex)
{
string error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
_messageBox.Message = string.Format("Failed to return sales lead data. Error: {0}", error);
_messageBox.ShowDialog();
return(0);
}
return(1);
}
public MainController()
{
_context = new MONITOREntities1();
}