// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid productAttributeId)
{
var service = new CrudeProductAttributeServiceClient();
_isNew = false;
try {
_contract = service.FetchByProductAttributeId(productAttributeId);
productAttributeRefCombo.Text = _contract.ProductAttributeRcd != null ? _contract.ProductAttributeRcd : String.Empty;
productAttributeUnitRefCombo.Text = _contract.ProductAttributeUnitRcd != null ? _contract.ProductAttributeUnitRcd : String.Empty;
textBoxValue.Text = _contract.Value;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
service.Close();
}
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/f5685d96-a0bb-4f7b-beaa-b3d578c7cf28
public void ShowAsAdd(System.Guid productId, string productAttributeRcd, string productAttributeUnitRcd, string value, System.Guid userId)
{
try {
_contract = new CrudeProductAttributeContract();
_isNew = true;
_contract.ProductId = productId;
_contract.ProductAttributeRcd = productAttributeRcd;
productAttributeRefCombo.Text = _contract.ProductAttributeRcd != null ? _contract.ProductAttributeRcd : String.Empty;
_contract.ProductAttributeUnitRcd = productAttributeUnitRcd;
productAttributeUnitRefCombo.Text = _contract.ProductAttributeUnitRcd != null ? _contract.ProductAttributeUnitRcd : String.Empty;
_contract.Value = value;
textBoxValue.Text = _contract.Value;
_contract.UserId = userId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// bring up add form for ProductAttribute
// links:
// docLink: http://sql2x.org/documentationLink/c0944961-8179-40a2-a561-c8873b691f2c
public void ShowAsAdd()
{
_contract = new CrudeProductAttributeContract();
_isNew = true;
this.Text += " - Not Savable (Product,User Missing)";
RefreshProductAttribute();
Show();
}
// bring up add form for ProductAttribute by foreign key Product
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByProduct(System.Guid productId)
{
_contract = new CrudeProductAttributeContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.ProductId = productId;
RefreshProductAttribute();
Show();
}
// bring up add form for ProductAttribute by foreign key ProductAttribute
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByProductAttribute(string productAttributeRcd)
{
_contract = new CrudeProductAttributeContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.ProductAttributeRcd = productAttributeRcd;
productAttributeRefCombo.Text = _contract.ProductAttributeRcd != null ? _contract.ProductAttributeRcd : String.Empty;
RefreshProductAttribute();
Show();
}
public ActionResult CrudeProductAttributeCreate([Bind()] CrudeProductAttributeContract contract)
{
if (ModelState.IsValid)
{
new CrudeProductAttributeServiceClient().Insert(contract);
return(RedirectToAction("CrudeProductAttributeIndex"));
}
return(View(
"~/Views/Crude/Product/CrudeProductAttribute/CrudeProductAttributeCreate.cshtml",
contract
));
}
public ActionResult CrudeProductAttributeCreate(System.Guid?productId, System.Guid?userId)
{
var contract = new CrudeProductAttributeContract();
if (productId != null)
{
contract.ProductId = (System.Guid)productId;
}
if (userId != null)
{
contract.UserId = (System.Guid)userId;
}
ViewBag.ProductId =
new SelectList(new CrudeProductServiceClient().FetchAll(),
"ProductId",
"ProductName",
contract.ProductId
);
ViewBag.ProductAttributeRcd =
new SelectList(new CrudeProductAttributeRefServiceClient().FetchAll(),
"ProductAttributeRcd",
"ProductAttributeName",
contract.ProductAttributeRcd
);
ViewBag.ProductAttributeUnitRcd =
new SelectList(new CrudeProductAttributeUnitRefServiceClient().FetchAll(),
"ProductAttributeUnitRcd",
"ProductAttributeUnitName",
contract.ProductAttributeUnitRcd
);
if (userId == null)
{
contract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}");
}
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
contract.DateTime = DateTime.UtcNow;
return(View(
"~/Views/Crude/Product/CrudeProductAttribute/CrudeProductAttributeCreate.cshtml",
contract
));
}
public ActionResult CrudeProductAttributeEdit([Bind()] CrudeProductAttributeContract contract)
{
if (ModelState.IsValid)
{
contract.DateTime = DateTime.UtcNow;
new CrudeProductAttributeServiceClient().Update(contract);
return(RedirectToAction("CrudeProductAttributeIndex"));
}
return(View(
"~/Views/Crude/Product/CrudeProductAttribute/CrudeProductAttributeEdit.cshtml",
contract
));
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/e04d0806-55ef-41cc-8669-acf0ddd850c7
public void ShowAsAdd()
{
try {
_contract = new CrudeProductAttributeContract();
_isNew = true;
this.Text += " - Not Savable (Product,User Missing)";
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// bring up add form for ProductAttribute
// links:
// docLink: http://sql2x.org/documentationLink/8568fd9a-b807-4aad-ac74-7826975e3241
public void ShowAsAdd(System.Guid productId, string productAttributeRcd, string productAttributeUnitRcd, string value, System.Guid userId)
{
_contract = new CrudeProductAttributeContract();
_isNew = true;
_contract.ProductId = productId;
_contract.ProductAttributeRcd = productAttributeRcd;
productAttributeRefCombo.Text = _contract.ProductAttributeRcd != null ? _contract.ProductAttributeRcd : String.Empty;
_contract.ProductAttributeUnitRcd = productAttributeUnitRcd;
productAttributeUnitRefCombo.Text = _contract.ProductAttributeUnitRcd != null ? _contract.ProductAttributeUnitRcd : String.Empty;
_contract.Value = value;
textBoxValue.Text = _contract.Value;
_contract.UserId = userId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
RefreshProductAttribute();
Show();
}
// shows by foreign keys
// links:
// docLink: http://sql2x.org/documentationLink/f21e72c1-2d57-44c1-a9c1-1b80bad6a391
public void ShowAsAddByProduct(System.Guid productId)
{
try {
_contract = new CrudeProductAttributeContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.ProductId = productId;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// shows by foreign keys
// links:
// docLink: http://sql2x.org/documentationLink/f21e72c1-2d57-44c1-a9c1-1b80bad6a391
public void ShowAsAddByProductAttributeUnit(string productAttributeUnitRcd)
{
try {
_contract = new CrudeProductAttributeContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.ProductAttributeUnitRcd = productAttributeUnitRcd;
productAttributeUnitRefCombo.Text = _contract.ProductAttributeUnitRcd != null ? _contract.ProductAttributeUnitRcd : String.Empty;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// bring up edit form for ProductAttribute
// links:
// docLink: http://sql2x.org/documentationLink/d7ff032d-3bcf-438f-9850-900ca0ebca98
public void ShowAsEdit(System.Guid productAttributeId)
{
var service = new CrudeProductAttributeServiceClient();
_isNew = false;
try {
_contract = service.FetchByProductAttributeId(productAttributeId);
productAttributeRefCombo.Text = _contract.ProductAttributeRcd != null ? _contract.ProductAttributeRcd : String.Empty;
productAttributeUnitRefCombo.Text = _contract.ProductAttributeUnitRcd != null ? _contract.ProductAttributeUnitRcd : String.Empty;
textBoxValue.Text = _contract.Value;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
RefreshProductAttribute();
Show();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
service.Close();
}
}
