public ChangeOrderStatusResponseModel changePaymentStatus(ChangePaymentStatusRequestModel changePaymentStatusRequest, out ErrorModel errorModel)
{
errorModel = null;
try
{
Order orderHelper = new Order();
ChangeOrderStatusResponseModel response = orderHelper.changePaymentStatus(changePaymentStatusRequest, out errorModel);
return(response);
}
catch (Exception)
{
return(null);
}
}
public async Task <JsonResult> ChangeOrderStatus(int orderId)
{
Order order = await _orderService.GetOrderAsync(orderId);
order.OrderStatus++;
await _orderService.UpdateAsync(order);
ChangeOrderStatusResponseModel responseModel = new ChangeOrderStatusResponseModel
{
Order = order,
OrderListPanelInformation = OrderListHelper.GetOrderListPanelInformation((OrderStatusEnum)order.OrderStatus)
};
return(Json(responseModel));
}
public ChangeOrderStatusResponseModel changePassword(ChangePasswordRequestModel changePasswordRequest, out ErrorModel errorModel)
{
SqlConnection connection = null;
errorModel = null;
try
{
using (connection = new SqlConnection(Database.getConnectionString()))
{
SqlCommand command = new SqlCommand("", connection);
command.CommandText = "update users set password = CONVERT(varchar(64), HASHBYTES('SHA2_256', '" + changePasswordRequest.password + "') ,2) where userId = " + changePasswordRequest.userId;
connection.Open();
int reader = command.ExecuteNonQuery();
if (reader != 0)
{
ChangeOrderStatusResponseModel changeOrderStatusResponseModel = new ChangeOrderStatusResponseModel();
changeOrderStatusResponseModel.StatusCode = "1";
changeOrderStatusResponseModel.StatusMessage = "Password changed Successfully";
return(changeOrderStatusResponseModel);
}
else
{
ChangeOrderStatusResponseModel changeOrderStatusResponseModel = new ChangeOrderStatusResponseModel();
changeOrderStatusResponseModel.StatusCode = "0";
changeOrderStatusResponseModel.StatusMessage = "Not Succesfull updated";
return(changeOrderStatusResponseModel);
}
}
return(null);
}
catch (Exception e)
{
errorModel = new ErrorModel();
errorModel.ErrorMessage = e.Message;
return(null);
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
public ChangeOrderStatusResponseModel readyToPay(ReadyForPaymentRequestModel readyForPaymentRequest, out ErrorModel errorModel)
{
errorModel = null;
ChangeOrderStatusResponseModel changeOrderStatusResponse = new ChangeOrderStatusResponseModel();
SqlConnection connection = null;
try
{
using (connection = new SqlConnection(Database.getConnectionString()))
{
SqlCommand command = new SqlCommand(SqlCommands.SP_readyToPay, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("orderId", readyForPaymentRequest.orderId);
command.Parameters.AddWithValue("tip", readyForPaymentRequest.tip);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
changeOrderStatusResponse.StatusCode = reader["StatusCode"].ToString();
changeOrderStatusResponse.StatusMessage = reader["StatusMessage"].ToString();
}
command.Dispose();
return(changeOrderStatusResponse);
}
}
catch (Exception e)
{
errorModel = new ErrorModel();
errorModel.ErrorMessage = e.Message;
return(null);
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
