public HttpResponseMessage AddNewUser(HttpRequestMessage request, [FromBody] UserViewModel viewModel)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectService projectService = new ProjectService();
if (viewModel == null)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Empty UserViewModel!");
}
else
{
viewModel.UserDto.UserID = Guid.NewGuid().ToString();
transStatus = projectService.AddNewUser(viewModel.UserDto);
}
if (transStatus.ReturnStatus == false)
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
var badresponse = Request.CreateResponse <UserViewModel>(HttpStatusCode.BadRequest, viewModel);
return(badresponse);
}
else
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
viewModel.ReturnMessage.Add("User successfully added");
var response = Request.CreateResponse <UserViewModel>(HttpStatusCode.Created, viewModel);
return(response);
}
}
public HttpResponseMessage UpdateProduct(HttpRequestMessage request, [FromBody] ProductViewModel viewModel)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectService projectService = new ProjectService();
if (viewModel == null)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Empty ProductViewModel!");
}
else
{
transStatus = projectService.UpdateProduct(viewModel.ProductDto);
}
if (transStatus.ReturnStatus == false)
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
var badresponse = Request.CreateResponse <ProductViewModel>(HttpStatusCode.BadRequest, viewModel);
return(badresponse);
}
else
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
viewModel.ReturnMessage.Add("Product successfully updated");
var response = Request.CreateResponse <ProductViewModel>(HttpStatusCode.Created, viewModel);
return(response);
}
}
public TransactionStatusModel UpdateProduct(ProductDTO product)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
using (SqlConnection con = new SqlConnection(cs))
{
try
{
SqlCommand cmd = new SqlCommand("UpdateProduct", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@productId", product.ProductId));
cmd.Parameters.Add(new SqlParameter("@name", product.Name));
cmd.Parameters.Add(new SqlParameter("@description", product.Description));
cmd.Parameters.Add(new SqlParameter("@stockAmount", product.StockAmount));
cmd.Parameters.Add(new SqlParameter("@checkAmount", product.CheckAmount));
cmd.Parameters.Add(new SqlParameter("@sellPrice", product.SellPrice));
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
transStatus.ReturnMessage.Add("Update Product failed");
transStatus.ReturnStatus = false;
return(transStatus);
}
}
transStatus.ReturnMessage.Add("Product successfully updated");
transStatus.ReturnStatus = true;
return(transStatus);
}
public TransactionStatusModel AddSale(SaleDTO sale)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
using (SqlConnection con = new SqlConnection(cs))
{
try
{
SqlCommand cmd = new SqlCommand("AddSale", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@transactionId", sale.TransactionId));
cmd.Parameters.Add(new SqlParameter("@productId", sale.ProductDto.ProductId));
cmd.Parameters.Add(new SqlParameter("@totalPrice", sale.TotalPrice));
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
transStatus.ReturnMessage.Add("Add Sale failed");
transStatus.ReturnStatus = false;
return(transStatus);
}
}
transStatus.ReturnMessage.Add("Sale successfully added");
transStatus.ReturnStatus = true;
return(transStatus);
}
public TransactionStatusModel UpdateUser(UserDTO user)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
using (SqlConnection con = new SqlConnection(cs))
{
try
{
SqlCommand cmd = new SqlCommand("UpdateUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@userId", user.UserID));
cmd.Parameters.Add(new SqlParameter("@firstName", user.FirstName));
cmd.Parameters.Add(new SqlParameter("@lastName", user.LastName));
cmd.Parameters.Add(new SqlParameter("@address", user.Address));
cmd.Parameters.Add(new SqlParameter("@mobile", user.Mobile));
cmd.Parameters.Add(new SqlParameter("@username", user.Username));
cmd.Parameters.Add(new SqlParameter("@password", user.Password));
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
transStatus.ReturnMessage.Add("User Product failed");
transStatus.ReturnStatus = false;
return(transStatus);
}
}
transStatus.ReturnMessage.Add("User successfully updated");
transStatus.ReturnStatus = true;
return(transStatus);
}
public TransactionStatusModel UpdateStock(ProductDTO product)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
using (SqlConnection con = new SqlConnection(cs))
{
try
{
SqlCommand cmd = new SqlCommand("UpdateStock", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@productId", product.ProductId));
cmd.Parameters.Add(new SqlParameter("@stockLevel", product.StockAmount));
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
transStatus.ReturnMessage.Add("Update Stock failed");
transStatus.ReturnStatus = false;
return(transStatus);
}
}
transStatus.ReturnMessage.Add("Product stock updated");
transStatus.ReturnStatus = true;
return(transStatus);
}
public TransactionStatusModel AddTransaction(TransactionDTO transaction)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
using (SqlConnection con = new SqlConnection(cs))
{
try
{
SqlCommand cmd = new SqlCommand("AddTransaction", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@transactionId", transaction.TransactionId));
cmd.Parameters.Add(new SqlParameter("@userId", transaction.UserId));
cmd.Parameters.Add(new SqlParameter("@datetime", transaction.DateTime));
cmd.Parameters.Add(new SqlParameter("@totalPrice", transaction.TotalPrice));
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
transStatus.ReturnMessage.Add("Add Transaction failed");
transStatus.ReturnStatus = false;
return(transStatus);
}
}
transStatus.ReturnMessage.Add("Transaction successfully added");
transStatus.ReturnStatus = true;
return(transStatus);
}
public HttpResponseMessage AddTransaction(HttpRequestMessage request, [FromBody] TransactionViewModel viewModel)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectService projectService = new ProjectService();
if (viewModel == null)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Empty TransactionViewModel!");
}
else
{
viewModel.TransactionDto.TransactionId = Guid.NewGuid().ToString();
viewModel.TransactionDto.DateTime = DateTime.Now; // uncomment for normal usability
//var rnd = new Random();
//comment out these next two lines when not using Sale Generator button
//DateTime today = DateTime.Now;
//viewModel.TransactionDto.DateTime = today.AddDays(- rnd.Next(0, 120));
foreach (var sale in viewModel.TransactionDto.SaleDtoList)
{
sale.TransactionId = viewModel.TransactionDto.TransactionId;
}
transStatus = projectService.AddTransaction(viewModel.TransactionDto);
}
if (transStatus.ReturnStatus == false)
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
var badresponse = Request.CreateResponse <TransactionViewModel>(HttpStatusCode.BadRequest, viewModel);
return(badresponse);
}
else
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
viewModel.ReturnMessage.Add("Transaction successfully added");
var response = Request.CreateResponse <TransactionViewModel>(HttpStatusCode.Created, viewModel);
return(response);
}
}
public HttpResponseMessage AddTransaction(HttpRequestMessage request, [FromBody] TransactionViewModel viewModel)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectService projectService = new ProjectService();
if (viewModel == null)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Empty TransactionViewModel!");
}
else
{
viewModel.TransactionDto.TransactionId = Guid.NewGuid().ToString();
viewModel.TransactionDto.DateTime = DateTime.Now;
foreach (var sale in viewModel.TransactionDto.SaleDtoList)
{
sale.TransactionId = viewModel.TransactionDto.TransactionId;
}
transStatus = projectService.AddTransaction(viewModel.TransactionDto);
}
if (transStatus.ReturnStatus == false)
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
var badresponse = Request.CreateResponse <TransactionViewModel>(HttpStatusCode.BadRequest, viewModel);
return(badresponse);
}
else
{
viewModel.ReturnMessage = transStatus.ReturnMessage;
viewModel.ReturnStatus = transStatus.ReturnStatus;
viewModel.ReturnMessage.Add("Transaction successfully added");
var response = Request.CreateResponse <TransactionViewModel>(HttpStatusCode.Created, viewModel);
return(response);
}
}
public TransactionStatusModel AddNewProduct(ProductDTO product)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectDataService dataService = new ProjectDataService();
using (TransactionScope tran = new TransactionScope())
{
try
{
transStatus = dataService.AddNewProduct(product);
} catch (Exception ex)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Add Product Failed");
return(transStatus);
}
tran.Complete();
}
return(transStatus);
}
public TransactionStatusModel AddTransaction(TransactionDTO transaction)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectDataService dataService = new ProjectDataService();
using (TransactionScope tran = new TransactionScope())
{
try
{
transStatus = dataService.AddTransaction(transaction);
}
catch (Exception ex)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Add Transaction Failed");
return(transStatus);
}
try
{
foreach (var sale in transaction.SaleDtoList)
{
transStatus = dataService.AddSale(sale);
transStatus = dataService.UpdateStock(sale.ProductDto); //comment out this line when using Sale Generator
}
}
catch (Exception ex)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Add Sale Failed");
return(transStatus);
}
tran.Complete();
}
return(transStatus);
}
public TransactionStatusModel UpdateUser(UserDTO user)
{
TransactionStatusModel transStatus = new TransactionStatusModel();
ProjectDataService dataService = new ProjectDataService();
using (TransactionScope tran = new TransactionScope())
{
try
{
transStatus = dataService.UpdateUser(user);
}
catch (Exception ex)
{
transStatus.ReturnStatus = false;
transStatus.ReturnMessage.Add("Update User Failed");
return(transStatus);
}
tran.Complete();
}
return(transStatus);
}
public void Update(TransactionStatusModel item)
{
throw new NotImplementedException();
}
