public JsonResult AddCalculation(SaveCalculation calculation)
{
long userID = User.Identity.GetUserId <long>();
var user = _userService.GetUser(userID);
Calculation calc = new Calculation
{
CalculationTypeID = calculation.CalculationTypeID,
Description = calculation.Description,
DocumentID = calculation.DocumentID
};
_calculationService.AddCalculation(calc);
if (!_documentRepository.IsOwner(calc.DocumentID, userID))
{
_docLogRepository.AddAdded(userID, calc.CalculationID);
}
calculation.CalculationID = calc.CalculationID;
return(Json(calculation));
}
public IHttpActionResult AddOrder([FromBody] OrderMaster orderMaster)
{
SaveCalculation saveCalculation = new SaveCalculation();
saveCalculation.totalPriceCalculation(orderMaster);
orderMaster.orderDate = DateTime.Now;
bool orderCreated = false;
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["OMS"].ToString()))
{
connection.Open();
SqlCommand testCMD = new SqlCommand("createorder", connection);
testCMD.CommandType = CommandType.StoredProcedure;
testCMD.Parameters.Add(new SqlParameter("@OrderDate", System.Data.SqlDbType.VarChar, 50)
{
Value = orderMaster.orderDate
});
testCMD.Parameters.Add(new SqlParameter("@AddressId", System.Data.SqlDbType.VarChar, 50)
{
Value = orderMaster.addressId
});
testCMD.Parameters.Add(new SqlParameter("@Total_Amount", System.Data.SqlDbType.VarChar, 50)
{
Value = orderMaster.totalPrice
});
testCMD.Parameters.Add(new SqlParameter("@OrderMasterId", System.Data.SqlDbType.VarChar, 50)
{
Value = orderMaster.orderId
});
testCMD.Parameters["@OrderMasterId"].Direction = ParameterDirection.Output;
testCMD.ExecuteNonQuery(); // read output value from @NewId
orderMaster.orderId = Convert.ToInt32(testCMD.Parameters["@OrderMasterId"].Value);
List <OrderDetails> orderDetails = new List <OrderDetails>();
orderDetails = orderMaster.orderDetails;
foreach (var i in orderDetails)
{
SqlCommand testCMD1 = new SqlCommand("createorderdetail", connection);
testCMD1.CommandType = CommandType.StoredProcedure;
testCMD1.Parameters.Add(new SqlParameter("@OrderMasterId", System.Data.SqlDbType.VarChar, 50)
{
Value = orderMaster.orderId
});
testCMD1.Parameters.Add(new SqlParameter("@ProductId", System.Data.SqlDbType.VarChar, 50)
{
Value = i.productid
});
testCMD1.Parameters.Add(new SqlParameter("@Quantity", System.Data.SqlDbType.VarChar, 50)
{
Value = i.quantity
});
testCMD1.Parameters.Add(new SqlParameter("@Price", System.Data.SqlDbType.VarChar, 50)
{
Value = i.quantity
});
testCMD1.ExecuteNonQuery();
}
orderCreated = SendMail("Order Number :" + orderMaster.orderId + " is Created on " + DateTime.Now);
}
if (orderCreated)
{
return(Ok());
}
else
{
return(BadRequest());
}
}
