private void LoadData()
{
EnableMode();
SOMenu entity = new SOMenu();
if (modeHead == ObjectState.Edit && !string.IsNullOrEmpty(keyCode))
{
//---Header
entity.menu_id = Converts.ParseLong(keyCode);
entity = ServiceProvider.MenuService.FindByKeys(entity, true);
txtMenuCode.Text = entity.menu_code;
txtMenuName.Text = entity.menu_name;
txtMenuDescription.Text = entity.menu_description;
chkActive.Checked = entity.active;
//---Detail
modeDetail = ObjectState.Add;
InitialGridDetail();
LoadDataDetail(0);
}
else
{
txtMenuCode.Text = string.Empty;
txtMenuName.Text = string.Empty;
txtMenuDescription.Text = string.Empty;
chkActive.Checked = true;
}
}
private void AddEditHead_saveHandler()
{
try
{
SOMenu entity = GetData();
if (modeHead == ObjectState.Add)
{
int menuID = ServiceProvider.MenuService.Insert <int>(entity, new string[] { ValidationRuleset.Insert });
keyCode = menuID.ToString();
modeHead = ObjectState.Edit;
LoadData();
}
else
{
ServiceProvider.MenuService.Update(entity, new string[] { ValidationRuleset.Update });
LoadData();
}
base.formBase.ShowMessage(GeneralMessage.SaveComplete);
}
catch (ValidationException ex)
{
throw ex;
}
}
public List <OrderDTO> FindOrderDetail(long?order_head_id)
{
List <OrderDTO> result = new List <OrderDTO>();
string sql = @"
SELECT * FROM so_sales_order_detail WITH(NOLOCK)
WHERE sales_order_head_id=@order_head_id AND is_cancel=0
";
List <DbParameter> param = new List <DbParameter>();
param.Add(base.CreateParameter("@order_head_id", order_head_id));
List <SaleOrderDetail> orderdetail = this.ExecuteQuery <SaleOrderDetail>(sql, param.ToArray()).ToList();
if (orderdetail != null && orderdetail.Count > 0)
{
foreach (SaleOrderDetail item in orderdetail)
{
OrderDTO dtoItem = new OrderDTO();
dtoItem.OrderState = ObjectState.Nothing;
dtoItem.sales_order_detail_id = item.sales_order_detail_id;
dtoItem.sales_order_head_id = item.sales_order_head_id;
dtoItem.menu_dining_type_id = item.menu_dining_type_id;
dtoItem.order_amount = item.order_amount;
dtoItem.is_print = item.is_print;
dtoItem.is_cancel = item.is_cancel;
dtoItem.ChkNo = item.ChkNo;
dtoItem.menu_name = item.Open_Condiment;
dtoItem.condiment_of_order_detail_id = item.condiment_of_order_detail_id;
dtoItem.IsCondiment = item.condiment_of_order_detail_id.HasValue;
if (item.order_unit_price.HasValue)
{
dtoItem.order_unit_price = item.order_unit_price.Value;
}
// Update Form Menu DiningType
MenuDiningType menuDiningType = new MenuDiningType();
menuDiningType.menu_dining_type_id = item.menu_dining_type_id;
menuDiningType = ServiceProvider.MenuDiningTypeService.FindByKeys(menuDiningType, false);
if (menuDiningType != null)
{
dtoItem.ref_menu_dining_type_id = menuDiningType.ref_menu_dining_type_id;
dtoItem.dining_type_id = menuDiningType.dining_type_id;
// Update Form Menu
SOMenu menuItem = new SOMenu();
menuItem.menu_id = menuDiningType.menu_id;
menuItem = ServiceProvider.MenuService.FindByKeys(menuItem, false);
dtoItem.menu_name = menuItem.menu_name;
dtoItem.menu_category_id = menuItem.menu_category_id;
dtoItem.menu_group_id = menuItem.menu_group_id;
}
result.Add(dtoItem);
}
}
return(result);
}
private SOMenu GetData()
{
SOMenu entity = new SOMenu();
entity.menu_id = Converts.ParseLong(keyCode);
entity.menu_code = txtMenuCode.Text;
entity.menu_name = txtMenuName.Text;
entity.menu_description = txtMenuDescription.Text;
entity.menu_reference_id = null;
entity.active = chkActive.Checked;
entity.created_by = "SYSTEM";
entity.created_date = DateTime.Now;
entity.updated_by = "SYSTEM";
entity.updated_date = DateTime.Now;
return(entity);
}
