public ActionResult Machine_Selection_Result(InputParameters ip)
{
MachineParametersContext mp = new MachineParametersContext();
int stepOne = 0;
if (ip.LenControl.Id == 1 || ip.FaceGrinding.Id == 1 || ip.RadGrinding.Id == 1)
{
stepOne = 1;
}
List <MachineResultModel> res = new List <MachineResultModel>();
List <int> result;
//result = mp.machine_param_values.Where((m => m.machine_param_names_id.Equals(1) && m.param_value.Equals(stepOne)) || (m.machine_param_names_id.Equals(2) && m.param_value.Equals(ip.idod.Id)) || (m => m.machine_param_names_id.Equals(1) && m.param_value.Equals(stepOne)))
result = mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(1) && m.param_value.Equals(stepOne)).Select(m => m.machines_id).ToList();
result = result.Intersect(mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(2) && m.param_value.Equals(ip.idod.Id)).Select(m => m.machines_id).ToList()).ToList();
result = result.Intersect(mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(3) && m.param_value >= ip.MaxJobLen).Select(m => m.machines_id).ToList()).ToList();
result = result.Intersect(mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(4) && m.param_value.Equals(ip.PeripheralSpeed.Id)).Select(m => m.machines_id).ToList()).ToList();
result = result.Intersect(mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(5) && m.param_value >= ip.MaxWheelWidth).Select(m => m.machines_id).ToList()).ToList();
result = result.Intersect(mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(6) && m.param_value >= ip.MaxGrindingDia).Select(m => m.machines_id).ToList()).ToList();
result = result.Intersect(mp.machine_param_values.Where(m => m.machine_param_names_id.Equals(7) && m.param_value >= ip.MaxCompDia).Select(m => m.machines_id).ToList()).ToList();
//result = mp.machine_param_values.Where(m => m.id > 0 && (m.machine_param_names_id.Equals(2) && m.param_value == ip.idod.Id )).Select(m => m.machines_id).ToList();
//result = result.Distinct().ToList();
if (result.Contains(2))
{
result = result.Except((new int[] { 3, 4, 9 }).ToList()).ToList();
}
if (result.Contains(3))
{
result = result.Except((new int[] { 4, 9 }).ToList()).ToList();
}
if (result.Contains(5))
{
result = result.Except((new int[] { 6, 7, 9 }).ToList()).ToList();
}
if (result.Contains(6))
{
result = result.Except((new int[] { 7, 9 }).ToList()).ToList();
}
if (result.Contains(11))
{
result = result.Except((new int[] { 12, 13, 9 }).ToList()).ToList();
}
if (result.Contains(12))
{
result = result.Except((new int[] { 13, 9 }).ToList()).ToList();
}
String sample = "";
int count = 0;
foreach (var machine_id in result)
{
MachineResultModel mr = new MachineResultModel();
mr.Id = machine_id;
mr.MachineName = mp.machines.Where(m => m.id == machine_id).Select(m => m.name).First();
mr.StraightorAngular = "Straight";
if (stepOne == 1)
{
mr.StraightorAngular = "Angular";
}
mr.PeripheralSpeed = mp.machine_param_values.Where(m => m.machines_id == machine_id && m.machine_param_names_id == 4).Select(m => m.param_value).First().ToString();
count++;
sample += "<tr data-machine_id=\"" + mr.Id + "\"><td> " + count.ToString() + " </td><td class=\"content_text\">" + mr.MachineName + "</td><td>" + mr.StraightorAngular + "</td><td class=\"content_text\">" + mr.PeripheralSpeed + "</td><td><button class=\"btn btn-mini btn-primary basic_machine_select_final_btn\" type=\"button\">Select</button></td></tr>";
//.Add(mr);
}
//System.Runtime.Serialization.Json.DataContractJsonSerializer serializer = new System.Runtime.Serialization.Json.DataContractJsonSerializer(res.GetType());
//MemoryStream ms = new MemoryStream();
//serializer.WriteObject(ms, res);
//String resultjson=Encoding.Default.GetString(ms.ToArray());
return(Content(sample, "text/html"));
}
public ActionResult Machine_Selection_Result()
{
MachineParametersContext mp = new MachineParametersContext();
return(Content("Here"));
}
