public IActionResult PrintToFile(SalesDTO input)
{
try
{
double?price = 0;
if (ModelState.IsValid)
{
if (input.Discount != null && input.Discount > 0)
{
var calculatedPrice = _salesLogic.CalculateDiscountedPrice(input);
price = calculatedPrice;
}
else
{
var calculatedPrice = _salesLogic.CalculatePrice(input);
price = calculatedPrice;
}
ViewBag.TotalPrice = price;
var directory = Directory.GetCurrentDirectory();
directory = directory + "/Result.txt";
System.IO.File.AppendAllText(directory, "\n Total Price : " + price);
ViewBag.FileResult = 1;
}
return(View("_result"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public IActionResult AlertResult(SalesDTO input)
{
try
{
double?price = 0;
if (ModelState.IsValid)
{
if (input.Discount != null && input.Discount > 0)
{
var calculatedPrice = _salesLogic.CalculateDiscountedPrice(input);
price = calculatedPrice;
ViewBag.Preveledge = "1";
}
else
{
var calculatedPrice = _salesLogic.CalculatePrice(input);
price = calculatedPrice;
}
ViewBag.TotalPrice = price;
ViewBag.Alert = 1;
}
return(View("_sales"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public SalesDTO GetSalesbyId(int id)
{
Sales sale = context.Sales.Find(id);
SalesDTO Sale = mapper.Map <SalesDTO>(sale);
return(Sale);
}
public async Task <ActionResult <SalesDTO> > PostSales(Sales sales)
{
sales.CreatedAt = DateTime.Now;
_context.Sales.Add(sales);
await _context.SaveChangesAsync();
_context.Entry(sales).Reference(x => x.Customer).Load();
_context.Entry(sales).Reference(x => x.Product).Load();
_context.Entry(sales).Reference(x => x.Store).Load();
var dto = new SalesDTO()
{
Id = sales.Id,
CustomerId = sales.CustomerId,
ProductId = sales.ProductId,
StoreId = sales.StoreId,
DateSold = sales.DateSold,
CustomerName = sales.Customer.Name,
ProductName = sales.Product.Name,
StoreName = sales.Store.Name
};
//return CreatedAtRoute("GetSales", new { id = sales.Id }, dto);
return(dto);
}
public IActionResult Calculate(SalesDTO input)
{
try
{
if (ModelState.IsValid)
{
if (input.Discount != null && input.Discount > 0)
{
var calculatedPrice = _salesLogic.CalculateDiscountedPrice(input);
ViewBag.TotalPrice = calculatedPrice;
return(View("_result"));
}
else
{
var calculatedPrice = _salesLogic.CalculatePrice(input);
ViewBag.TotalPrice = calculatedPrice;
return(View("_result"));
}
}
return(View("_sales", input));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Response <SalesDTO> Create(SalesDTO sale)
{
try
{
sale.Status = DTO.Entities.ModelEnums.Status.Active;
sale.UpdateDate = DateTime.Now;
sale.UploadDate = DateTime.Now;
Sales entity = null;
entity = Map <Sales>(sale);
_saleRepository.Create(entity);
_unitOfWork.SaveChanges();
sale.Id = entity.Id;
return(new Response <SalesDTO>()
{
IsSuccess = true, Message = "Eklendi.", Result = sale
});
}
catch (Exception ex)
{
return(new Response <SalesDTO>()
{
IsSuccess = false, Exception = ex, Message = "Hata oluştu."
});
}
}
private void btnGetBack_Click(object sender, EventArgs e)
{
if (cmbDeletedData.SelectedIndex == 0)
{
if (categorybll.GetBack(categorydetail))
{
MessageBox.Show("The category has been recovered");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Categories;
}
}
else if (cmbDeletedData.SelectedIndex == 1)
{
if (customerbll.GetBack(customerdetail))
{
MessageBox.Show("The customer has been recovered");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Customers;
}
}
else if (cmbDeletedData.SelectedIndex == 2)
{
if (productdetail.isCategoryDeleted)
{
MessageBox.Show("Category was deleted, you must get it back");
}
else if (productbll.GetBack(productdetail))
{
MessageBox.Show("The product has been recovered");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Products;
}
}
else
{
if (salesdetail.isCategoryDeleted || salesdetail.isCustomerDeleted || salesdetail.isProductDeleted)
{
if (salesdetail.isCategoryDeleted)
{
MessageBox.Show("Category was deleted, you must get it back");
}
if (salesdetail.isCustomerDeleted)
{
MessageBox.Show("Customer was deleted, you must get it back");
}
if (salesdetail.isProductDeleted)
{
MessageBox.Show("Product was deleted, you must get it back");
}
}
else if (salesbll.GetBack(salesdetail))
{
MessageBox.Show("The sale has been recovered");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Sales;
}
}
}
public int AddSales(SalesDTO salesDTO)
{
Manager manager = Database.Managers.Find(x => x.SecondName == salesDTO.ManagerName).FirstOrDefault();
Customer customer = Database.Customers.Find(x => x.FullName == salesDTO.CustomerName).FirstOrDefault();
Product product = Database.Products.Find(x => x.Name == salesDTO.ProductName).FirstOrDefault();
Sales sales = new Sales
{
DateTime = salesDTO.DateTime,
Amount = salesDTO.Amount
};
if (manager == null)
{
manager = new Manager()
{
SecondName = salesDTO.ManagerName
};
sales.Manager = manager;
}
else
{
sales.ManagerID = manager.Id;
}
if (customer == null)
{
customer = new Customer()
{
FullName = salesDTO.CustomerName
};
sales.Customer = customer;
}
else
{
sales.CustomerID = customer.Id;
}
if (product == null)
{
product = new Product()
{
Name = salesDTO.ProductName
};
sales.Product = product;
}
else
{
sales.ProductID = product.Id;
}
Database.Saleses.Create(sales);
int id = Database.Saleses.GetAll().OrderByDescending(x => x.Id).Select(z => z.Id).FirstOrDefault();
return(id);
}
/// <summary>
/// Actualiza un Sales por medio del id
/// </summary>
public void Update(string id, SalesDTO entity)
{
using (var dbContextScope = new TiendaDbContext())
{
_repository.Update(this.GetEntity(entity), id);
dbContextScope.SaveChanges();
}
}
private void btnGetBack_Click(object sender, EventArgs e)
{
if (cmbDeletedData.SelectedIndex == 0)
{
if (categoryBLL.GetBack(categorydetail))
{
MessageBox.Show("Category was Get back");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Categories;
}
}
else if (cmbDeletedData.SelectedIndex == 1)
{
if (customerBLL.GetBack(customerdetail))
{
MessageBox.Show("Customer was Get back");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Customers;
}
}
else if (cmbDeletedData.SelectedIndex == 2)
{
if (productdetail.isCategoryDeleted)
{
MessageBox.Show("Category was deleted first get back category");
}
else if (productBLL.GetBack(productdetail))
{
MessageBox.Show("Product was Get back");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Products;
}
}
else
{
if (salesdetail.isCategoryDeleted || salesdetail.isCustomerDeleted || salesdetail.isProductDeleted)
{
if (salesdetail.isCategoryDeleted)
{
MessageBox.Show("Category was deleted first get back category");
}
else if (salesdetail.isCustomerDeleted)
{
MessageBox.Show("customer was deleted first get back category");
}
else if (salesdetail.isProductDeleted)
{
MessageBox.Show("Product was deleted first get back category");
}
}
else if (salesBLL.GetBack(salesdetail))
{
MessageBox.Show("Sales was Get back");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Sales;
}
}
}
/// <summary>
/// Metodo que dada una entidad devuelve su DTO
/// </summary>
/// <param name="entity">Entidad de la cual se requiere el DTO</param>
/// <returns>DTO para la entidad pasada por parametro</returns>
private SalesDTO GetDTO(Sales entity)
{
SalesDTO dto = new SalesDTO();
dto.SalesId = entity.SalesId;
this.SetDTOExtras(entity, ref dto);
return(dto);
}
public bool UpdateSalesData(SalesDTO sales)
{
context.Sales.Update(mapper.Map <Sales>(sales));
if (context.SaveChanges() == 1)
{
return(true);
}
return(false);
}
public bool DeleteSalesData(SalesDTO deletesales)
{
context.Sales.Remove(mapper.Map <Sales>(deletesales));
if (context.SaveChanges() == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// Servicio que permite insertar una nueva entidad: Sales (Sales)
/// </summary>
/// <param name="entity">DTO de la entidad a insertar</param>
/// <param name="user">Usuario que ejecuta la inserción</param>
/// <returns>Se devulve el DTO de la entidad creada con el id asignado</returns>
public SalesDTO Insert(SalesDTO dto, string user)
{
using (var dbContextScope = new TiendaDbContext())
{
Sales entity = GetEntity(dto);
entity = _repository.Insert(entity, user);
dbContextScope.SaveChanges();
return(GetDTO(entity));
}
}
// GET: Sales/Create
public ActionResult Create()
{
var model = new SalesDTO {
};
model.CustomerList = operations.GetAllCustomers();
model.StoreList = operations.GetAllStores();
model.ProductList = operations.GetAllProducts();
return(View(model));
}
public int AddSales(SalesViewModel salesViewModel)
{
if (salesViewModel != null)
{
SalesDTO salesDto = Mapper.Map <SalesDTO>(salesViewModel);
int id = _salesService.AddSales(salesDto);
return(id);
}
else
{
return(0);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
var frm = new FrmSales();
frm.dto = dto;
this.Hide();
frm.ShowDialog();
this.Visible = true;
dto = bll.Select();
dataGridView1.DataSource = dto.Sales;
CleanFilter();
}
public List <SalesDTO> GetSalesData()
{
List <SalesDTO> sales = new List <SalesDTO>();
List <Sales> allSales = context.Sales.Include("Customer").Include("Store").Include("Product").ToList();
foreach (var item in allSales)
{
SalesDTO sale = mapper.Map <SalesDTO>(item);
sales.Add(sale);
}
return(sales);
}
public int EditSales(SalesViewModel salesViewModel)
{
if (salesViewModel != null)
{
SalesDTO salesDto = Mapper.Map <SalesDTO>(salesViewModel);
_salesService.EditSales(salesDto);
return(1);
}
else
{
return(0);
}
}
public void EditSales(SalesDTO salesDTO)
{
Manager manager = Database.Managers.Find(x => x.SecondName == salesDTO.ManagerName).FirstOrDefault();
Customer customer = Database.Customers.Find(x => x.FullName == salesDTO.CustomerName).FirstOrDefault();
Product product = Database.Products.Find(x => x.Name == salesDTO.ProductName).FirstOrDefault();
Sales sales = Mapper.Map <Sales>(salesDTO);
sales.ManagerID = manager.Id;
sales.CustomerID = customer.Id;
sales.ProductID = product.Id;
Database.Saleses.Update(sales);
}
public async Task <ActionResult <Sales> > Add(SalesDTO salesDTO)
{
if (!(await ProductsExists(salesDTO.productId)))
{
return(BadRequest("Product does not exist"));
}
if (!(await UserExists(salesDTO.userId)))
{
return(BadRequest("User does not exist"));
}
var productIdStr = salesDTO.productId.ToString();
var sale = new Sales {
productId = productIdStr,
userId = salesDTO.userId,
price = salesDTO.price,
amount = salesDTO.amount
};
var product = await _context.Products.FindAsync(salesDTO.productId);
if (salesDTO.amount <= product.quantity)
{
var new_amount = product.quantity - salesDTO.amount;
product.quantity = new_amount;
}
else
{
return(BadRequest("The input amount cannot be larger than the quantity of product"));
}
var total_price = salesDTO.amount * salesDTO.price;
var prod_id = salesDTO.productId;
var producttt = await _context.Products.SingleOrDefaultAsync(x => x.Id == prod_id);
var user_id = producttt.userId;
var user = await _context.Users.SingleOrDefaultAsync(x => x.Id == user_id);
user.Balance = user.Balance + total_price;
_context.Sales.Add(sale);
await _context.SaveChangesAsync();
return(sale);
}
private void FrmSalesLIst_Load(object sender, EventArgs e)
{
dto = bll.Select();
dataGridView1.DataSource = dto.Sales;
dataGridView1.Columns[0].HeaderText = "Customer";
dataGridView1.Columns[1].HeaderText = "Product";
dataGridView1.Columns[2].HeaderText = "Category";
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
cbCategory.DataSource = dto.Categories;
cbCategory.DisplayMember = "CategoryName";
cbCategory.ValueMember = "ID";
cbCategory.SelectedIndex = -1;
}
public async Task <ActionResult <SalesDTO> > PutSales(int id, Sales sales)
{
if (id != sales.Id)
{
return(BadRequest());
}
_context.Entry(sales).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SalesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
_context.Entry(sales).Reference(x => x.Customer).Load();
_context.Entry(sales).Reference(x => x.Product).Load();
_context.Entry(sales).Reference(x => x.Store).Load();
var dto = new SalesDTO()
{
Id = sales.Id,
CustomerId = sales.CustomerId,
ProductId = sales.ProductId,
StoreId = sales.StoreId,
DateSold = sales.DateSold,
CustomerName = sales.Customer.Name,
ProductName = sales.Product.Name,
StoreName = sales.Store.Name
};
return(dto);
//return NoContent();
}
public IEnumerable <SalesDTO> GetSales()
{
IEnumerable <Sales> allSales = Database.Saleses.GetAll();
List <SalesDTO> allSalesDTO = new List <SalesDTO>();
foreach (var sales in allSales)
{
SalesDTO salesDTO = new SalesDTO();
salesDTO.Id = sales.Id;
salesDTO.DateTime = sales.DateTime;
salesDTO.Amount = sales.Amount;
salesDTO.ManagerName = sales.Manager.SecondName;
salesDTO.CustomerName = sales.Customer.FullName;
salesDTO.ProductName = sales.Product.Name;
allSalesDTO.Add(salesDTO);
}
return(allSalesDTO);
}
private Sales GetEntity(SalesDTO dto)
{
using (_dbContextScopeFactory)
{
Sales entity = null;
if (dto.SalesId > 0)
{
entity = _repository.Get(dto.SalesId);
}
if (entity == null)
{
entity = new Sales();
}
entity.SalesId = dto.SalesId;
this.SetEntityExtras(ref entity, dto);
return(entity);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (detail.SalesID == 0)
{
MessageBox.Show("Please select asales from table");
}
else
{
FrmSales frm = new FrmSales();
frm.isUpdate = true;
frm.detail = detail;
frm.dto = dto;
this.Hide();
frm.ShowDialog();
this.Visible = true;
bll = new SalesBLL();
dto = bll.Select();
dataGridView1.DataSource = dto.Sales;
CleanFilters();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (detail.SalesID == 0)
{
MessageBox.Show("Please select a sales from table");
}
else
{
DialogResult result = MessageBox.Show("Are you sure?", "Warning!!", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
if (bll.Delete(detail))
{
MessageBox.Show("Sales was deleted");
bll = new SalesBLL();
dto = bll.Select();
dataGridView1.DataSource = dto.Sales;
CleanFilters();
}
}
}
}
public Task <CommandResult> ProductSales([FromBody] SalesDTO salesDTO)
{
var salesCommand = new SalesCommand
{
SalesId = Guid.NewGuid().ToString(),
SalesDate = salesDTO.SalesDate
};
foreach (SalesProductDTO productDTO in salesDTO.SalesProducts)
{
var product = new SalesProduct
{
ProductId = productDTO.ProductId,
ProductName = productDTO.ProductName,
UnitName = productDTO.UnitName,
SalesUnitPrice = productDTO.UnitPrice,
SalesQuantity = productDTO.Quantity
};
salesCommand.SalesProducts.Add(product);
}
return(commandBus.Send <SalesCommand, CommandResult>(salesCommand));
}
private void FrmDeleted_Load(object sender, EventArgs e)
{
cmbDeletedData.Items.Add("Category");
cmbDeletedData.Items.Add("Customer");
cmbDeletedData.Items.Add("Product");
cmbDeletedData.Items.Add("Sales");
dto = bll.Select(true);
dataGridView1.DataSource = dto.Sales;
dataGridView1.Columns[0].HeaderText = "Customer Name";
dataGridView1.Columns[1].HeaderText = "Product Name";
dataGridView1.Columns[2].HeaderText = "Category Name";
dataGridView1.Columns[6].HeaderText = "Sales Amount";
dataGridView1.Columns[7].HeaderText = "Price";
dataGridView1.Columns[8].HeaderText = "Sales Date";
dataGridView1.Columns[3].Visible = false;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[5].Visible = false;
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
dataGridView1.Columns[12].Visible = false;
dataGridView1.Columns[13].Visible = false;
}
public Response <SalesDTO> Update(SalesDTO sales)
{
try
{
Sales entity = null;
entity = Map <Sales>(sales);
_saleRepository.Delete(entity.Id);
_saleRepository.Create(entity);
_unitOfWork.SaveChanges();
sales.Id = entity.Id;
return(new Response <SalesDTO>()
{
IsSuccess = true, Message = "Güncellendi.", Result = sales
});
}
catch (Exception ex)
{
return(new Response <SalesDTO>()
{
IsSuccess = false, Exception = ex, Message = "Hata oluştu."
});
}
}
