private OdrLine ConvertToEntity(DataRow row)
{
if (row == null)
{
return(null);
}
OdrLine ol = new OdrLine();
ol.order_no = int.Parse(row["order_no"].ToString());
ol.menu_no = int.Parse(row["menu_no"].ToString());
ol.quantity = int.Parse(row["quantity"].ToString());
return(ol);
}
public Result <OdrLine> AddOrderLine(OdrLine ol)
{
var result = new Result <OdrLine>();
string query = "select * from order_line where order_no = " + ol.order_no + ";";
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
query = "Insert into order_line values (" + ol.menu_no + "," + ol.quantity + ");";
}
result.HasError = DataAccess.ExecuteQuery(query) <= 0;
if (result.HasError)
{
result.Message = "Wrong";
}
else
{
result.Data = ol;
}
return(result);
}
public Result <List <OdrLine> > GetAllOrderLine()
{
var result = new Result <List <OdrLine> >()
{
Data = new List <OdrLine>()
};
try
{
string query = "Select * from order_line";
var dt = DataAccess.GetDataTable(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
OdrLine ol = ConvertToEntity(dt.Rows[i]);
result.Data.Add(ol);
}
}
catch (Exception exc)
{
result.HasError = true;
result.Message = exc.Message;
}
return(result);
}
