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);
}
}
