public IHttpActionResult PutSalesTransactions(int id, SalesTransactions salesTransactions)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != salesTransactions.SalesTransactionsId)
{
return(BadRequest());
}
db.Entry(salesTransactions).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SalesTransactionsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetSalesTransactions(int id)
{
SalesTransactions salesTransactions = db.CerealSales.Find(id);
if (salesTransactions == null)
{
return(NotFound());
}
return(Ok(salesTransactions));
}
public void WriteReports_WriteMonthlySalesReport_Returns_True_When_Transactions_Present_File_Written()
{
//Arrange
string outputPath = @"C:\temp\testresults.txt";
SalesTransactions st = new SalesTransactions();
List<SalesTransactions> listOfSt = new List<SalesTransactions>();
listOfSt.Add(st);
//Act
var result = writeReports.WriteMonthlySalesReport(listOfSt, outputPath);
//Assert
Assert.True(result);
}
public IHttpActionResult PostSalesTransactions(SalesTransactions salesTransactions)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CerealSales.Add(salesTransactions);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = salesTransactions.SalesTransactionsId }, salesTransactions));
}
public IHttpActionResult DeleteSalesTransactions(int id)
{
SalesTransactions salesTransactions = db.CerealSales.Find(id);
if (salesTransactions == null)
{
return(NotFound());
}
db.CerealSales.Remove(salesTransactions);
db.SaveChanges();
return(Ok(salesTransactions));
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataRow drNew;
/****************************sales transaction *****************************/
SalesTransactions clsSalesTransactions = new SalesTransactions();
SalesTransactionDetails clsDetails = clsSalesTransactions.Details(txtTransactionNo.Text, txtTerminalNo.Text, int.Parse(cboBranch.SelectedItem.Value));
clsSalesTransactions.CommitAndDispose();
if (clsDetails.isExist == true)
{
drNew = rptds.Transactions.NewRow();
drNew["BranchCode"] = clsDetails.BranchCode;
drNew["TransactionID"] = clsDetails.TransactionID;
drNew["TransactionNo"] = clsDetails.TransactionNo;
drNew["CustomerName"] = clsDetails.CustomerName;
drNew["CashierName"] = clsDetails.CashierName;
drNew["TerminalNo"] = clsDetails.TerminalNo;
drNew["TransactionDate"] = clsDetails.TransactionDate;
drNew["DateSuspended"] = clsDetails.DateSuspended.ToString();
drNew["DateResumed"] = clsDetails.DateResumed;
drNew["TransactionStatus"] = clsDetails.TransactionStatus;
drNew["SubTotal"] = clsDetails.SubTotal;
drNew["ItemsDiscount"] = clsDetails.ItemsDiscount;
drNew["Discount"] = clsDetails.Discount;
drNew["VAT"] = clsDetails.VAT;
drNew["VatableAmount"] = clsDetails.VATableAmount;
drNew["LocalTax"] = clsDetails.LocalTax;
drNew["AmountPaid"] = clsDetails.AmountPaid;
drNew["CashPayment"] = clsDetails.CashPayment;
drNew["ChequePayment"] = clsDetails.ChequePayment;
drNew["CreditCardPayment"] = clsDetails.CreditCardPayment;
drNew["BalanceAmount"] = clsDetails.BalanceAmount;
drNew["ChangeAmount"] = clsDetails.ChangeAmount;
drNew["DateClosed"] = clsDetails.DateClosed;
drNew["PaymentType"] = clsDetails.PaymentType.ToString("d");
drNew["ItemsDiscount"] = clsDetails.ItemsDiscount;
drNew["Charge"] = clsDetails.Charge;
drNew["CreditPayment"] = clsDetails.CreditPayment;
drNew["CreatedByName"] = clsDetails.CreatedByName;
rptds.Transactions.Rows.Add(drNew);
/****************************sales transaction items*****************************/
SalesTransactionItems clsSalesTransactionItems = new SalesTransactionItems();
System.Data.DataTable dt = clsSalesTransactionItems.List(clsDetails.TransactionID, clsDetails.TransactionDate, "TransactionItemsID", SortOption.Ascending);
clsSalesTransactionItems.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
drNew = rptds.TransactionItems.NewRow();
foreach (DataColumn dc in rptds.TransactionItems.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.TransactionItems.Rows.Add(drNew);
}
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DataTable dt;
switch (cboReportType.SelectedValue)
{
case ReportTypes.CustomerCredit:
#region Customer Credit
Customer clsCustomer = new Customer();
dt = clsCustomer.CustomersDataTable(cboContactName.SelectedItem.Text);
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerDetails.NewRow();
foreach (DataColumn dc in rptds.CustomerDetails.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CustomerDetails.Rows.Add(drNew);
}
SalesTransactions clsSalesTransactions = new SalesTransactions(clsCustomer.Connection, clsCustomer.Transaction);
dt = clsSalesTransactions.ListForPaymentDataTable(Convert.ToInt64(cboContactName.SelectedItem.Value));
clsCustomer.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CustomerCredit.NewRow();
foreach (DataColumn dc in rptds.CustomerCredit.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CustomerCredit.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.CustomerCreditListWCredit:
#region Customers List With Credit
Contacts clsContact = new Contacts();
dt = clsContact.CustomerAdvanceSearch(null, cboContactName.SelectedItem.Text, cboCustomerGroup.SelectedItem.Value, true, "ContactID", SortOption.Ascending);
clsContact.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Contacts.NewRow();
foreach (DataColumn dc in rptds.Contacts.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Contacts.Rows.Add(drNew);
}
break;
#endregion
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartTransactionDate = DateTime.MinValue;
try
{ StartTransactionDate = Convert.ToDateTime(txtStartTransactionDate.Text + " " + txtStartTime.Text); }
catch { }
DateTime EndTransactionDate = DateTime.MinValue;
try
{ EndTransactionDate = Convert.ToDateTime(txtEndTransactionDate.Text + " " + txtEndTime.Text); }
catch { }
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
//SalesTransactionItems clsSalesTransactionItems;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
bool boWithTrustFund = true;
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.MANAGEMENT_PerBranch:
case ReportTypes.MANAGEMENT_PerBranchPerMonth:
case ReportTypes.MANAGEMENT_PerBranchPerMonthWithCovers:
case ReportTypes.MANAGEMENT_PerBranchPerDay:
case ReportTypes.MANAGEMENT_PerCustomerGroupPerDay:
#region Daily, Weekely, Monthly Sales Transaction
clsSalesTransactions = new SalesTransactions();
//dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionDate", System.Data.SqlClient.SortOrder.Ascending);
dt = clsSalesTransactions.ListAsDataTable(clsSearchKey, boWithTrustFund, "TransactionDate", SortOption.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
string strProductGroup = cboProductGroup.SelectedItem.Text == Constants.ALL ? string.Empty : cboProductGroup.SelectedItem.Text;
string TransactionNo = txtTransactionNo.Text;
string CustomerGroupName = cboContactGroupName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactGroupName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactGroupName.SelectedItem.Text;
string CustomerName = cboContactName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboContactName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboContactName.SelectedItem.Text;
string AgentName = cboAgent.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboAgent.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboAgent.SelectedItem.Text;
string CashierName = cboCashierName.SelectedItem.Text.Substring(0, 3).Trim() == Constants.ALL ? cboCashierName.SelectedItem.Text.Replace("ALL", "").Replace("LIKE", "").Trim() : cboCashierName.SelectedItem.Text;
string TerminalNo = cboTerminalNo.SelectedItem.Text == Constants.ALL ? string.Empty : cboTerminalNo.SelectedItem.Text;
DateTime StartTransactionDate = DateTime.MinValue;
StartTransactionDate = DateTime.TryParse(txtStartTransactionDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.MinValue;
EndTransactionDate = DateTime.TryParse(txtEndTransactionDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
TransactionStatus Status = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), cboTransactionStatus.SelectedItem.Value);
PaymentTypes PaymentType = (PaymentTypes)Enum.Parse(typeof(PaymentTypes), cboPaymentType.SelectedItem.Value);
DataTable dt = new DataTable();
ReportDataset rptds = new ReportDataset();
SalesTransactions clsSalesTransactions;
SalesTransactionItems clsSalesTransactionItems;
SalesTransactionsColumns clsSalesTransactionsColumns = new SalesTransactionsColumns();
#region clsSalesTransactionsColumns
clsSalesTransactionsColumns.BranchCode = true;
clsSalesTransactionsColumns.TransactionNo = true;
clsSalesTransactionsColumns.CustomerName = true;
clsSalesTransactionsColumns.CustomerGroupName = true;
clsSalesTransactionsColumns.CashierName = true;
clsSalesTransactionsColumns.TerminalNo = true;
clsSalesTransactionsColumns.TransactionDate = true;
clsSalesTransactionsColumns.DateSuspended = true;
clsSalesTransactionsColumns.DateResumed = true;
clsSalesTransactionsColumns.TransactionStatus = true;
clsSalesTransactionsColumns.SubTotal = true;
clsSalesTransactionsColumns.Discount = true;
clsSalesTransactionsColumns.VAT = true;
clsSalesTransactionsColumns.VATableAmount = true;
clsSalesTransactionsColumns.LocalTax = true;
clsSalesTransactionsColumns.AmountPaid = true;
clsSalesTransactionsColumns.CashPayment = true;
clsSalesTransactionsColumns.ChequePayment = true;
clsSalesTransactionsColumns.CreditCardPayment = true;
clsSalesTransactionsColumns.BalanceAmount = true;
clsSalesTransactionsColumns.ChangeAmount = true;
clsSalesTransactionsColumns.DateClosed = true;
clsSalesTransactionsColumns.PaymentType = true;
clsSalesTransactionsColumns.ItemsDiscount = true;
clsSalesTransactionsColumns.Charge = true;
clsSalesTransactionsColumns.CreditPayment = true;
clsSalesTransactionsColumns.CreatedByName = true;
clsSalesTransactionsColumns.AgentName = true;
clsSalesTransactionsColumns.PaxNo = true;
#endregion
SalesTransactionDetails clsSearchKey = new SalesTransactionDetails();
clsSearchKey = new SalesTransactionDetails();
clsSearchKey.TransactionNo = TransactionNo;
clsSearchKey.CustomerGroupName = CustomerGroupName;
clsSearchKey.CustomerName = CustomerName;
clsSearchKey.CashierName = CashierName;
clsSearchKey.TerminalNo = TerminalNo;
clsSearchKey.BranchID = int.Parse(cboBranch.SelectedItem.Value);
clsSearchKey.TransactionDateFrom = StartTransactionDate;
clsSearchKey.TransactionDateTo = EndTransactionDate;
clsSearchKey.TransactionStatus = Status;
clsSearchKey.PaymentType = PaymentType;
clsSearchKey.AgentName = AgentName;
clsSearchKey.isConsignmentSearch = cboConsignment.SelectedItem.Value;
if (clsSearchKey.isConsignmentSearch != "-1")
{
clsSearchKey.isConsignment = bool.Parse(cboConsignment.SelectedItem.Value);
}
string strReportType = cboReportType.SelectedValue;
switch (strReportType)
{
case ReportTypes.ANALYTICS_All:
case ReportTypes.ANALYTICS_All_Covers:
#region Daily, Weekely, Monthly Sales Transaction
clsSalesTransactions = new SalesTransactions();
dt = clsSalesTransactions.List(clsSalesTransactionsColumns, clsSearchKey, System.Data.SqlClient.SortOrder.Ascending, 0, "TransactionDate", System.Data.SqlClient.SortOrder.Ascending);
clsSalesTransactions.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Transactions.NewRow();
foreach (DataColumn dc in rptds.Transactions.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.Transactions.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ANALYTICS_ItemsForPOBasedOnSales:
#region Items For PO Based On Sales
SaleperItemFilterType enumSaleperItemFilterType = SaleperItemFilterType.ShowBothPositiveAndNegative;
if (rdoShowPositiveOnly.Checked)
{
enumSaleperItemFilterType = SaleperItemFilterType.ShowPositiveOnly;
}
if (rdoShowNegativeOnly.Checked)
{
enumSaleperItemFilterType = SaleperItemFilterType.ShowNegativeOnly;
}
clsSalesTransactionItems = new SalesTransactionItems();
//if (cboProductGroup.Text == Constants.ALL)
// dt = clsSalesTransactionItems.SalesPerItem(TransactionNo + "%", CustomerName + "%", CashierName + "%",
// TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
//else
// dt = clsSalesTransactionItems.SalesPerItemByGroup(strProductGroup + "%", TransactionNo + "%", CustomerName + "%", CashierName + "%",
// TerminalNo + "%", StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
if (cboProductGroup.Text == Constants.ALL)
{
dt = clsSalesTransactionItems.SalesPerItem(TransactionNo, CustomerName, CashierName, TerminalNo, StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
}
else
{
dt = clsSalesTransactionItems.SalesPerItemByGroupProc(strProductGroup, TransactionNo, CustomerName, CashierName, TerminalNo, StartTransactionDate, EndTransactionDate, Status, PaymentType, enumSaleperItemFilterType);
}
clsSalesTransactionItems.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.SalesTransactionPerItem.NewRow();
foreach (DataColumn dc in rptds.SalesTransactionPerItem.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.SalesTransactionPerItem.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
