public ActionResult Index(int id)
{
ViewBag.ParentID = id;
TempData["ProductDetId"] = id;
GHSViewModel GHS = new GHSViewModel();
try
{
using (var db = new EF.CMCSQL03Entities())
{
var pd = (from t in db.tblProductDetail
where t.ProductDetailID == id
select t).FirstOrDefault();
ViewBag.productcode = pd.ProductCode;
ViewBag.productname = pd.ProductName;
ViewBag.ProductDetailID = pd.ProductDetailID;
var ghs = (from t in db.tblGHS
where t.ProductDetailID == id
select t).FirstOrDefault();
GHS.GHSSignalWord = ghs.SignalWord;
GHS.GHSSymbol1 = ghs.Symbol1;
GHS.GHSSymbol2 = ghs.Symbol2;
GHS.GHSSymbol3 = ghs.Symbol3;
GHS.GHSSymbol4 = ghs.Symbol4;
GHS.GHSSymbol5 = ghs.Symbol5;
GHS.OtherLabelInfo = ghs.OtherLabelInfo;
}
return View("Index", GHS);
}
catch (Exception)
{
return View("Index", GHS);
}
}
public ActionResult Save(GHSViewModel obj)
{
using (var db = new EF.CMCSQL03Entities())
{
var q = db.tblGHS.Find(obj.ProductDetailID);
if (q != null)
{
q.SignalWord = obj.GHSSignalWord;
q.Symbol1 = obj.GHSSymbol1;
q.Symbol2 = obj.GHSSymbol2;
q.Symbol3 = obj.GHSSymbol3;
q.Symbol4 = obj.GHSSymbol4;
q.Symbol5 = obj.GHSSymbol5;
q.OtherLabelInfo = obj.OtherLabelInfo;
db.SaveChanges();
}
else
{
var newrecord = new EF.tblGHS
{
ProductDetailID = Convert.ToInt32(obj.ProductDetailID),
SignalWord = obj.GHSSignalWord,
Symbol1 = obj.GHSSymbol1,
Symbol2 = obj.GHSSymbol2,
Symbol3 = obj.GHSSymbol3,
Symbol4 = obj.GHSSymbol4,
Symbol5 = obj.GHSSymbol5,
OtherLabelInfo = obj.OtherLabelInfo
};
db.tblGHS.Add(newrecord);
db.SaveChanges();
}
}
return null;
}
/// <summary>
/// Displays readonly GHS information in Product detail.
/// Returns blank view if model is empty.
/// </summary>
public ActionResult GHSDisplay(int? id)
{
ViewBag.ParentID = id;
GHSViewModel GHS = new GHSViewModel();
try
{
using (var db = new EF.CMCSQL03Entities())
{
var pd = (from t in db.tblProductDetail
where t.ProductDetailID == id
select t).FirstOrDefault();
ViewBag.productcode = pd.ProductCode;
ViewBag.productname = pd.ProductName;
ViewBag.ProductDetailID = pd.ProductDetailID;
var ghs = (from t in db.tblGHS
where t.ProductDetailID == id
select t).FirstOrDefault();
GHS.GHSSignalWord = ghs.SignalWord;
GHS.GHSSymbol1 = ghs.Symbol1;
GHS.GHSSymbol2 = ghs.Symbol2;
GHS.GHSSymbol3 = ghs.Symbol3;
GHS.GHSSymbol4 = ghs.Symbol4;
GHS.GHSSymbol5 = ghs.Symbol5;
GHS.OtherLabelInfo = ghs.OtherLabelInfo;
}
return PartialView("~/Views/Products/_GHSInfo.cshtml", GHS);
}
catch (Exception)
{
return PartialView("~/Views/Products/_GHSInfo.cshtml", GHS);
}
}