private void SaveRemarks(Guid productId) { string sql = "ProductId = '" + productId.ToString() + "'"; DAL.ProductRemarks oRemarks = DAL.ProductRemarks.LoadWhere(sql); if (oRemarks == null) { oRemarks = new DAL.ProductRemarks(); oRemarks.ProductId = productId; } oRemarks.BinX = txtBin_X.Text; oRemarks.BinY = txtBin_Y.Text; oRemarks.BinZ = txtBin_Z.Text; oRemarks.DownloadToShop = chkRetailItem.Checked; oRemarks.OffDisplayItem = chkOffDisplayItem.Checked; oRemarks.DownloadToCounter = chkCounterItem.Checked; oRemarks.REMARK1 = txtRemarks1.Text; oRemarks.REMARK2 = txtRemarks2.Text; oRemarks.REMARK3 = txtRemarks3.Text; oRemarks.REMARK4 = txtRemarks4.Text; oRemarks.REMARK5 = txtRemarks5.Text; oRemarks.REMARK6 = txtRemarks6.Text; oRemarks.Save(); }
public bool SaveRec(Guid productId) { bool result = false; RT2020.DAL.Product oProduct = RT2020.DAL.Product.Load(productId); if (oProduct != null) { string sql = "ProductId = '" + productId.ToString() + "'"; DAL.ProductRemarks oRemarks = DAL.ProductRemarks.LoadWhere(sql); if (oRemarks == null) { oRemarks = new DAL.ProductRemarks(); oRemarks.ProductId = productId; } oRemarks.Notes = txtMemo.Text; if (string.IsNullOrEmpty(oRemarks.Photo)) { oRemarks.Photo = txtPicFileName.Text; } else if (oRemarks.Photo != txtPicFileName.Text) { oRemarks.Photo5 = oRemarks.Photo4; oRemarks.Photo4 = oRemarks.Photo3; oRemarks.Photo3 = oRemarks.Photo2; oRemarks.Photo2 = oRemarks.Photo; oRemarks.Photo = txtPicFileName.Text; } oRemarks.Save(); _ProductId = productId; result = true; } return(result); }