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(); }