public IActionResult AddSalesOrder(SalesOrderDTO salesOrder)
{
string username = this.HttpContext.Session.GetString(SessionConstant.UserNameSession);
if (string.IsNullOrEmpty(username))
{
return(RedirectToAction("Login", "Account"));
}
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var discount = Convert.ToDecimal(salesOrder.Discount);
var total = Convert.ToDecimal(salesOrder.Total);
var amountDue = Convert.ToDecimal(salesOrder.AmountDue);
var tendered = Convert.ToDecimal(salesOrder.Tendered);
var change = Convert.ToDecimal(salesOrder.Change);
string errorMessage = "";
this._salesTranService.AddSalesOrder(
salesOrder.CustomerId,
userId,
total,
discount,
amountDue,
amountDue,
tendered,
change,
out errorMessage);
if (errorMessage != "")
{
TempData["Fail"] = errorMessage;
return(RedirectToAction("Index", "SalesTransaction", new { customerId = salesOrder.CustomerId }));
}
return(RedirectToAction("PrintReceipt", "SalesTransaction", new { customerId = salesOrder.CustomerId }));
}
public List <SalesOrderDTO> GetListOfAllSalesOrders(string SqlQuery)
{
salesOrderList = new List <SalesOrderDTO>();
//Get the records from database
datarows = GetRecords.GetRecordsFromDatabase(connection, command, dataAdapter, jenkinsHandle(this.SwitchEnvironment27.pEnvironment, SqlQuery, jenkinsDataSource));
foreach (DataRow dataRow in datarows)
{
salesOrder = new SalesOrderDTO();
rowObject = dataRow.ItemArray;
salesOrder.sale_key = rowObject[0].ToString();
salesOrder.Cust_Key = rowObject[1].ToString();
salesOrder.order_Date = rowObject[2].ToString();
salesOrder.Order_Code = rowObject[3].ToString();
salesOrder.sale_Acct = rowObject[4].ToString();
salesOrder.sale_Id = rowObject[5].ToString();
salesOrder.job_Name = rowObject[6].ToString();
salesOrder.bmi_bud_cust_type = rowObject[7].ToString();
salesOrder.total_amount = rowObject[8].ToString();
salesOrder.Bid_Expire_Date = rowObject[9].ToString();
salesOrder.srcSysCode = rowObject[10].ToString();
salesOrder.custPoNum = rowObject[11].ToString();
salesOrder.created_By = rowObject[12].ToString();
salesOrder.Company_Name = rowObject[13].ToString();
salesOrder.user_Email = rowObject[14].ToString();
salesOrderList.Add(salesOrder);
}
return(salesOrderList);
}
private void ViewOrderInfo()
{
salesOrder = SalesOrderDataAccess.GetSalesOrderById(orderId);
if (salesOrder != null)
{
cmbCustomer.Text = keyValues[salesOrder.Customer].ToString();
txtDescription.Text = salesOrder.Description;
txtPrice.Text = string.Format("{0: 0.00}", salesOrder.Price).Trim();
txtDiscount.Text = string.Format("{0: 0.00}", salesOrder.Discount * 100).Trim();
dateSalesOrder.Value = salesOrder.SalesOrderDate.Date;
chkPaid.Checked = salesOrder.IsPaid;
if (chkPaid.Checked && salesOrder.PaidDate != null)
{
datePaid.Value = salesOrder.PaidDate.Value;
}
else
{
datePaid.Format = DateTimePickerFormat.Custom;
datePaid.CustomFormat = " ";
}
setPayType(salesOrder.PayType);
setStockStatus(salesOrder.SalesStatus);
}
}
private int AddUpdateOrder()
{
var checkedSalesStatus = grpSalesStatus.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked);
int stockStatus = (int)(SalesStatus)Enum.Parse(typeof(SalesStatus), checkedSalesStatus.Text);
var checkedPayType = grpPayType.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked);
int payType = (int)(PayType)Enum.Parse(typeof(PayType), checkedPayType.Text);
if (salesOrder != null && salesOrder.Id > 0)
{
salesOrder.Id = orderId;
salesOrder.Customer = cmbCustomer.SelectedIndex + 1;
salesOrder.Description = txtDescription.Text;
salesOrder.Price = Convert.ToDecimal(txtPrice.Text);
salesOrder.Discount = Convert.ToDecimal(txtDiscount.Text);
salesOrder.SalesOrderDate = dateSalesOrder.Value;
salesOrder.IsPaid = chkPaid.Checked;
salesOrder.UpdatedBy = userId;
salesOrder.PayType = payType;
salesOrder.SalesStatus = stockStatus;
if (chkPaid.Checked)
{
salesOrder.PaidDate = datePaid.Value;
}
else
{
salesOrder.PaidDate = null;
}
return(SalesOrderDataAccess.UpdateSalesOrder(salesOrder));
}
else
{
var salesOrder = new SalesOrderDTO()
{
Description = txtDescription.Text,
Customer = cmbCustomer.SelectedIndex + 1,
Price = Convert.ToDecimal(txtPrice.Text),
Discount = Convert.ToDecimal(txtDiscount.Text),
SalesOrderDate = dateSalesOrder.Value,
IsPaid = chkPaid.Checked,
PayType = payType,
SalesStatus = stockStatus,
CreatedBy = userId
};
if (chkPaid.Checked)
{
salesOrder.PaidDate = datePaid.Value;
}
else
{
salesOrder.PaidDate = null;
}
return(SalesOrderDataAccess.AddSalesOrder(salesOrder));
}
}
public int SaveSalesOrderHeader(SalesOrderDTO salesOrder)
{
ProductDetails productDetails = GetListOfProductsForThisOrder(salesOrder.ProductWithQuantity);
List <CustomerAddress> lstCustomerAddress = _customerAddressRepository.GetMany(x => x.CustomerID == salesOrder.CustomerID).ToList();
var objSalesOrder = new SalesOrderHeader();
objSalesOrder.RevisionNumber = 2;
objSalesOrder.OrderDate = DateTime.Now;
objSalesOrder.DueDate = objSalesOrder.OrderDate.AddDays(12);
objSalesOrder.ShipDate = objSalesOrder.OrderDate.AddDays(7);
objSalesOrder.Status = 5;
objSalesOrder.PurchaseOrderNumber = "PO" + salesOrder.CustomerID + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Hour;
objSalesOrder.OnlineOrderFlag = true;
objSalesOrder.CustomerID = salesOrder.CustomerID;
foreach (CustomerAddress customerAddress in lstCustomerAddress)
{
if (customerAddress.AddressType.Equals("Shipping"))
{
objSalesOrder.ShipToAddressID = customerAddress.AddressID;
}
else
{
objSalesOrder.BillToAddressID = customerAddress.AddressID;
}
}
objSalesOrder.ShipMethod = "CARGO TRANSPORT 5";
objSalesOrder.SubTotal = productDetails.totalPrice;
objSalesOrder.TaxAmt = decimal.Multiply(productDetails.totalPrice, 0.08M);
objSalesOrder.Freight = decimal.Multiply(objSalesOrder.TaxAmt, 0.30M);
objSalesOrder.Comment = "Online Order";
objSalesOrder.rowguid = Guid.NewGuid();
objSalesOrder.ModifiedDate = DateTime.Now;
_salesOrderHeaderRepository.Add(objSalesOrder);
_unitOfWork.Commit();
SaveSalesOrderDetails(productDetails, objSalesOrder.SalesOrderID);
return(objSalesOrder.SalesOrderID);
}
public int PostSalesOrderHeader(SalesOrderDTO salesOrder)
{
loggerService.Logger().Info("Calling with parameter as : salesOrder: " + salesOrder);
return(_saleService.SaveSalesOrderHeader(salesOrder));
}
