}//end of display
public static async Task <int> GetNewCartHeader(CartHeaderModel cartHeader)
{
var newCartDetailItem = 0;
var salesDate = DateTime.Now;
String SQL = "INSERT INTO CartHeader( UserID, CreatedDate)" +
"output INSERTED.CartHeaderID VALUES('" + cartHeader.UserID + "', '" + salesDate + "')";
using (SqlConnection dbConn = new SqlConnection(connectionString))
{
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL;
cmd.Connection = dbConn;
newCartDetailItem = (int)cmd.ExecuteScalar();
dbConn.Close();
return(newCartDetailItem);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(newCartDetailItem);
}
finally
{
dbConn.Close();
}
}
}//end of display
public async Task <IHttpActionResult> OpenNewBill(CartHeaderModel cartHeader)
{
CommonResponse validatedResponse = await AuthService.ValidateUserAndToken();
if (!validatedResponse.IsError)
{
var headerID = await SalesService.GetNewCartHeader(cartHeader);
if (headerID > 0)
{
return(Ok(headerID));
}
else
{
return(BadRequest("No Sales Exists!"));
}
}
else
{
return(Unauthorized());
}
}//end of get
