public ActionResult EndOfDayReport(string notes)
{
Sb.Clear();
bool isTest = false;
if (notes == "teststring")
{
isTest = true;
// notes = "This is a sample end of day report, but the data is real!";
}
//build HTML view with StringBuilder
Sb.Append("<div>Report submitted by " + SessionVariables.CurrentUser.First_Name + " " +
SessionVariables.CurrentUser.Last_Name + " at " + DateTime.Now + "<br/>" + " from " +
SessionVariables.CurrentLocation
);
// add user notes
Sb.Append("<h2>Notes</h2><div border='1'>" + notes + "</div>");
//turn html string builder into string
var report = Sb.ToString();
if (isTest)
{
EmailEndOfDayReport(true);
}
else
{
// store report, timestamp, and tech id to db for later compilation
var techReport = new tb_Reports();
techReport.CSU_ID = SessionVariables.CurrentUserId;
techReport.TimeSubmitted = DateTime.Now;
techReport.Report = report;
db.tb_Reports.Add(techReport);
db.SaveChanges();
// email.EndOfDayReport(report);
}
return(RedirectToAction("index", "Home"));
}
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();
}
