public static int UpdateSalesOrder(SalesOrderDTO salesOrderDto) { string query = "UPDATE sale_order SET customer_id = " + salesOrderDto.Customer + "" + ", discription = '" + salesOrderDto.Description + "', total_price = " + salesOrderDto.Price + ", discount = " + salesOrderDto.Discount / 100 + ", date = '" + salesOrderDto.SalesOrderDate + "', pay_type = " + salesOrderDto.PayType + ", is_paid = " + salesOrderDto.IsPaid + ", paid_at = '" + salesOrderDto.PaidDate + "', status = " + salesOrderDto.SalesStatus + ", update_by = " + salesOrderDto.UpdatedBy + ", update_at = '" + DateTime.Now + "' WHERE id = " + salesOrderDto.Id; try { DataTable salesOrdrTable = DatabaseConnection.ConnectWithServer(query); if (salesOrdrTable == null) { return(-1); } return(1); } catch (Exception) { return(-1); } }
public static int AddSalesOrder(SalesOrderDTO salesOrderDto) { string query = "INSERT INTO sale_order (customer_id, discription, total_price, discount, date, pay_type, is_paid," + "paid_at, status, created_by) VALUES " + "( " + "" + salesOrderDto.Customer + ",'" + salesOrderDto.Description + "'," + salesOrderDto.Price + "," + salesOrderDto.Discount / 100 + ",'" + salesOrderDto.SalesOrderDate + "'," + salesOrderDto.PayType + "," + salesOrderDto.IsPaid + ",'" + DateTime.Now + "'," + salesOrderDto.SalesStatus + "," + salesOrderDto.CreatedBy + ")"; try { DataTable salesOrdrTable = DatabaseConnection.ConnectWithServer(query); if (salesOrdrTable == null) { return(-1); } return(1); } catch (Exception) { return(-1); } }