void form_SalesUpdated(object sender, EventArgs e)
{
SaleFilterModel filter = ComposeSearch();
LoadSales(filter);
dataGridView1.ClearSelection();
if (selectedId == 0)
{
salesViewBindingSource.Position = salesViewBindingSource.Count - 1;
}
else
{
SalesView item = ((SortableBindingList <SalesView>)salesViewBindingSource.DataSource)
.FirstOrDefault(a => a.Id == selectedId);
int index = salesViewBindingSource.IndexOf(item);
salesViewBindingSource.Position = index;
if (index != -1)
{
dataGridView1.Rows[index].Selected = true;
}
}
}
public IActionResult Edit(int id, [Bind("SalesId,ManagerId,ClientId,ProductId,SaleDate,SaleCost")] SalesView salesView)
{
if (id != salesView.SalesId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_salesViewRepository.Update(salesView);
}
catch (DbUpdateConcurrencyException)
{
if (!SalesViewExists(salesView.SalesId))
{
return(NotFound());
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_clientViewRepository.GetAll(), "ClientId", "ClientId");
ViewData["ManagerId"] = new SelectList(_managerViewRepository.GetAll(), "ManagerId", "ManagerId");
ViewData["ProductId"] = new SelectList(_productViewRepository.GetAll(), "ProductId", "ProductId");
return(View(salesView));
}
public List <SalesView> DisplaySalesInfo()
{
List <SalesView> salesViews = new List <SalesView>();
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string commandString = @"SELECT * FROM SalesView";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
SalesView salesView = new SalesView();
salesView.SL = sqlDataReader["SL"].ToString();
salesView.Id = Convert.ToInt32(sqlDataReader["Id"].ToString());
salesView.Date = sqlDataReader["Date"].ToString();
salesView.Code = sqlDataReader["Code"].ToString();
salesView.Category = sqlDataReader["Category"].ToString();
salesView.Product = sqlDataReader["Product"].ToString();
salesView.SoldQty = Convert.ToDouble(sqlDataReader["SoldQty"].ToString());
salesView.MRP = Convert.ToDouble(sqlDataReader["MRP"].ToString());
salesView.TotalMRP = Convert.ToDouble(sqlDataReader["TotalMRP"].ToString());
salesView.CP = Convert.ToDouble(sqlDataReader["CP"].ToString());
salesView.Profit = Convert.ToDouble(sqlDataReader["Profit"].ToString());
salesViews.Add(salesView);
}
sqlConnection.Close();
return(salesViews);
}
public async Task <JsonResult> Edit(int id)
{
Sales sales = this._salesDao.GetObjectById(id);
SalesView salesView = AppUtils.Mapper <SalesView, Sales>(sales);
return(Json(salesView));
}
public void Update(SalesView salesView)
{
using var salesRepository = new SalesRepository();
var sales = _mapper.Map <Sales>(salesView);
salesRepository.Update(sales);
}
public List <SalesView> SearchSalesRecord(string startDate, string endDate)
{
List <SalesView> salesViews = new List <SalesView>();
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
string commandString = @"SELECT * FROM SalesView WHERE Date BETWEEN '" + startDate + "' AND '" + endDate + "'";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
SalesView salesView = new SalesView();
salesView.SL = sqlDataReader["SL"].ToString();
salesView.Id = Convert.ToInt32(sqlDataReader["Id"].ToString());
salesView.Date = sqlDataReader["Date"].ToString();
salesView.Code = sqlDataReader["Code"].ToString();
salesView.Category = sqlDataReader["Category"].ToString();
salesView.Product = sqlDataReader["Product"].ToString();
salesView.SoldQty = Convert.ToDouble(sqlDataReader["SoldQty"].ToString());
salesView.MRP = Convert.ToDouble(sqlDataReader["MRP"].ToString());
salesView.TotalMRP = Convert.ToDouble(sqlDataReader["TotalMRP"].ToString());
salesView.CP = Convert.ToDouble(sqlDataReader["CP"].ToString());
salesView.Profit = Convert.ToDouble(sqlDataReader["Profit"].ToString());
salesViews.Add(salesView);
}
sqlConnection.Close();
return(salesViews);
}
public void Add(SalesView salesView)
{
using var salesRepository = new SalesRepository();
var sales = _mapper.Map <Sales>(salesView);
salesRepository.AddSale(sales);
}
public ActionResult Add()
{
SalesView salesView = new SalesView();
InitialSalesView(salesView);
return(View(salesView));
}
private void MoveToSales()
{
var sales = new SalesView();
sales.Show();
CloseAction();
}
public ActionResult Show(string search)
{
SalesView aSalesView = new SalesView();
aSalesView.SalesInfos = _salesManager.Search(search);
ViewBag.product = null;
return(View(aSalesView));
}
private void ViewSalesButton_Click(object sender, EventArgs e)
{
this.Hide();
SalesView salesHistory = new SalesView();
//salesView salesHistory = new salesView();
salesHistory.ShowDialog();
}
public IActionResult Create([Bind("SalesId,ManagerId,ClientId,ProductId,SaleDate,SaleCost")] SalesView salesView)
{
if (ModelState.IsValid)
{
_salesViewRepository.Add(salesView);
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_clientViewRepository.GetAll(), "ClientId", "ClientId");
ViewData["ManagerId"] = new SelectList(_managerViewRepository.GetAll(), "ManagerId", "ManagerId");
ViewData["ProductId"] = new SelectList(_productViewRepository.GetAll(), "ProductId", "ProductId");
return(View(salesView));
}
public MainWindow()
{
InitializeComponent();
shView = new ScheduleView();
toursView = new ToursView();
salesView = new SalesView();
guidesView = new GuidesView();
DataContext = shView;
//Height = SystemParameters.PrimaryScreenHeight * 0.75;
//Width = SystemParameters.PrimaryScreenWidth * 0.75;
}
private void InitialSalesView(SalesView salesView)
{
salesView.SalesInfo = new SalesInfo();
salesView.SalesInfo.Date = DateTime.Today;
salesView.CustomerSelectListItems = _customerManager.GetAll()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}
).ToList();
salesView.CategorySelectListItems = _categoryManager.GetAll()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(),
Text = c.Name
}
).ToList();
}
static void Main(string[] args)
{
ProductsView productsView = new ProductsView();
productsView.Menu();
UsersController u = new UsersController();
UserClientsDto uc = u.GetUserWithClientsCreated(1);
Console.WriteLine(uc.ToString());
SalesView salesView = new SalesView();
salesView.Sale();
salesView.Search();
Console.WriteLine("Press ENTER to Continue...");
Console.Read();
}
public QueryResultView <Sales> Query(SalesView queryObject)
{
QueryResultView <Sales> results = new QueryResultView <Sales>();
IQueryable <Sales> sales = null;
if (queryObject != null)
{
sales = this._context.Sales.Where(s => s.DateSold.Contains(queryObject.DateSoldQry) &&
s.Customer.Id == (queryObject.CustomerId == 0?s.Customer.Id : queryObject.CustomerId) &&
s.Product.Id == (queryObject.ProductId == 0?s.Product.Id:queryObject.ProductId) &&
s.Store.Id == (queryObject.StoreId == 0?s.Store.Id:queryObject.StoreId)).Include(x => x.Customer).Include(x => x.Product).Include(x => x.Store);
}
else
{
sales = this._context.Sales;
}
results.TotalData = sales.Count();
results.Results = sales.Skip(queryObject.SkipData).Take(queryObject.DataPerPage).ToList();
return(results);
}
public void LogOut()
{
if (!IsAdmin(CurrentUser))
{
SetUserStatus(CurrentUser, "Offline");
}
if (NotSaved)
{
if (MessageBoxEx.Show("Save your work or not?", "Save", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DatabaseSave();
}
}
AccountsView.ResetDataGridView();
SalesView.ResetDataGridView();
ManagerNameLabel.Text = "JJETSystems";
StatusLabel.Text = DateTime.Now.ToLongDateString();
AccountPanel.VisibleDock(true, RegisterPanel);
RegisterButton.Text = "Register";
}
public async Task <JsonResult> Add([FromBody] SalesView salesView)
{
bool isSuccess = false;
ActionMessage rMessage = new ActionMessage()
{
Message = "Add sales success!",
Result = true
};
int customerId = salesView.CustomerId;
if (customerId > 0)
{
Customer customer = _customerDao.GetObjectById(customerId);
salesView.Customer = customer;
}
int productId = salesView.ProductId;
if (productId > 0)
{
Product product = _productDao.GetObjectById(productId);
salesView.Product = product;
}
int storeId = salesView.StoreId;
if (storeId > 0)
{
Store store = _storeDao.GetObjectById(storeId);
salesView.Store = store;
}
//Sales sales = salesView;
isSuccess = this._salesDao.Add(salesView);
if (!isSuccess)
{
rMessage.Message = "Add sales fail!";
rMessage.Result = false;
}
return(Json(rMessage));
}
public ActionResult Add(SalesView salesView)
{
//CustomerView _customerView = new CustomerView();
string message = null;
ViewBag.ActionName = "Add";
ViewBag.ButtonName = "Save";
SalesInfo salesInfo = salesView.SalesInfo;
int LoyaltyPoint = salesView.Customer.LoyaltyPoint - salesView.Discount + (int)(salesView.GrantTotal / 1000);
int Id = salesView.SalesInfo.CustomerId;
Customer customer = new Customer();
customer = _customerManager.GetById(Id);
customer.LoyaltyPoint = LoyaltyPoint;
_customerManager.Update(customer);
message = _salesManager.Insert(salesInfo) ? "Saved" : "Does not save";
ViewBag.Message = message;
SalesView aSalesView = new SalesView();
InitialSalesView(aSalesView);
return(View(aSalesView));
}
protected void SaleFormView_ItemDeleted(object sender, FormViewDeletedEventArgs e)
{
SalesView.DataBind();
}
public void CreateView()
{
this.view = new SalesView();
}
public void SetView(IView view)
{
this.view = (SalesView)view;
}
public JsonResult Query(SalesView salesView)
{
QueryResultView <Sales> saless = this._salesDao.Query(salesView);
return(Json(saless));
}
private void btnPrint_ItemClick(object sender, ItemClickEventArgs e)
{
SalesView.ShowPrintPreview();
}
private void btnSalesInvoicePrint_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
SalesView.ShowPrintPreview();
}
