public bool DeleteS35MenuDetail(S35MenuDetail data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@S35MenuDetailID", data.S35MenuDetailID),
new SqlParameter("@CompanyID", data.CompanyID),
new SqlParameter("@UpdateUser", UserInfo.UserID)
};
this.Context.ExecuteDataFromProcedure("S35MenuDetailDelete", sqlParameters);
return(true);
}
public bool UpdateS35MenuDetail(S35MenuDetail data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@S35MenuDetailID", data.S35MenuDetailID),
new SqlParameter("@S35MenuID", data.S35MenuID),
new SqlParameter("@ItemID", data.ItemID),
new SqlParameter("@Quantity", data.Quantity),
new SqlParameter("@Price", data.Price),
new SqlParameter("@Amount", data.Amount),
new SqlParameter("@VAT", data.VAT),
new SqlParameter("@VATAmount", data.VATAmount),
new SqlParameter("@TotalAmount", data.TotalAmount),
new SqlParameter("@CompanyID", data.CompanyID),
new SqlParameter("@UpdateUser", UserInfo.UserID)
};
this.Context.ExecuteDataFromProcedure("S35MenuDetailUpdate", sqlParameters);
return(true);
}