//public void GetSignOffInitialsQuoteEngineer()
//{
// ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
// ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
// Error = "";
// QuoteEngineerList = new List<String>();
// QuoteEngineerList.Add("");
// try
// {
// using (var context = new MONITOREntitiesQuoteLogIntegrationQuoteTransfer())
// {
// var collection = context.usp_QL_QuoteTransfer_GetSignOffInitials("QuoteEngineer", tranDT, result);
// foreach (var item in collection) QuoteEngineerList.Add(item.Initials);
// }
// }
// catch (Exception ex)
// {
// Error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
// }
//}
//public void GetSignOffInitialsMaterialRep()
//{
// ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
// ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
// Error = "";
// MaterialRepList = new List<String>();
// MaterialRepList.Add("");
// try
// {
// using (var context = new MONITOREntitiesQuoteLogIntegrationQuoteTransfer())
// {
// var collection = context.usp_QL_QuoteTransfer_GetSignOffInitials("MaterialRep", tranDT, result);
// foreach (var item in collection) MaterialRepList.Add(item.Initials);
// }
// }
// catch (Exception ex)
// {
// Error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
// }
//}
//public void GetSignOffInitialsProductEngineer()
//{
// ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
// ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
// Error = "";
// ProductEngineerList = new List<String>();
// ProductEngineerList.Add("");
// try
// {
// using (var context = new MONITOREntitiesQuoteLogIntegrationQuoteTransfer())
// {
// var collection = context.usp_QL_QuoteTransfer_GetSignOffInitials("ProductEngineer", tranDT, result);
// foreach (var item in collection) ProductEngineerList.Add(item.Initials);
// }
// }
// catch (Exception ex)
// {
// Error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
// }
//}
//public void GetSignOffInitialsProgramManager()
//{
// ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
// ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
// Error = "";
// ProgramManagerList = new List<String>();
// ProgramManagerList.Add("");
// try
// {
// using (var context = new MONITOREntitiesQuoteLogIntegrationQuoteTransfer())
// {
// var collection = context.usp_QL_QuoteTransfer_GetSignOffInitials("ProgramManager", tranDT, result);
// foreach (var item in collection) ProgramManagerList.Add(item.Initials);
// }
// }
// catch (Exception ex)
// {
// Error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
// }
//}
public void GetSignedOffEmployees()
{
ObjectParameter tranDT = new ObjectParameter("TranDT", typeof(DateTime?));
ObjectParameter result = new ObjectParameter("Result", typeof(Int32?));
Error = "";
string quote = (System.Web.HttpContext.Current.Session["Quote"] != null)
? quote = System.Web.HttpContext.Current.Session["Quote"].ToString()
: "";
SignOffList = new List <QtSignOffDataModel>();
try
{
using (var context = new MONITOREntitiesQuoteLogIntegrationQuoteTransfer())
{
var collection = context.usp_QL_QuoteTransfer_GetSignOff(quote, tranDT, result);
foreach (var item in collection)
{
var dataModel = new QtSignOffDataModel
{
RowID = item.RowID,
Title = item.Title,
SignOffDate = item.SignOffDate,
EmployeeCode = item.EmployeeCode,
EmployeeName = item.EmployeeName,
Initials = item.Initials
};
SignOffList.Add(dataModel);
}
}
}
catch (Exception ex)
{
Error = (ex.InnerException != null) ? ex.InnerException.Message : ex.Message;
}
}
