public ActionResult ClientesEdit(int?ClientID)
{
ClienteViewModel model = new ClienteViewModel();
context = new DALContext();
if (ClientID > 0)
{
model.Customer = context.Customers.Find(p => p.Id == ClientID);
model.Customer.Document = model.Customer.Document.Replace(".", "").Replace("-", "").Replace("/", "");
model.Customer.ZipCode = model.Customer.ZipCode.Replace("-", "");
model.Cities = context.Cities.Filter(p => p.StateId == model.Customer.AddressStateId).OrderBy(p => p.Name).ToList();
model.Cities.Insert(0, new City()
{
Id = 0, Name = "SELECIONE..."
});
model.Vendedores = context.VendorsCustomer.Filter(p => p.CustomerID == ClientID).Select(p => p.Vendor).ToList();
model.Vendedores.Insert(0, new Vendor()
{
Id = 0, Name = "SELECIONE..."
});
}
return(View(model));
}
public ActionResult ContatoSave(Contact model)
{
context = new DALContext();
try
{
model.RegisterDate = DateTime.Now;
model.LastUpdate = DateTime.Now;
if (ModelState.IsValid)
{
if (model.VendorID == null)
{
model.VendorID = 1;
}
if (model.Id > 0)
{
context.Contacts.Update(model);
}
else
{
context.Contacts.Create(model);
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
ViewBag.Message = "Contato cadastrado com sucesso.";
return(RedirectToAction("Contatos"));
}
public ActionResult VendedorSave(Vendor model)
{
context = new DALContext();
try
{
if (model.PercentCommission <= 0)
{
model.PercentCommission = 5;
}
if (model.Id > 0)
{
context.Vendors.Update(model);
}
else
{
context.Vendors.Create(model);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
ViewBag.Message = "Vendedor cadastrado com sucesso.";
return(RedirectToAction("Vendedores"));
}
public ActionResult ClientesSave(Customer model)
{
context = new DALContext();
try
{
model.RegisterDate = DateTime.Now;
model.LastUpdate = DateTime.Now;
if (model.Id > 0)
{
context.Customers.Update(model);
}
else
{
context.Customers.Create(model);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
ViewBag.Message = "Cliente cadastrado com sucesso.";
return(RedirectToAction("Clientes"));
}
public ActionResult Recebimento()
{
context = new DALContext();
var Orders = context.PurchaseOrders.Filter(p => p.Status == "PEDIDO_PENDENTE").ToList();
return(View(Orders));
}
public ActionResult CondicaoPagamentoSave(PaymentTerm PaymentTerm)
{
context = new DALContext();
try
{
//prod.AliqICMS = 3;
//prod.CombinedProduct = false;
//prod.MinimumStockAlert = 50;
if (PaymentTerm.Id > 0)
{
context.PaymentTerms.Update(PaymentTerm);
}
else
{
context.PaymentTerms.Create(PaymentTerm);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
ViewBag.Message = "Condição de Pagamento cadastrada com sucesso.";
return(RedirectToAction("CondicaoPagamento"));
}
//public ActionResult ProdutosPendentes()
//{
// try
// {
// context = new DALContext();
// var ListaProdutosPendentes = context.Products.Filter(p => p.QuantityCurrentStock < 0).ToList();
// return View(ListaProdutosPendentes);
// }
// catch (Exception ex)
// {
// return Content(ex.Message);
// }
//}
public ActionResult ProdutosPendentes()
{
try
{
context = new DALContext();
var ListaProdutosPendenteCompra = context.Products.Filter(p => p.QuantityCurrentStock < 0).ToList();
int[] idProduto = ListaProdutosPendenteCompra.Select(p => p.Id).Distinct().ToArray();
var ListaProdutosPendentes = context.ProductProviders.Filter(p => idProduto.Contains(p.ProductID)).ToList();
var ListaProdutosCarteiraEstoque = ListaProdutosPendentes.Select(p => new ProdutoCarteiraEstoqueViewModel()
{
Product = context.Products.Find(q => q.Id == p.ProductID),
ProductProvider = p
}).ToList();
return(View("ProdutosCarteiraEstoque", ListaProdutosCarteiraEstoque));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public TestBussiness()
{
user = new User
{
UserName = "******",
Role = "Tester",
Enabled = true
};
var users = new List <User>
{
new User {
UserId = 1, UserName = "******", Role = "Description", Enabled = true
},
new User {
UserId = 2, UserName = "******", Role = "PM", Enabled = true
},
new User {
UserId = 3, UserName = "******", Role = "QA", Enabled = true
},
};
// Setup
moqIDALContext = new Mock <IDALContext>();
//moqIDALContext.Setup(db => db.Users).Verifiable();
// Assert
_IDALContext = moqIDALContext.Object;
userService = new UserService(_IDALContext);
}
public SendMailViewModel()
{
ListaEmails = new List <UserAdressBook>();
context = new DALContext();
try
{
if (string.IsNullOrEmpty(LoggerUser))
{
ListaEmails = context.AddressBooks.All().ToList();
}
else
{
ListaEmails = context.AddressBooks.All().Where(p => p.Username.ToUpper().Contains(LoggerUser)).ToList();
}
if (Order == null)
{
Order = new Order();
Order.Items = new List <OrderProduct>();
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult IncluirCliente(Model.Entities.Customer Customer)
{
try
{
context = new DALContext();
Customer.Document = Customer.Document.Replace(".", "").Replace("-", "").Replace("/", "");
context.Customers.Create(Customer);
context.SaveChanges();
var CustomerList = context.Customers.All()
.Select(p => new
{
p.Id,
p.CompanyName
})
.OrderBy(p => p.CompanyName).ToList();
var CustomerListJSON = new JavaScriptSerializer().Serialize(CustomerList);
return(Content(String.Format("{0};{1}", Customer.Id, CustomerListJSON)));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public ActionResult IncluirVendedor(Model.Entities.Vendor Vendor, int CustomerID)
{
try
{
context = new DALContext();
context.Vendors.Create(Vendor);
context.SaveChanges();
context.VendorsCustomer.Create(new VendorsCustomer()
{
CustomerID = CustomerID,
VendorID = Vendor.Id
});
context.SaveChanges();
var Customer = context.Customers.Find(p => p.Id == CustomerID);
Customer.VendorId = Vendor.Id;
context.Customers.Update(Customer);
context.SaveChanges();
return(Content(String.Format("{0}", Vendor.Id)));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public ActionResult Carteira()
{
context = new DALContext();
var Orders = context.Orders.Filter(p => p.Status == "PEDIDO - ABERTO").ToList();
var OrderProducts = new List <OrderProduct>();
Orders.ForEach(p =>
{
OrderProducts.AddRange(p.Items);
});
var CustomerList = OrderProducts.Select(p => p.Order.CustomerOrder).Distinct().ToList();
var ProductList = OrderProducts.Select(p => p.ProductItem).Distinct().ToList();
CustomerList.Insert(0, new Customer()
{
Id = 0, CompanyName = "TODOS"
});
ProductList.Insert(0, new Product()
{
Id = 0, Name = "TODOS"
});
ViewData["CustomerList"] = CustomerList;
ViewData["ProductList"] = ProductList;
return(View(OrderProducts));
}
public ActionResult CarregarModalEmail(int OrderID)
{
try
{
context = new DALContext();
List <UserAdressBook> Contatos = context.AddressBooks.Filter(p => p.Username == User.Identity.Name).ToList();
HtmlToPdf converter = new HtmlToPdf();
ViewBag.ToPDF = "1";
SelectPdf.PdfDocument doc = converter.ConvertUrl("http://control.gtwave.com.br/Invoice/InvoiceFile?InvoiceID=" + OrderID);
ViewBag.ToPDF = "0";
byte[] fileBytes = doc.Save();
string fileName = "proposta_" + OrderID.ToString() + ".pdf";
return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName));
//return Content(String.Format("Arquivo exportado.", OrderID));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
public JsonResult GetProducts(int ProductID)
{
context = new DALContext();
var objProduct = context.Products.Find(p => p.Id == ProductID);
return(Json(objProduct));
}
public ActionResult FornecedorSave(Provider model)
{
context = new DALContext();
try
{
model.RegisterDate = DateTime.Now;
model.LastUpdate = DateTime.Now;
model.PhoneCode = 13;
model.CommercialPolicy = 0;
model.Discount = 0;
if (model.Id > 0)
{
context.Providers.Update(model);
}
else
{
context.Providers.Create(model);
}
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
ViewBag.Message = "Fornecedor cadastrado com sucesso.";
return(RedirectToAction("Fornecedores"));
}
public PartialViewResult LoggedUserPartial()
{
try
{
Model.Entities.User usuario = new Model.Entities.User();
context = new DALContext();
usuario = context.Users.All().SingleOrDefault(p => p.UserName == User.Identity.Name);
if (usuario.UserName == "*****@*****.**")
{
ViewBag.NomeLogado = "Vilo";
}
else
{
ViewBag.NomeLogado = "Uriel Silva";
}
}
catch (Exception ex)
{
return(PartialView());
}
return(PartialView());
}
public JsonResult VincularFornecedorProduto(int ProviderID, int ProductID, long codigoProdutoFornecedor, string modeloFabricante)
{
try
{
context = new DALContext();
var objProductProvider = new ProductProvider()
{
ProductID = ProductID,
ProviderID = ProviderID,
Code = codigoProdutoFornecedor,
IsActive = true,
ModelProvider = modeloFabricante
};
context.ProductProviders.Create(objProductProvider);
context.SaveChanges();
return(Json(new { erro = false }));
}
catch (Exception ex)
{
return(Json(new { erro = true, msg = ex.Message }));
}
}
public ClienteViewModel()
{
if (Customer == null)
{
Customer = new Customer();
}
context = new DALContext();
Countries = context.Countries.All().OrderBy(p => p.Name).ToList();
Cities = new List <City>();
States = context.States.All().OrderBy(p => p.Name).ToList();
States.Insert(0, new State()
{
Id = 0, Name = "SELECIONE..."
});
CondicoesPagamento = context.PaymentTerms.All().ToList();
CondicoesPagamento.Insert(0, new PaymentTerm()
{
Id = 0, Description = "SELECIONE..."
});
ModolidadeTransporte = context.ShippingModes.All().ToList();
ModolidadeTransporte.Insert(0, new ShippingMode()
{
Id = 0, Name = "SELECIONE..."
});
Vendedores = context.VendorsCustomer.Filter(p => p.CustomerID == Customer.Id).Select(p => p.Vendor).ToList();
}
public ActionResult ContatosEmailSave(UserAdressBook model)
{
context = new DALContext();
try
{
if (ModelState.IsValid)
{
model.Username = User.Identity.Name;
if (model.Id > 0)
{
context.AddressBooks.Update(model);
}
else
{
context.AddressBooks.Create(model);
}
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
ViewBag.Message = "Contato cadastrado com sucesso.";
return(RedirectToAction("ContatosEmailLista"));
}
public PartialViewResult ConferenciaGetListaProdtos(int OrderID)
{
context = new DALContext();
var OrderProducts = context.PurchaseOrderItem.Filter(p => p.PurchaseOrderId == OrderID).ToList();
return(PartialView("_ConferenciaListaProdutos", OrderProducts));
}
public PartialViewResult GetOrderProducts(int OrderID)
{
context = new DALContext();
var OrderProducts = context.PurchaseOrderItem.All().Include("ProductItem").Where(p => p.PurchaseOrderId == OrderID).ToList();
return(PartialView("_ListPurchaseOrdemItem", OrderProducts));
}
public ActionResult Index()
{
context = new DALContext();
var Orders = context.PurchaseOrders.Filter(p => p.Status == "PEDIDO_ABERTO").ToList();
return(View(Orders));
}
public ActionResult Edit(int OrderID)
{
var model = new Control.UI.Models.PedidoCompraViewModel();
context = new DALContext();
PurchaseOrder retorno = new PurchaseOrder();
try
{
retorno = context.PurchaseOrders.All().Include("Items").ToList().Find(p => p.Id == OrderID);
model.PurchaseOrder = retorno;
model.PurchaseOrder.Items = retorno.Items;
foreach (var item in model.PurchaseOrder.Items)
{
item.ProductItem = new Product();
item.ProductItem = context.Products.Find(x => x.Id == item.ProductID);
}
}
catch (Exception ex)
{
throw ex;
}
return(View("Create", model));
}
public JsonResult GetCitiesByState(int StateID)
{
context = new DALContext();
var CityList = context.Cities.All().Where(p => p.StateId == StateID).OrderBy(p => p.Name).ToList();
return(Json(new { Cidades = CityList }, JsonRequestBehavior.AllowGet));
}
public ComponentsElementsController(IDALContext context)
{
_componentsElements = context.ComponentsElements;
_components = context.Components;
_elements = context.Elements;
_variants = context.Variants;
_users = context.Users;
}
public ActionResult Delete(int OrderID)
{
context = new DALContext();
context.Orders.Delete(p => p.Id == OrderID);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeletePurchaseOrderItem(int PurchaseOrderItemID)
{
context = new DALContext();
context.PurchaseOrderItem.Delete(p => p.Id == PurchaseOrderItemID);
context.SaveChanges();
return(Content("Item Excluído com Sucesso!"));
}
public ActionResult Delete(int InvoiceID)
{
context = new DALContext();
context.Invoices.Delete(p => p.Id == InvoiceID);
context.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult OrdersCustomer(int ClientID)
{
context = new DALContext();
var Orders = context.Orders.Filter(p => p.CustomerID == ClientID).ToList();
return(View("Index", Orders));
}
public ActionResult DeleteOrderProduct(int OrderProductID)
{
context = new DALContext();
context.OrdersProducts.Delete(p => p.Id == OrderProductID);
context.SaveChanges();
return(Content("Item Excluído com Sucesso!"));
}
public FeedsService(IDALContext dalContext)
{
if (dalContext == null)
{
throw new ArgumentNullException("dalContext");
}
_dalContext = dalContext;
}
public TestBussiness()
{
user = new User
{
UserName = "******",
Role = "Tester",
Enabled = true
};
var users = new List<User>
{
new User{UserId = 1, UserName = "******", Role = "Description",Enabled = true},
new User{UserId = 2, UserName = "******", Role = "PM",Enabled = true},
new User{UserId = 3, UserName = "******", Role = "QA",Enabled = true},
};
// Setup
moqIDALContext = new Mock<IDALContext>();
//moqIDALContext.Setup(db => db.Users).Verifiable();
// Assert
_IDALContext = moqIDALContext.Object;
userService = new UserService(_IDALContext);
}
public DocumentService(IDALContext context)
{
_context = context;
}
public UserService(IDALContext dal)
{
context = dal;
}
public QueryService(IDALContext dal)
{
context = dal;
}
public BLLService()
{
_context = new DALContext();
}
public UserService(IDALContext context)
{
_context = context;
}
public ClassService(IDALContext contextParam)
{
context = contextParam;
}
public TaskController(IDALContext context)
{
_tasks = context.Tasks;
_users = context.Users;
}
public ProfileService(IDALContext context)
{
_context = context;
}
public void TestInitialize()
{
_dalContextMock = _mockRepository.StrictMock<IDALContext>();
_devicesRepository = _mockRepository.StrictMock<IDevicesRepository>();
}
public BoardService(IDALContext contextParam)
{
context = contextParam;
}
public StatusService(IDALContext dbContext)
{
_Dbcontext = dbContext;
}
public StatusService()
{
_Dbcontext = new DALContext();
}
public void Initialize()
{
_dalContextMock = _mockRepository.StrictMock<IDALContext>();
_messagesRepositoryMock = _mockRepository.StrictMock<IMessagesRepository>();
_devicesRepositoryMock = _mockRepository.StrictMock<IDevicesRepository>();
}
public void Initialise()
{
_dalContext = _mockRepository.StrictMock<IDALContext>();
_usersRepository = _mockRepository.StrictMock<IUsersRepository>();
_rolesRepository = _mockRepository.StrictMock<IRolesRepository>();
}
public PkgOrderService(IDALContext context)
{
this.context = context;
}
public UserService(IDALContext dalContext)
{
this.dalContext = dalContext;
}
public CRMService(IDALContext context)
{
this.context = context;
}
public RoleService(IDALContext context)
{
_context = context;
}
public ProjectService(IDALContext dalContext)
{
this.dalContext = dalContext;
}