private void Btn_Delete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Delete = Convert.ToInt32(gridView1.GetFocusedRowCellValue("Parameter_ID"));
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var DeleteData = db.tb_ParamName.FirstOrDefault(u => u.ID == Delete && u.Enable == 1);
if (DeleteData.Status == "InActive")
{
DeleteData.Status = "Active";
}
else
{
DeleteData.Status = "InActive";
}
db.SaveChanges();
BindGrid();
}
private void repositoryItemButtonAction_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
int product_ID = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var DeleteData = db.tb_Product.FirstOrDefault(u => u.ID == product_ID && u.Enable == 1);
if (DeleteData.Status == "InActive")
{
DeleteData.Status = "Active";
}
else
{
DeleteData.Status = "InActive";
}
db.SaveChanges();
BindGridview();
}
public void BindList()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var obj = from u in db.tb_Reports
orderby u.ID descending
where u.Enable == 1
select new
{
u.ID,
u.CreatedDate,
u.ReportName,
Product = u.tb_Product.tb_Wirename.Wirename + " | " + u.tb_Product.tb_Size.Size + " | " + u.tb_Product.tb_Degree.Type,
u.Result,
};
gridControl1.DataSource = obj.ToList();
}
private void button1_Click(object sender, EventArgs e)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int WirenameID = Convert.ToInt32(comboBox1.SelectedValue);
int ParamType = Convert.ToInt32(comboBox2.SelectedValue);
int CatagoryID = Convert.ToInt32(comboBox3.SelectedValue);
int UnitID = Convert.ToInt32(comboBox4.SelectedValue);
int Visibilty = Convert.ToInt32(comboBox5.SelectedValue);
if (WirenameID > 0 && ParamType > 0 && CatagoryID > 0 && txtParamName.Text != "")
{
if (ID == 0 && Delete == 0)
{
var obj = db.tb_ParamName.FirstOrDefault(u => u.WireID == WirenameID && u.tb_ParamTypes.ID == ParamType && u.CatagoryID == CatagoryID && u.Name == txtParamName.Text && u.UnitID == UnitID && u.Enable == 1);
if (obj == null)
{
Submit();
}
else
{
MessageBox.Show("This Parameter Name Already Exists!");
}
}
else
{
var obj = db.tb_ParamName.FirstOrDefault(u => u.WireID == WirenameID && u.tb_ParamTypes.ID == ParamType && u.CatagoryID == CatagoryID && u.Name == txtParamName.Text && u.UnitID == Visibilty && ID != ID && u.Enable == 1);
if (obj == null)
{
Update(ID);
ID = 0;
}
else
{
MessageBox.Show("Cannot Update Same Value!");
}
}
BindGrid();
Clear();
}
else
{
MessageBox.Show("Please Enter Values!");
}
}
public void GridsWeNeed(int ID)
{
DisableGrids();
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int wire_ID = (int)db.tb_Product.FirstOrDefault(u => u.ID == ID && u.Enable == 1).WirenameID;
var ParamsType = db.tb_ParamName.Where(u => u.WireID == wire_ID && u.Enable == 1);
if (ParamsType != null)
{
foreach (var elem in ParamsType.Distinct().ToList())
{
if (elem.tb_ParamTypes.ParamName == "Max")
{
panel_Max.Visible = true;
}
else if (elem.tb_ParamTypes.ParamName == "Min")
{
panel_Min.Visible = true;
}
else if (elem.tb_ParamTypes.ParamName == "Between")
{
panel_Btw.Visible = true;
}
else if (elem.tb_ParamTypes.ParamName == "True False")
{
panel_True_False.Visible = true;
}
else if (elem.tb_ParamTypes.ParamName == "List")
{
panel_List.Visible = true;
}
else if (elem.tb_ParamTypes.ParamName == "Same Value")
{
panel_Same_Value.Visible = true;
}
}
}
else
{
MessageBox.Show("No Parameters Has Been Set For This Wire Name!");
}
LocatePanel();
//BindIntoGrids(wire_ID);
}
private void repositoryItemButtonEdit_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
int Product_ID = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
if (db.tb_Product.FirstOrDefault(u => u.ID == Product_ID && u.Enable == 1).Status == "Active")
{
comboBox1.SelectedValue = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID && u.Enable == 1).WirenameID.ToString();
comboBox2.SelectedValue = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID && u.Enable == 1).DegreeID.ToString();
comboBox3.SelectedValue = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID && u.Enable == 1).SizeID.ToString();
comboBox6.SelectedValue = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID && u.Enable == 1).Grade.ToString();
ID = Product_ID;
update++;
}
else
{
MessageBox.Show("Cannot Edit Inactive Data!");
}
}
private void button1_Click(object sender, EventArgs e)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
if (!String.IsNullOrWhiteSpace(txtSize.Text) && txtSize.Text != "")
{
if (update != 0)
{
var obj_Degree = db.tb_Size.FirstOrDefault(u => u.Size == txtSize.Text && u.ID != ID && u.Enable == 1);
if (obj_Degree == null)
{
Update(ID);
update = 0;
}
else
{
MessageBox.Show("This Size Name Already Exists!");
Clear();
}
}
else
{
var obj_Degree = db.tb_Size.FirstOrDefault(u => u.Size == txtSize.Text && u.Enable == 1);
if (obj_Degree == null)
{
Submit();
}
else
{
MessageBox.Show("This Size Name Already Exists!");
Clear();
}
}
}
else
{
MessageBox.Show("Please Enter Size Name!");
Clear();
}
Clear();
BindGridview();
}
public string GetGrade(int ID)
{
string grade = "";
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var Grade = db.tb_Product.FirstOrDefault(u => u.ID == ID && u.Enable == 1).Grade;
if (Grade == 1)
{
grade = "1/Fine";
}
else if (Grade == 2)
{
grade = "2/Medium";
}
else if (Grade == 3)
{
grade = "3/Thick";
}
return(grade);
}
public string GetUniqueNameFromParamList(int ID)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
//Got the Major Data from Report ID becuase its common in all rows...
var obj = db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ReportID == ID);
var _ID = obj.ID;
var obj_1 = ValRep_ID == 0 ? db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == _ID && u.ReportID == ID) : db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID > ValRep_ID && u.ReportID == ID);
ValRep_ID = obj_1 == null ? 0 : obj_1.ID;
string ret;
if (obj_1 == null)
{
ret = "";
}
else
{
ret = obj_1.tb_ParamList.Name;
}
return(ret);
}
public void BindParamTypes()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var objParamDetail = from u in db.tb_ParamTypes
orderby u.ID descending
select new
{
u.ParamName,
u.ID,
};
Dictionary <string, string> ParamNameDict = new Dictionary <string, string>();
ParamNameDict.Add("0", "---Select Parameter Name---");
foreach (var elem in objParamDetail.ToList())
{
ParamNameDict.Add(elem.ID.ToString(), elem.ParamName);
}
comboBox2.DataSource = ParamNameDict.ToList();
comboBox2.DisplayMember = "Value";
comboBox2.ValueMember = "Key";
}
public void BindUnit()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var objParamDetail = from u in db.tb_Unit
orderby u.ID descending
select new
{
u.Unit,
u.ID,
};
Dictionary <string, string> UnitDict = new Dictionary <string, string>();
UnitDict.Add("0", "---Select Unit---");
foreach (var elem in objParamDetail.ToList())
{
UnitDict.Add(elem.ID.ToString(), elem.Unit);
}
comboBox4.DataSource = UnitDict.ToList();
comboBox4.DisplayMember = "Value";
comboBox4.ValueMember = "Key";
}
private void Btn_Update_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
int Product_ID = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
if (db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).Status == "Active")
{
Products.ComboBox1 = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).WirenameID.ToString();
Products.ComboBox2 = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).DegreeID.ToString();
Products.ComboBox3 = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).SizeID.ToString();
Products.ComboBox6 = db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).Grade.ToString();
Products.SetDataFromDashboard = true;
Products pd = new Products();
pd.FormClosing += new FormClosingEventHandler(this.FormClosing_click);
pd.ShowDialog();
}
else
{
MessageBox.Show("Cannot Edit Inactive Data!");
}
}
private void Products_Load(object sender, EventArgs e)
{
if (SetDataFromDashboard == true)
{
int Product_ID = Convert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
if (db.tb_Product.FirstOrDefault(u => u.ID == Product_ID && u.Enable == 1).Status == "Active")
{
comboBox1.SelectedValue = ComboBox1;
comboBox2.SelectedValue = ComboBox2; //db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).DegreeID.ToString();
comboBox3.SelectedValue = ComboBox3; //db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).SizeID.ToString();
comboBox6.SelectedValue = ComboBox6; //db.tb_Product.FirstOrDefault(u => u.ID == Product_ID).Grade.ToString();
ID = Product_ID;
update++;
}
else
{
MessageBox.Show("Cannot Edit Inactive Data!");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (!String.IsNullOrWhiteSpace(txtListName.Text) && txtListName.Text != "")
{
if (UpdateId != 0)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var obj = db.tb_ParamList.FirstOrDefault(u => u.Name == txtListName.Text && u.ID != UpdateId && u.Enable == 1);
if (obj == null)
{
Update(UpdateId);
}
else
{
MessageBox.Show("Please Check Your Input!");
}
}
else
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int Combo_ID = Convert.ToInt32(comboBox1.SelectedValue);
var obj = db.tb_ParamList.FirstOrDefault(u => u.Name == txtListName.Text && u.ParamTypeID == Combo_ID && u.Enable == 1);
if (obj == null)
{
Submit();
}
else
{
MessageBox.Show("Please Check Your Input!");
}
}
}
else
{
MessageBox.Show("Can't Save Empty!");
}
BindList();
Clear();
}
public void BindWirename()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var objWirenameDetail = from u in db.tb_Wirename
orderby u.ID descending
where u.Status == "Active" && u.Enable == 1
select new
{
u.Wirename,
u.ID,
};
Dictionary <string, string> WireNameDict = new Dictionary <string, string>();
WireNameDict.Add("0", "---Select Wire Name---");
foreach (var elem in objWirenameDetail.ToList())
{
WireNameDict.Add(elem.ID.ToString(), elem.Wirename);
}
comboBox1.DataSource = WireNameDict.ToList();
comboBox1.DisplayMember = "Value";
comboBox1.ValueMember = "Key";
}
public Create_Report_List_Value(int ID, int Product_ID, int Rand_Numb, int ReportID_update)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
InitializeComponent();
Paramter_Name_ID = ID;
P_Id = Product_ID;
Report_Id_Update = ReportID_update;
Rand_Numb_ = Rand_Numb;
isTrueFalse = db.tb_ParamListValues.FirstOrDefault(u => u.ParamNameID == Paramter_Name_ID).tb_ParamList.tb_ParamTypes.ParamName == "True False" ? true : false;
if (isTrueFalse == true)
{
List_Parameter_Values.Visible = false;
gridColumn1.Visible = false;
}
BindList();
gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
gridView1.OptionsSelection.EnableAppearanceFocusedRow = false;
gridView1.OptionsSelection.EnableAppearanceHideSelection = false;
gridView1.OptionsSelection.MultiSelect = true;
}
private void button1_Click(object sender, EventArgs e)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int WirenameID = Convert.ToInt32(comboBox1.SelectedValue);
int SizeID = Convert.ToInt32(comboBox3.SelectedValue);
int DegreeID = Convert.ToInt32(comboBox2.SelectedValue);
int Grade = Convert.ToInt32(comboBox6.SelectedValue);
if (WirenameID > 0 || SizeID > 0 || DegreeID > 0)
{
if (update != 0)
{
var obj = db.tb_Product.FirstOrDefault(u => u.tb_Wirename.ID == WirenameID && u.tb_Degree.ID == DegreeID && u.tb_Size.ID == SizeID && u.ID != ID && u.Grade == Grade && u.Enable == 1);
if (obj == null)
{
Update(ID);
update = 0;
}
}
else
{
var obj_Degree = db.tb_Product.FirstOrDefault(u => u.tb_Wirename.ID == WirenameID && u.tb_Degree.ID == DegreeID && u.tb_Size.ID == SizeID && u.ID != ID && u.Grade == Grade && u.Enable == 1);
if (obj_Degree == null)
{
Submit();
}
else
{
MessageBox.Show("This Wire Name Already Exists!");
}
}
}
else
{
MessageBox.Show("Please Fill All The Inputs!");
}
Clear();
BindGridview();
}
public string GetFormatList(string ListParamType, int ID)
{
string format = "";
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
if (ListParamType == "Max")
{
int ParamListID = (int)db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).ParamListID;
format = Convert.ToDecimal(db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).Val1) <= Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == ParamListID).Val) ? "Light" : "ExtraBold";
isPassedOrNot(format);
}
else if (ListParamType == "Min")
{
int ParamListID = (int)db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).ParamListID;
format = Convert.ToDecimal(db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).Val1) >= Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == ParamListID).Val) ? "Light" : "ExtraBold";
isPassedOrNot(format);
}
else if (ListParamType == "Between")
{
int ParamListID = (int)db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).ParamListID;
format = Convert.ToDecimal(db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).Val1) >= Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == ParamListID).Val) && Convert.ToDecimal(db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).Val1) <= Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == ParamListID).Val2) ? "Light" : "ExtraBold";
isPassedOrNot(format);
}
else if (ListParamType == "Same Value")
{
int ParamListID = (int)db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).ParamListID;
format = Convert.ToDecimal(db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).Val1) == Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == ParamListID).Val) ? "Light" : "ExtraBold";
isPassedOrNot(format);
}
else if (ListParamType == "Same Value")
{
format = db.tb_ValuesOfReport_Lists.FirstOrDefault(u => u.ID == ID).Val1 == "true" ? "Light" : "ExtraBold";
isPassedOrNot(format);
}
return(format);
}
public void BindList()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
//tb_ParamValue objParamValues = new tb_ParamValue();
Dt_List = new DataTable();
Dt_List.Columns.Add("ID");
Dt_List.Columns.Add("Self_ID");
Dt_List.Columns.Add("Self_ID_From_ParamList");
Dt_List.Columns.Add("Name");
Dt_List.Columns.Add("Val");
Dt_List.Columns.Add("Type");
Dt_List.Columns.Add("Tolerance");
Dt_List.Columns.Add("Result");
var obj_1 = from u in db.tb_ValuesOfReport_Lists
where u.ValRepID == Paramter_Name_ID && u.ReportID == Report_Id_Update
select new
{
u.ParamNameID,
self_ID = u.ID,
u.tb_ParamList.Name,
u.tb_ParamList.tb_ParamTypes.ParamName,
u.Val1,
u.Tolerance,
Result = db.tb_ParamListValues.FirstOrDefault(x => x.ParamNameID == u.ID).Val == "true" ? "Pass" : "Fail"
};
if (obj_1.Count() > 0)
{
isUpdate = 1;
foreach (var elem in obj_1.ToList())
{
Dt_List.Rows.Add(new object[] {
elem.ParamNameID, elem.self_ID, "", elem.Name, elem.Val1, elem.ParamName, elem.Tolerance, elem.Result
});
}
}
else
{
var obj = from u in db.tb_ParamList
where u.ParamNameID == Paramter_Name_ID
select new
{
u.ID,
u.ParamNameID,
self_Id = u.ID,
u.Name,
u.tb_ParamTypes.ParamName,
Result = db.tb_ParamListValues.FirstOrDefault(x => x.ParamListID == u.ID).Val == "true" ? "Fail" : "Pass"
};
foreach (var elem in obj.ToList())
{
Dt_List.Rows.Add(new object[] {
elem.ParamNameID, "", elem.ID, elem.Name, "", elem.ParamName, "", elem.Result
});
}
}
gridControl1.DataSource = Dt_List;
}
public void BindList()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
//tb_ParamValue objParamValues = new tb_ParamValue();
Dt_List = new DataTable();
Dt_List.Columns.Add("ID");
Dt_List.Columns.Add("Self_ID");
Dt_List.Columns.Add("Name");
Dt_List.Columns.Add("Val");
Dt_List.Columns.Add("Val2");
Dt_List.Columns.Add("Type");
Dt_List.Columns.Add("Tolerance");
int RowIndex = 0;
var obj = from u in db.tb_ParamListValues
where u.ParamNameID == Paramter_Name_ID
select new
{
u.tb_ParamList.ID,
self_Id = u.ID,
u.tb_ParamList.Name,
u.Val,
u.Val2,
Type = u.tb_ParamList.tb_ParamTypes.ParamName,
u.Tolerance
};
if (obj.Count() > 0)
{
foreach (var elem in obj.ToList())
{
Dt_List.Rows.Add(new object[] {
elem.ID, elem.self_Id, elem.Name, elem.Val, elem.Val2, elem.Type, elem.Tolerance
});
}
}
var obj_1 = from u in db.tb_ParamList
where u.ParamNameID == Paramter_Name_ID
select new
{
u.ID,
u.Name,
Type = u.tb_ParamTypes.ParamName
};
if (obj_1.Count() > 0)
{
foreach (var elem1 in obj_1.ToList())
{
var obj_11 = db.tb_ParamListValues.Where(u => u.ParamListID == elem1.ID).FirstOrDefault();
if (obj_11 == null)
{
Dt_List.Rows.Add(new object[] {
elem1.ID, "", elem1.Name, "", "", elem1.Type, ""
});
}
}
}
gridControl1.DataSource = Dt_List;
foreach (DataRow el in Dt_List.Rows)
{
if (el["Val"].ToString() == "true")
{
gridView1.SelectRow(RowIndex);
}
RowIndex++;
}
RowIndex = 0;
}
public void Submit()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int RowIndex = 0;
foreach (DataRow el in Dt_List.Rows)
{
if (el["Self_ID"].ToString() != "")
{
int self_Id = Convert.ToInt32(el["Self_ID"]);
var obj = db.tb_ParamListValues.FirstOrDefault(u => u.ID == self_Id);
if (IsTrueOrFalse == false)
{
obj.Val = Convert.ToString(el["Val"]);
obj.Val2 = Convert.ToString(el["Val2"]);
}
else
{
if (gridView1.IsRowSelected(RowIndex))
{
obj.Val = "true";
}
else
{
obj.Val = "false";
}
}
obj.Tolerance = Convert.ToString(el["Tolerance"]);
RowIndex++;
}
else
{
tb_ParamListValues objParamList = new tb_ParamListValues();
if (IsTrueOrFalse == false)
{
objParamList.Val = Convert.ToString(el["Val"]);
objParamList.Val2 = Convert.ToString(el["Val2"]);
}
else
{
if (gridView1.IsRowSelected(RowIndex))
{
objParamList.Val = "true";
}
else
{
objParamList.Val = "false";
}
}
objParamList.ParamListID = Convert.ToInt32(el["ID"]);
objParamList.Tolerance = Convert.ToString(el["Tolerance"]);
objParamList.ParamNameID = Paramter_Name_ID;
objParamList.CreatedDate = DateTime.Today;
objParamList.Status = "Active";
db.tb_ParamListValues.Add(objParamList);
RowIndex++;
}
}
db.SaveChanges();
}
public void BindComboBox()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var obj1 = from u in db.tb_Wirename
orderby u.ID descending
where u.Status == "Active" && u.Enable == 1
select new
{
u.Wirename,
u.ID
};
Dictionary <string, string> Role = new Dictionary <string, string>();
Role.Add("0", "---Select Wire Name---");
foreach (var elem in obj1.ToList())
{
Role.Add(elem.ID.ToString(), elem.Wirename);
}
comboBox1.DataSource = Role.ToList();
comboBox1.DisplayMember = "Value";
comboBox1.ValueMember = "Key";
var obj2 = from u in db.tb_Size
orderby u.ID descending
where u.Status == "Active" && u.Enable == 1
select new
{
u.ID,
u.Size,
};
Dictionary <string, string> Role_1 = new Dictionary <string, string>();
Role_1.Add("0", "---Select Size---");
foreach (var elem in obj2.ToList())
{
Role_1.Add(elem.ID.ToString(), elem.Size);
}
comboBox3.DataSource = Role_1.ToList();
comboBox3.DisplayMember = "Value";
comboBox3.ValueMember = "Key";
var obj3 = from u in db.tb_Degree
orderby u.ID descending
where u.Status == "Active" && u.Enable == 1
select new
{
u.ID,
u.Type,
};
Dictionary <string, string> Role_2 = new Dictionary <string, string>();
Role_2.Add("0", "---Select Degree---");
foreach (var elem in obj3.ToList())
{
Role_2.Add(elem.ID.ToString(), elem.Type);
}
comboBox2.DataSource = Role_2.ToList();
comboBox2.DisplayMember = "Value";
comboBox2.ValueMember = "Key";
}
public void Submit()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int ProductID = Convert.ToInt32(comboBox1.SelectedValue);
tb_Reports obj = new tb_Reports();
db.tb_Reports.Add(obj);
if (panel_Max.Visible == true)
{
foreach (DataRow elem in Dt_Max.Rows)
{
if (elem["ID"].ToString() != "")
{
int ID = Convert.ToInt32(elem["ID"]);
var objMax_update = db.tb_ParamValue.FirstOrDefault(u => u.ProductID == ProductID && u.ID == ID);
objMax_update.Val1 = (string)elem["Param_Max_Value"];
objMax_update.Tolerance = Convert.ToString(elem["Tolerance"]);
}
else
{
tb_ParamValue objParamVal = new tb_ParamValue();
string ParamName = (string)elem["Param_Max_Name"];
objParamVal.ParamNameID = db.tb_ParamName.FirstOrDefault(u => u.Name == ParamName).ID;
objParamVal.ProductID = ProductID;
objParamVal.Val1 = (string)elem["Param_Max_Value"];
objParamVal.Tolerance = Convert.ToString(elem["Tolerance"]);
objParamVal.Status = "Active";
db.tb_ParamValue.Add(objParamVal);
}
}
}
if (panel_Min.Visible == true)
{
foreach (DataRow elem in Dt_Min.Rows)
{
if (elem["ID"].ToString() != "")
{
int ID = Convert.ToInt32(elem["ID"]);
var objMax_update = db.tb_ParamValue.FirstOrDefault(u => u.ProductID == ProductID && u.ID == ID);
objMax_update.Val1 = (string)elem["Param_Min_Value"];
objMax_update.Tolerance = Convert.ToString(elem["Tolerance"]);
}
else
{
tb_ParamValue objParamVal = new tb_ParamValue();
string ParamName = (string)elem["Param_Min_Name"];
objParamVal.ParamNameID = db.tb_ParamName.FirstOrDefault(u => u.Name == ParamName).ID;
objParamVal.ProductID = ProductID;
objParamVal.Val1 = (string)elem["Param_Min_Value"];
objParamVal.Tolerance = Convert.ToString(elem["Tolerance"]);
objParamVal.Status = "Active";
db.tb_ParamValue.Add(objParamVal);
}
}
}
if (panel_Btw.Visible == true)
{
foreach (DataRow elem in Dt_btw.Rows)
{
if (elem["ID"].ToString() != "")
{
int ID = Convert.ToInt32(elem["ID"]);
var objMax_update = db.tb_ParamValue.FirstOrDefault(u => u.ProductID == ProductID && u.ID == ID);
objMax_update.Val1 = Convert.ToString(elem["Param_Btw_Value_From"]);
objMax_update.Val2 = Convert.ToString(elem["Param_Btw_Value_To"]);
objMax_update.Tolerance = Convert.ToString(elem["Tolerance"]);
}
else
{
tb_ParamValue objParamVal = new tb_ParamValue();
string ParamName = (string)elem["Param_Btw_Name"];
objParamVal.ParamNameID = db.tb_ParamName.FirstOrDefault(u => u.Name == ParamName).ID;
objParamVal.ProductID = ProductID;
objParamVal.Val1 = Convert.ToString(elem["Param_Btw_Value_From"]);
objParamVal.Val2 = Convert.ToString(elem["Param_Btw_Value_To"]);
objParamVal.Tolerance = Convert.ToString(elem["Tolerance"]);
objParamVal.Status = "Active";
db.tb_ParamValue.Add(objParamVal);
}
}
}
if (panel_True_False.Visible == true)
{
int pvt_Cont = 0;
int Rows = gridView4.RowCount;
foreach (DataRow elem in Dt_TrueFalse.Rows)
{
if (elem["ID"].ToString() != "")
{
//Case Update...
int Praram_ID = Convert.ToInt32(elem["ID"]);
var obj_Update = db.tb_ParamValue.FirstOrDefault(u => u.ID == Praram_ID);
obj_Update.Val1 = gridView4.IsRowSelected(pvt_Cont) == true ? "true" : "false";
}
else
{
tb_ParamValue objParam = new tb_ParamValue();
objParam.Val1 = gridView4.IsRowSelected(pvt_Cont) == true ? "true" : "false";
objParam.ProductID = ProductID;
objParam.Status = "Active";
string param_name = Convert.ToString(elem["Param_TrueFalse_Name"]);
objParam.ParamNameID = db.tb_ParamName.FirstOrDefault(u => u.Name == param_name).ID;
db.tb_ParamValue.Add(objParam);
}
pvt_Cont++;
}
}
if (panel_Same_Value.Visible == true)
{
foreach (DataRow elem in Dt_SameValue.Rows)
{
if (elem["ID"].ToString() != "")
{
int ParamID = Convert.ToInt32(elem["ID"]);
var obj_Update = db.tb_ParamValue.FirstOrDefault(u => u.ID == ParamID);
string ParamName = (string)elem["Param_SameVal_Name"];
obj_Update.ParamNameID = db.tb_ParamName.FirstOrDefault(u => u.Name == ParamName).ID;
obj_Update.Val1 = Convert.ToString(elem["Param_SameVal_Value"]);
obj_Update.Tolerance = Convert.ToString(elem["Tolerance"]);
}
else
{
tb_ParamValue objParamVal = new tb_ParamValue();
string ParamName = Convert.ToString(elem["Param_SameVal_Name"]);
objParamVal.ParamNameID = db.tb_ParamName.FirstOrDefault(u => u.Name == ParamName).ID;
objParamVal.ProductID = Convert.ToInt32(comboBox1.SelectedValue);
objParamVal.Val1 = Convert.ToString(elem["Param_SameVal_Value"]);
objParamVal.Tolerance = Convert.ToString(elem["Tolerance"]);
objParamVal.Status = "Active";
db.tb_ParamValue.Add(objParamVal);
}
}
}
db.SaveChanges();
}
public void BindReport(int ID)
{
ReportDataSource itemDataSource1;
ReportDataSet ds = new ReportDataSet();
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var obj_Caliber = from u in db.tb_ValuesOfReports
where u.ReportID == ID
select new
{
u.ID,
ReportID = db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID).ReportID,
CatagoryName = db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID && n.tb_ParamName.ShowParam != 2).tb_ParamName.tb_Catagory.CatagoryName,
ParamName = "." + db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID && n.tb_ParamName.ShowParam != 2).tb_ParamName.Name + " " + db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID && n.tb_ParamName.ShowParam != 2).tb_ParamName.tb_Unit.Unit,
ParamType = db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID && n.tb_ParamName.ShowParam != 2).tb_ParamName.tb_ParamTypes.ParamName == "True False" ? "Pass/Not Pass" : db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID && n.tb_ParamName.ShowParam != 2).tb_ParamName.tb_ParamTypes.ParamName,
Param_Expected_Val1 = db.tb_ParamValue.FirstOrDefault(n => n.ParamNameID == u.ParamNameID && u.ProductID == db.tb_ValuesOfReports.FirstOrDefault(v => v.ID == u.ID).ProductID&& u.tb_ParamName.ShowParam != 2).Val1 == "true"?"Pass":"******",
Param_Expected_Val2 = db.tb_ParamValue.FirstOrDefault(n => n.ParamNameID == u.ParamNameID && u.ProductID == db.tb_ValuesOfReports.FirstOrDefault(v => v.ID == u.ID).ProductID&& n.tb_ParamName.ShowParam != 2).Val2,
Param_Expected_Tolerance = db.tb_ParamValue.FirstOrDefault(n => n.ParamNameID == u.ParamNameID && u.ProductID == db.tb_ValuesOfReports.FirstOrDefault(v => v.ID == u.ID).ProductID&& n.tb_ParamName.ShowParam != 2).Tolerance,
Param_Res_Val = db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == u.ID && n.tb_ParamName.ShowParam != 2).Val1,
Param_Res_Tolerance = u.Tolerance,
//Param_Unit = db.tb_ValuesOfReports.FirstOrDefault(n => n.ID == ID && n.tb_ParamName.ShowParam != 2).tb_ParamName.tb_Unit.Unit,
};
string Cover = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Cover;
string Box = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Box;
string Clean = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Clean;
string Customer = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Customer;
string Edge = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Edge;
string InvDate = Convert.ToDateTime(db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.InvDate).ToString("dd/MM/yyyy");
string InvNo = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.InvNo;
string OtherSpec = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.OtherSpec;
string Polythene = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Polythene;
string Qty = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Qty;
string Size = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Size;
string Surface = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Surface;
string Trace = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Trace;
string Weight = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Weight;
string Winding = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Winding;
string Wrapper = db.tb_ValuesOfReports.FirstOrDefault(u => u.ReportID == ID).tb_Reports.Wrapper;
var obj_Caliber1 = from u in obj_Caliber.ToList()
select new
{
u.ID,
u.ReportID,
u.CatagoryName,
u.ParamName,
u.ParamType,
u.Param_Expected_Val1,
u.Param_Expected_Val2,
u.Param_Expected_Tolerance,
u.Param_Res_Val,
u.Param_Res_Tolerance,
Format = GetFormat(u.ParamType, u.ID),
};
var obj_Caliber1_List = from u in db.tb_ValuesOfReport_Lists
where u.ReportID == ID
select new
{
u.tb_ParamList.tb_ParamTypes.ParamName,
u.ID,
List_Param_Name = u.tb_ParamList.Name + " " + u.tb_ParamList.tb_Unit.Unit,
List_Param_Name_Expect_Val = db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == u.ParamListID).Val == "true" ? "Pass" : "Not Pass",
List_Param_Name_Expect_Val2 = db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == u.ParamListID).Val2,
List_Param_Res_Val = u.Val1,
List_Param_Type = u.tb_ParamList.tb_ParamTypes.ParamName == "True False" ? "Pass/Not Pass" : u.tb_ParamList.tb_ParamTypes.ParamName,
Main_Param_Type = u.tb_ValuesOfReports.tb_ParamName.tb_ParamTypes.ParamName,
Main_Param_Name = u.tb_ValuesOfReports.tb_ParamName.Name,
List_Param_Tolerance = u.Tolerance,
List_Param_Tolerance_Expected = db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == u.ParamListID).Tolerance,
//Convert.ToDecimal(u.Val1) <= Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == u.ParamListID).Val) ? "ExtraBold" : "Light",
//Param_list_Unit = u.tb_ParamList.tb_Unit.Unit,
};
var obj_Caliber1_List1 = from u in obj_Caliber1_List.ToList()
select new
{
u.List_Param_Name,
u.List_Param_Name_Expect_Val,
u.List_Param_Name_Expect_Val2,
u.List_Param_Res_Val,
u.List_Param_Type,
u.Main_Param_Type,
u.Main_Param_Name,
Format = GetFormatList(u.ParamName, u.ID),
u.List_Param_Tolerance,
u.List_Param_Tolerance_Expected,
//Convert.ToDecimal(u.Val1) <= Convert.ToDecimal(db.tb_ParamListValues.FirstOrDefault(n => n.ParamListID == u.ParamListID).Val) ? "ExtraBold" : "Light",
//Param_list_Unit = u.tb_ParamList.tb_Unit.Unit,
};
//Creating Datatable to append both objects in a single table....
DataTable Dt_ReportData = new DataTable();
Dt_ReportData.Columns.Add("ValuesOfReportID");
Dt_ReportData.Columns.Add("ReportID");
Dt_ReportData.Columns.Add("CatagoryName");
Dt_ReportData.Columns.Add("ParamName");
Dt_ReportData.Columns.Add("ParamType");
Dt_ReportData.Columns.Add("List_ParamType");
Dt_ReportData.Columns.Add("Param_Expected_Val1");
Dt_ReportData.Columns.Add("Param_Expected_Val2");
Dt_ReportData.Columns.Add("Param_Result_Val");
Dt_ReportData.Columns.Add("Param_Tolerance_Expected_Val");
Dt_ReportData.Columns.Add("Param_Tolerance_Result_Val");
Dt_ReportData.Columns.Add("Bold_Format");
Dt_ReportData.Columns.Add("Bytes");
Dt_ReportData.Columns.Add("Cover");//New Dt...
Dt_ReportData.Columns.Add("Customer");
Dt_ReportData.Columns.Add("OtherSpec");
Dt_ReportData.Columns.Add("InvNo");
Dt_ReportData.Columns.Add("InvDate");
Dt_ReportData.Columns.Add("Qty");
Dt_ReportData.Columns.Add("Winding");
Dt_ReportData.Columns.Add("Surface");
Dt_ReportData.Columns.Add("Edge");
Dt_ReportData.Columns.Add("Clean");
Dt_ReportData.Columns.Add("Polythene");
Dt_ReportData.Columns.Add("Box");
Dt_ReportData.Columns.Add("Wrapper");
Dt_ReportData.Columns.Add("Trace");
Dt_ReportData.Columns.Add("Weight");
Dt_ReportData.Columns.Add("Size");
Dt_ReportData.Columns.Add("Special");
byte[] bytes = null;
foreach (var elem in obj_Caliber1.ToList())
{
if (elem.ParamType == "List")
{
foreach (var el in obj_Caliber1_List1.ToList())
{
Dt_ReportData.Rows.Add(elem.ID, elem.ReportID, elem.CatagoryName, el.List_Param_Name, "List", el.List_Param_Type, el.List_Param_Name_Expect_Val, el.List_Param_Name_Expect_Val2, el.List_Param_Res_Val, el.List_Param_Tolerance_Expected, el.List_Param_Tolerance, el.Format, bytes, Cover, Customer, OtherSpec, InvNo, InvDate, Qty, Winding, Surface, Edge, Clean, Polythene, Box, Wrapper, Trace, Weight, Size);
}
}
Dt_ReportData.Rows.Add(elem.ID, elem.ReportID, elem.CatagoryName, elem.ParamName, elem.ParamType, "", elem.Param_Expected_Val1, elem.Param_Expected_Val2, elem.Param_Res_Val, elem.Param_Expected_Tolerance, elem.Param_Res_Val, elem.Format, "", Cover, Customer, OtherSpec, InvNo, InvDate, Qty, Winding, Surface, Edge, Clean, Polythene, Box, Wrapper, Trace, Weight, Size);
}
DataTable Dt_List = new DataTable();
if (obj_Caliber1 != null)
{
Dt_List.Columns.Add("Name");
Dt_List.Columns.Add("Type");
Dt_List.Columns.Add("Exp_Value");
Dt_List.Columns.Add("Res_Value");
foreach (DataRow elem in Dt_ReportData.Rows)
{
if (elem["Param_Result_Val"].ToString() == "true")
{
bytes = System.IO.File.ReadAllBytes("TickMark.png");
}
else if (elem["Param_Result_Val"].ToString() == "false")
{
bytes = System.IO.File.ReadAllBytes("CrossMark.png");
}
else
{
bytes = null;
}
ds.Caliber_Report.Rows.Add(elem["ReportID"], elem["ParamName"], elem["Param_Expected_Val1"], elem["Param_Expected_Val2"], elem["Param_Tolerance_Expected_Val"], elem["Param_Result_Val"].ToString() == "true" || elem["Param_Result_Val"].ToString() == "false" ? "" : elem["Param_Result_Val"], elem["Param_Tolerance_Result_Val"], elem["CatagoryName"], elem["ParamType"], elem["List_ParamType"], elem["Bold_Format"], bytes, elem["Cover"], elem["Customer"], elem["OtherSpec"], elem["InvNo"], elem["InvDate"], elem["Qty"], elem["Winding"], elem["Surface"], elem["Clean"], elem["Edge"], elem["Polythene"], elem["Box"], elem["Wrapper"], elem["Trace"], elem["Weight"], elem["Size"]);
}
}
//Binding Misc_Data...
var obj_Misc_Data = from u in db.tb_ValuesOfReports
where u.ReportID == ID
select new
{
u.ID,
productID = u.tb_Product.ID,
u.tb_Reports.ReportName,
u.tb_Reports.CreatedDate,
Product = u.tb_Product.tb_Wirename.Wirename + " [Size : " + u.tb_Product.tb_Size.Size + ", Degree : " + u.tb_Product.tb_Degree.Type + "]",
Result = u.tb_Reports.Result
};
var obj_Misc_Data1 = from u in obj_Misc_Data.ToList()
select new
{
u.ID,
u.productID,
u.ReportName,
Date = Convert.ToDateTime(u.CreatedDate).ToString("dd-MM-yyyy"),
u.Product,
Grade = GetGrade(u.productID),
};
string Result = db.tb_ValuesOfReports.FirstOrDefault(u => u.tb_Reports.ID == ID).tb_Reports.Result;
if (obj_Misc_Data1 != null)
{
foreach (var elem in obj_Misc_Data1.ToList())
{
ds.Misc_Data.Rows.Add(elem.ID, IsPassed, elem.ReportName, elem.Date, elem.Product, "", Result);
}
}
this.reportViewer1.LocalReport.DataSources.Clear();
//itemDataSource1 = new ReportDataSource("ElectricalDataSet", ds.Tables["Electrical_Report"]);
//this.reportViewer1.LocalReport.DataSources.Add(itemDataSource1);
itemDataSource1 = new ReportDataSource("CaliberDataSet", ds.Tables["Caliber_Report"]);
this.reportViewer1.LocalReport.DataSources.Add(itemDataSource1);
//itemDataSource1 = new ReportDataSource("ThermalDataSet", ds.Tables["Thermal_Report"]);
//this.reportViewer1.LocalReport.DataSources.Add(itemDataSource1);
//itemDataSource1 = new ReportDataSource("ChemicalDataSet", ds.Tables["Chemical_Report"]);
//this.reportViewer1.LocalReport.DataSources.Add(itemDataSource1);
//itemDataSource1 = new ReportDataSource("MechanicalDataSet", ds.Tables["Mechanical_Report"]);
//this.reportViewer1.LocalReport.DataSources.Add(itemDataSource1);
itemDataSource1 = new ReportDataSource("Misc_DataSet", ds.Tables["Misc_Data"]);
this.reportViewer1.LocalReport.DataSources.Add(itemDataSource1);
}
private void button1_Click(object sender, EventArgs e)//Button Click OK...
{
int ID = Convert.ToInt32(comboBox1.SelectedValue);
GridsWeNeed(ID);
//Checking if values exsits already...
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
var obj_Param_Values = from u in db.tb_ParamValue
where u.ID == ID
select new
{
u.ID,
u.Val1,
u.Val2,
u.Tolerance,
u.tb_ParamName.Name,
};
if (obj_Param_Values != null)
{
isUpdate = 1;
int wire_ID = (int)db.tb_Product.FirstOrDefault(u => u.ID == ID).WirenameID;
if (panel_Max.Visible == true)
{
var obj1 = from u in db.tb_ParamValue
where u.ProductID == ID && u.tb_ParamName.tb_ParamTypes.ParamName == "Max" && u.Status == "Active" && u.tb_ParamName.Enable == 1
select new
{
u.ID,
u.tb_ParamName.Name,
u.Val1,
u.Tolerance
};
Dt_Max = new DataTable();
Dt_Max.Columns.Add("Param_Max_Name");
Dt_Max.Columns.Add("Param_Max_Value");
Dt_Max.Columns.Add("ID");
Dt_Max.Columns.Add("Tolerance");
if (obj1.Count() > 0)
{
foreach (var elem in obj1.ToList())
{
Dt_Max.Rows.Add(new object[] {
elem.Name, elem.Val1, elem.ID, elem.Tolerance
});
}
}
var obj_1 = from u in db.tb_ParamName
where u.tb_ParamTypes.ParamName == "Max" && u.WireID == wire_ID && u.Status == "Active" && u.Enable == 1 && u.Formula == null
select new
{
u.ID,
u.WireID,
u.Name,
_ID = ""
};
foreach (var elem in obj_1.ToList())
{
var obj = db.tb_ParamValue.Where(u => u.ProductID == ID && u.ParamNameID == elem.ID && u.tb_ParamName.Enable == 1).FirstOrDefault();
if (obj == null)
{
Dt_Max.Rows.Add(
elem.Name, "", elem._ID, ""
);
}
}
grdMax.DataSource = Dt_Max;
}
if (panel_Min.Visible == true)
{
var obj2 = from u in db.tb_ParamValue
where u.ProductID == ID && u.tb_ParamName.tb_ParamTypes.ParamName == "Min" && u.Status == "Active" && u.tb_ParamName.Enable == 1
select new
{
u.ID,
u.tb_ParamName.Name,
u.Val1,
u.Tolerance
};
Dt_Min = new DataTable();
Dt_Min.Columns.Add("Param_Min_Name");
Dt_Min.Columns.Add("Param_Min_Value");
Dt_Min.Columns.Add("ID");
Dt_Min.Columns.Add("Tolerance");
if (obj2.Count() > 0)
{
foreach (var elem in obj2.ToList())
{
Dt_Min.Rows.Add(new object[] {
elem.Name, elem.Val1, elem.ID, elem.Tolerance
});
}
}
var obj_2 = from u in db.tb_ParamName
where u.tb_ParamTypes.ParamName == "Min" && u.WireID == wire_ID && u.Status == "Active" && u.Enable == 1 && u.Formula == null
select new
{
u.ID,
u.WireID,
u.Name,
_ID = ""
};
foreach (var elem in obj_2.ToList())
{
var obj = db.tb_ParamValue.Where(u => u.ProductID == ID && u.ParamNameID == elem.ID && u.tb_ParamName.Enable == 1).FirstOrDefault();
if (obj == null)
{
Dt_Min.Rows.Add(
elem.Name, "", elem._ID, ""
);
}
}
grdMin.DataSource = Dt_Min;
}
if (panel_Btw.Visible == true)
{
var obj3 = from u in db.tb_ParamValue
where u.ProductID == ID && u.tb_ParamName.tb_ParamTypes.ParamName == "Between" && u.Status == "Active" && u.tb_ParamName.Enable == 1
select new
{
u.ID,
u.tb_ParamName.Name,
u.Val1,
u.Val2,
u.Tolerance
};
Dt_btw = new DataTable();
Dt_btw.Columns.Add("Param_Btw_Name");
Dt_btw.Columns.Add("Param_Btw_Value_From");
Dt_btw.Columns.Add("Param_Btw_Value_To");
Dt_btw.Columns.Add("ID");
Dt_btw.Columns.Add("Tolerance");
if (obj3.Count() > 0)
{
foreach (var elem in obj3.ToList())
{
Dt_btw.Rows.Add(new object[] {
elem.Name, elem.Val1, elem.Val2, elem.ID, elem.Tolerance
});
}
}
var obj_3 = from u in db.tb_ParamName
where u.tb_ParamTypes.ParamName == "Between" && u.WireID == wire_ID && u.Status == "Active" && u.Enable == 1 && u.Formula == null
select new
{
u.ID,
u.WireID,
u.Name,
_ID = ""
};
foreach (var elem in obj_3.ToList())
{
var obj = db.tb_ParamValue.Where(u => u.ProductID == ID && u.ParamNameID == elem.ID && u.tb_ParamName.Enable == 1).FirstOrDefault();
if (obj == null)
{
Dt_btw.Rows.Add(
elem.Name, "", elem._ID, ""
);
}
}
grdBtw.DataSource = Dt_btw;
}
if (panel_True_False.Visible == true)
{
var obj4 = from u in db.tb_ParamValue
where u.ProductID == ID && u.tb_ParamName.tb_ParamTypes.ParamName == "True False" && u.Status == "Active" && u.tb_ParamName.Enable == 1
select new
{
u.ID,
u.tb_ParamName.Name,
u.Val1,
};
Dt_TrueFalse = new DataTable();
Dt_TrueFalse.Columns.Add("Param_TrueFalse_Name");
Dt_TrueFalse.Columns.Add("Param_TrueFalse_Value");
Dt_TrueFalse.Columns.Add("ID");
int RowIndex = 0;
if (obj4.Count() > 0)
{
foreach (var elem in obj4.ToList())
{
Dt_TrueFalse.Rows.Add(new object[] {
elem.Name, elem.Val1, elem.ID
});
}
foreach (DataRow el in Dt_TrueFalse.Rows)
{
if (el["Param_TrueFalse_Value"].ToString() == "true")
{
gridView4.SelectRow(RowIndex);
}
}
RowIndex = 0;
}
var obj_4 = from u in db.tb_ParamName
where u.tb_ParamTypes.ParamName == "True False" && u.WireID == wire_ID && u.Status == "Active" && u.Enable == 1 && u.Formula == null
select new
{
u.ID,
u.WireID,
u.Name,
_ID = ""
};
foreach (var elem in obj_4.ToList())
{
var obj = db.tb_ParamValue.Where(u => u.ProductID == ID && u.ParamNameID == elem.ID && u.tb_ParamName.Enable == 1).FirstOrDefault();
if (obj == null)
{
Dt_TrueFalse.Rows.Add(
elem.Name, "", elem._ID
);
}
grdTrueFalse.DataSource = Dt_TrueFalse;
}
foreach (DataRow el in Dt_TrueFalse.Rows)
{
if (el["Param_TrueFalse_Value"].ToString() == "true")
{
gridView4.SelectRow(RowIndex);
}
}
RowIndex = 0;
}
if (panel_List.Visible == true)
{
var obj5 = from u in db.tb_ParamValue
where u.ProductID == ID && u.tb_ParamName.tb_ParamTypes.ParamName == "List" && u.Status == "Active" && u.tb_ParamName.Enable == 1
select new
{
u.ID,
u.tb_ParamName.Name,
u.Val1,
u.Tolerance
};
Dt_List = new DataTable();
Dt_List.Columns.Add("Param_List_Self_ID").ColumnMapping = MappingType.Hidden;
Dt_List.Columns.Add("Param_List_Name");
Dt_List.Columns.Add("Param_List_Value");
Dt_List.Columns.Add("ID");
if (obj5.Count() > 0)
{
foreach (var elem in obj5.ToList())
{
Dt_List.Rows.Add(new object[] {
elem.ID, elem.Name, elem.Val1, elem.ID
});
}
}
var obj_5 = from u in db.tb_ParamName
where u.tb_ParamTypes.ParamName == "List" && u.WireID == wire_ID && u.Status == "Active" && u.Enable == 1 && u.Formula == null
select new
{
u.ID,
u.WireID,
u.Name,
_ID = ""
};
foreach (var elem in obj_5.ToList())
{
if (obj_5 != null)
{
Dt_List.Rows.Add(
elem.ID, elem.Name, "", elem._ID
);
}
}
grdList.DataSource = Dt_List;
}
if (panel_Same_Value.Visible == true)
{
var obj6 = from u in db.tb_ParamValue
where u.ProductID == ID && u.tb_ParamName.tb_ParamTypes.ParamName == "Same Value" && u.Status == "Active" && u.tb_ParamName.Enable == 1
select new
{
u.ID,
u.tb_ParamName.Name,
u.Val1,
u.Tolerance
};
Dt_SameValue = new DataTable();
Dt_SameValue.Columns.Add("Param_SameVal_Name");
Dt_SameValue.Columns.Add("Param_SameVal_Value");
Dt_SameValue.Columns.Add("ID");
Dt_SameValue.Columns.Add("Tolerance");
if (obj6.Count() > 0)
{
foreach (var elem in obj6.ToList())
{
Dt_SameValue.Rows.Add(new object[] {
elem.Name, elem.Val1, elem.ID, elem.Tolerance
});
}
}
var obj_6 = from u in db.tb_ParamName
where u.tb_ParamTypes.ParamName == "Same Value" && u.WireID == wire_ID && u.Status == "Active" && u.Enable == 1 && u.Formula == null
select new
{
u.ID,
u.WireID,
u.Name,
_ID = ""
};
foreach (var elem in obj_6.ToList())
{
var obj = db.tb_ParamValue.Where(u => u.ProductID == ID && u.ParamNameID == elem.ID && u.tb_ParamName.Enable == 1).FirstOrDefault();
if (obj == null)
{
Dt_SameValue.Rows.Add(
elem.Name, "", elem._ID, ""
);
}
}
grdSameVal.DataSource = Dt_SameValue;
}
}
}
