public static List <TransactionModel> GetTransactions(TransactionsModel filters)
{
using (var dc = new TurismoDataContext())
{
if (UserDependsOf(filters.UserId, SessionData.UserId))
{
if (dc.Clientes.Count(c => c.IDCLIENTE == filters.UserId) == 1)
{
return(dc.Transaccions
.Where(t => t.Usuario.IDCLIENTE == filters.UserId &&
(filters.Status == -9999 || t.ESTADORESERVA == filters.Status) &&
((filters.LodgingId ?? Guid.Empty) == Guid.Empty || t.IDALOJ == filters.LodgingId) &&
((filters.CityId ?? Guid.Empty) == Guid.Empty || t.Alojamiento.IDCIUDAD == filters.CityId) &&
((filters.ProvinceId ?? Guid.Empty) == Guid.Empty || t.Alojamiento.Ciudad.IDPROVINCIA == filters.ProvinceId))
.OrderByDescending(t => t.CODIGO_RESERVA)
.Select(t => MapTransaction(t)).ToList());
}
else
{
return(dc.Transaccions
.Where(t => t.IDUSUARIO == filters.UserId &&
(filters.Status == -9999 || t.ESTADORESERVA == filters.Status) &&
((filters.LodgingId ?? Guid.Empty) == Guid.Empty || t.IDALOJ == filters.LodgingId) &&
((filters.CityId ?? Guid.Empty) == Guid.Empty || t.Alojamiento.IDCIUDAD == filters.CityId) &&
((filters.ProvinceId ?? Guid.Empty) == Guid.Empty || t.Alojamiento.Ciudad.IDPROVINCIA == filters.ProvinceId))
.OrderByDescending(t => t.CODIGO_RESERVA)
.Select(t => MapTransaction(t)).ToList());
}
}
else
{
return(new List <TransactionModel>());
}
}
}
public virtual ActionResult Index()
{
int?branchId = Session[SessionVariables.UserDetails].GetBranchIdFromSession();
int?userTypeId = Session[SessionVariables.UserDetails].GetUserTypeIdFromSession();
List <ProductDto> productList = new List <ProductDto>();
List <CustomerDto> customerList = new List <CustomerDto>();
List <SalesOrderDto> salesOrderList = new List <SalesOrderDto>();
if (!branchId.IsNull() || userTypeId == Constants.UserTypeUserId)
{
productList = _inventoryService.GetAll().Where(p => p.BranchID == branchId).OrderBy(p => p.BranchName).ToList();
customerList = _customerService.GetAll().Where(c => c.IsActive).ToList();
salesOrderList = _orderService.GetAllSalesOrder().Where(s => s.BranchID == branchId).ToList();
}
else
{
productList = _inventoryService.GetAll().OrderBy(p => p.ProductCode).ThenBy(p => p.BranchName).ToList();
customerList = _customerService.GetAll().Where(c => c.IsActive).ToList();
salesOrderList = _orderService.GetAllSalesOrder().ToList();
}
var productTotalQty = productList.Sum(p => p.Quantity);
TransactionsModel model = new TransactionsModel()
{
NumCustomers = customerList.Count,
NumQty = productList.Count,
NumTotalQty = productTotalQty,
NumSalesOrders = salesOrderList.Count
};
return(View(model));
}
public IActionResult Retiro(TransactionsModel transac)
{
if (ModelState.IsValid)
{
TransactionDomain transaction = new TransactionDomain();
transaction.idPerson = string.IsNullOrEmpty(transac.idPerson) ? "0" : transac.idPerson;
transaction.accountNumber = string.IsNullOrEmpty(transac.accountNumber) ? "0" : transac.accountNumber;
transaction.accountNumberDestination = string.IsNullOrEmpty(transac.accountNumberDestination) ? "": transac.accountNumberDestination;
transaction.value = string.IsNullOrEmpty(transac.value) ? "0": transac.value;
transaction.idOperation = string.IsNullOrEmpty(transac.idOperation) ? "0" : transac.idOperation;
var url = $"https://localhost:44372/transact";
var request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "POST";
request.ContentType = "application/json";
request.Accept = "application/json";
using (var streamWriter = new StreamWriter(request.GetRequestStream()))
{
var objJson = JsonConvert.SerializeObject(transac);
streamWriter.Write(objJson);
}
var httpResponse = (HttpWebResponse)request.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
}
}
return(View());
}
private IEnumerable GetData(int SearchRecords, string transactiontype, string status)
{
int Id = 0;
int CustomerId = Convert.ToInt32(Session["CustomerId"]);
if (User.IsInRole("Admin"))
{
CustomerId = 0;
}
status = status.Trim().ToLower();
transactiontype = transactiontype.Trim().ToLower();
List <TransactionsModel> transactionlist = new List <TransactionsModel>();
var transactions = TransactionService.UserTransactionDetails(Id, SearchRecords, CustomerId, transactiontype, status);
foreach (var trans in transactions)
{
TransactionsModel transactionmodel = new TransactionsModel();
transactionmodel.Id = trans.Id;
transactionmodel.CustomerId = trans.CustomerId;
transactionmodel.Amount = Convert.ToInt32(trans.Amount.Value);
transactionmodel.TransactionDate = trans.TransactionDate;
transactionmodel.TransactionType = trans.TransactionType;
transactionmodel.status = trans.status;
transactionmodel.Remarks = trans.Remarks;
transactionmodel.PaymentMethod = trans.PaymentMethod;
transactionlist.Add(transactionmodel);
}
return(transactionlist);
}
private void FnGetData()
{
mSelectedTransactionId = Intent.GetIntExtra("selectedTransactionId", 0);
mIsMultipay = Intent.GetBooleanExtra("isMultipay", false);
mIsMultipayPreview = Intent.GetBooleanExtra("isMultipayPreview", false);
mMultipayPreviewIdList = Intent.GetStringExtra("multipayPreviewIdList");
mSettingsDataAccess = new SettingsDataAccess();
mTransactionsDataAccess = new TransactionsDataAccess();
mTransactionItemsDataAccess = new TransactionItemsDataAccess();
mRunnersDataAccess = new RunnersDataAccess();
mCustomersDataAccess = new CustomersDataAccess();
mRunnersMultipayRecordsDataAccess = new RunnersMultipayRecordsDataAccess();
mReceiptSettings = mSettingsDataAccess.SelectTable()[0];
mSelectedTransaction = mIsMultipay ? null : mTransactionsDataAccess.SelectRecord(mSelectedTransactionId)[0];
//mSelectedMultipayRecord = mIsMultipay ? mRunnersMultipayRecordsDataAccess.SelectRecord(mSelectedTransactionId)[0] : null;
mSelectedMultipayRecord = new RunnersMultipayRecordsModel()
{
Id = 1,
CashierName = "Jepoy",
TransactionDateTime = "2020-12-14 6:45",
RunnerId = 1,
SubTotalAmount = 45884,
DiscountAmount = 0,
PaymentCashAmount = 45884,
PaymentCheckAmount = 0,
TransactionIds = "#47, #46",
StartDate = "2020-12-11 6:45",
EndDate = "2020-12-14 12:45"
};
}
public LinkedTransactions GenerateLink([FromBody] TransactionsModel request)
{
LinkedTransactions response = new LinkedTransactions()
{
VinculosEgreso = new List <Link>(),
VinculosIngreso = new List <Link>()
};
var pendingEgresses = request.Egresos;
var pendingEntries = request.Ingresos;
foreach (var criterio in request.Criterio)
{
var generator = LinkAlgorithmSelectorService.GetLinkingGenerator(criterio);
var linkProcessed = generator.LinkingTransactions(pendingEntries, pendingEgresses);
if (MappingHelper.IsEgressOrder[criterio])
{
response.VinculosEgreso.AddRange(linkProcessed?.Links);
}
else
{
response.VinculosIngreso.AddRange(linkProcessed?.Links);
}
pendingEgresses = linkProcessed?.PendingEgresses;
pendingEntries = linkProcessed?.PendingEntries;
}
return(response);
}
public ActionResult Adjust(int id, decimal amt, string desc, TransactionsModel m)
{
var qq = from tt in DbUtil.Db.Transactions
where tt.OriginalId == id || tt.Id == id
orderby tt.Id descending
select tt;
var t = qq.FirstOrDefault();
if (t == null)
{
return(Content("notran"));
}
var t2 = new Transaction
{
TransactionId = "Adjustment",
First = t.First,
MiddleInitial = t.MiddleInitial,
Last = t.Last,
Suffix = t.Suffix,
Amt = amt,
Emails = t.Emails,
Amtdue = t.Amtdue - amt,
Approved = true,
AuthCode = "",
Message = desc,
Donate = -t.Donate,
Regfees = -t.Regfees,
TransactionDate = DateTime.Now,
TransactionGateway = t.TransactionGateway,
Testing = t.Testing,
Description = t.Description,
OrgId = t.OrgId,
OriginalId = t.OriginalId,
Participants = t.Participants,
Financeonly = t.Financeonly,
PaymentType = t.PaymentType,
LastFourCC = t.LastFourCC,
LastFourACH = t.LastFourACH
};
DbUtil.Db.Transactions.InsertOnSubmit(t2);
DbUtil.Db.SubmitChanges();
DbUtil.Db.SendEmail(Util.TryGetMailAddress(DbUtil.Db.StaffEmailForOrg(t2.OrgId ?? 0)),
"Adjustment Transaction",
$@"<table>
<tr><td>Name</td><td>{Transaction.FullName(t)}</td></tr>
<tr><td>Email</td><td>{t.Emails}</td></tr>
<tr><td>Address</td><td>{t.Address}</td></tr>
<tr><td>Phone</td><td>{t.Phone}</td></tr>
<tr><th colspan=""2"">Transaction Info</th></tr>
<tr><td>Description</td><td>{t.Description}</td></tr>
<tr><td>Amount</td><td>{t.Amt:N2}</td></tr>
<tr><td>Date</td><td>{t.TransactionDate.FormatDateTm()}</td></tr>
<tr><td>TranIds</td><td>Org: {t.Id} {t.TransactionId}, Curr: {t2.Id} {t2.TransactionId}</td></tr>
</table>", Util.EmailAddressListFromString(DbUtil.Db.StaffEmailForOrg(t2.OrgId ?? 0)));
DbUtil.LogActivity("Adjust for " + t.TransactionId);
return(View("List", m));
}
public ActionResult DeleteGoerSenderAmount(int id, TransactionsModel m)
{
var gsa = DbUtil.Db.GoerSenderAmounts.Single(tt => tt.Id == id);
DbUtil.Db.GoerSenderAmounts.DeleteOnSubmit(gsa);
DbUtil.Db.SubmitChanges();
return(View("GoerSupporters", m));
}
public IActionResult List()
{
var trans = _transactionService.GetAllTransactions();
var resModel = new TransactionsModel();
resModel.Transactions = trans.ToList();
return(View(viewName: "TransactionList", resModel));
}
public async Task Remove(object param)
{
Transaction = TransactionsModel.Transaction(param as TransactionsModel);
await _api.DeleteTransaction(Transaction);
_ = new AllBankAccounts();
_ = new AllTransactions();
TransactionsList = _api.GetTransactionsById(DataStore.AccountNo);
}
public void PrepareMissionTrip(int?gsid, int?goerid)
{
if (gsid.HasValue) // this means that the person is a supporter who got a support email
{
var goerSupporter = CurrentDatabase.GoerSupporters.SingleOrDefault(gg => gg.Id == gsid); // used for mission trips
if (goerSupporter != null)
{
GoerId = goerSupporter.GoerId; // support this particular goer
Goer = CurrentDatabase.LoadPersonById(goerSupporter.GoerId);
GoerSupporterId = gsid;
}
else
{
GoerId = 0; // allow this supporter to still select a goer
}
}
else if (goerid.HasValue)
{
GoerId = goerid;
Goer = CurrentDatabase.LoadPersonById(goerid ?? 0);
}
// prepare supporter data
OrganizationMember OrgMember = null;
if (Goer != null)
{
OrgMember = CurrentDatabase.OrganizationMembers.SingleOrDefault(mm => mm.OrganizationId == org.OrganizationId && mm.PeopleId == Goer.PeopleId);
}
if (OrgMember != null)
{
var transactions = new TransactionsModel(OrgMember.TranId)
{
GoerId = Goer.PeopleId
};
var summaries = CurrentDatabase.ViewTransactionSummaries.SingleOrDefault(ts => ts.RegId == OrgMember.TranId && ts.PeopleId == Goer.PeopleId && ts.OrganizationId == org.OrganizationId);
Supporters = transactions.Supporters().Where(s => s.OrgId == org.OrganizationId).ToArray();
// prepare funding data
MissionTripCost = summaries.IndPaid + summaries.IndDue;
MissionTripRaised = OrgMember.AmountPaidTransactions(CurrentDatabase);
}
// prepare date data
if (org.FirstMeetingDate.HasValue && org.LastMeetingDate.HasValue)
{
DateTimeRangeFormatter formatter = new DateTimeRangeFormatter();
MissionTripDates = formatter.FormatDateRange(org.FirstMeetingDate.Value, org.LastMeetingDate.Value);
}
else if (org.FirstMeetingDate.HasValue)
{
MissionTripDates = org.FirstMeetingDate.Value.ToString("MMMM d, yyyy");
}
else if (org.LastMeetingDate.HasValue)
{
MissionTripDates = org.LastMeetingDate.Value.ToString("MMMM d, yyyy");
}
}
public ActionResult TransactionListFiltered(TransactionsModel filterModel)
{
var model = new TransactionListModel
{
Transactions = DbAccess.GetTransactions(filterModel)
};
return(View("TransactionList", model));
}
public ActionResult DeleteManual(int id, TransactionsModel m)
{
DbUtil.Db.ExecuteCommand("UPDATE dbo.OrganizationMembers SET TranId = NULL WHERE TranId = {0}", id);
var t = DbUtil.Db.Transactions.Single(tt => tt.Id == id);
DbUtil.Db.Transactions.DeleteOnSubmit(t);
DbUtil.Db.SubmitChanges();
return(View("List", m));
}
public IActionResult Index(TransactionsModel transModel)
{
if (HttpContext.Session.Get("CustomerID") == null)
{
return(RedirectToAction("Index", "Login"));
}
return(View(GenerateTransactionsModel(transModel.curAccount)));
}
public ActionResult DeleteManual(int id, TransactionsModel m)
{
DbUtil.Db.ExecuteCommand(@"
UPDATE dbo.OrganizationMembers SET TranId = NULL WHERE TranId = {0}
DELETE dbo.TransactionPeople WHERE Id = {0}
DELETE dbo.[Transaction] WHERE Id = {0}
", id);
return(View("List", m));
}
public ActionResult Index(int?id, int?goerid = null, int?senderid = null, string reference = "", string desc = "")
{
var m = new TransactionsModel(id, reference, desc)
{
GoerId = goerid, SenderId = senderid
};
return(View(m));
}
public ActionResult Index(int?id, int?goerid = null, int?senderid = null)
{
var m = new TransactionsModel(id)
{
GoerId = goerid, SenderId = senderid
};
return(View(m));
}
public async Task DeleteTransaction(TransactionsModel trans)
{
using HttpResponseMessage response = await ApiClient.DeleteAsync($"api/Transaction/{trans.Id}");
if (!response.IsSuccessStatusCode)
{
MessageBox.Show("Error Code" + response.StatusCode + " : Message - " + response.ReasonPhrase);
}
}
public ActionResult Index(int?id, int?goerid = null, int?senderid = null, string reference = "", string desc = "", bool isBatchref = false)
{
var m = new TransactionsModel(CurrentDatabase, id, reference, desc, isBatchref)
{
GoerId = goerid, SenderId = senderid
};
return(View(m));
}
public ActionResult AddCredit(bool usercredit = false, int eventid = 0, decimal amount = 0, int CustomerId = 0)
{
TransactionsModel model = new TransactionsModel();
model.Amount = Convert.ToInt32(amount);
model.EventId = eventid;
model.UserCredit = usercredit;
model.CustomerId = CustomerId;
return(View(model));
}
private void GetReportDetail(string Document)
{
TransactionsModel report = new TransactionsModel();
report.ShowReportDetail(Document);
reportTransactionsDetailBindingSource.DataSource = report;
reportTransactionsDetailBindingSource.DataSource = report.ReportTransactionsDetail;
this.ReportViewerTransactions.RefreshReport();
}
public async void GetListTransactionsModel_FromInitializedDbTables_LogicTransactionsModelsEqualExpectedTransactionsModels()
{
// arrange
var transactions = GetTransactions();
var companies = GetCompanies();
var operations = GetOperations();
fixture.db.AddRange(transactions);
fixture.db.AddRange(companies);
fixture.db.AddRange(operations);
await fixture.db.SaveChangesAsync();
var expected = new TransactionsModel[]
{
new TransactionsModel
{
Id = 44440,
Date = DateTime.UtcNow.TrimUpToDays(),
CompanyId = 44440,
Type = TransactionTypes.Income,
IsOpen = true,
Comment = "Why chicken cross the road?",
CompanyName = "Com-pun-y #1",
OperationsCount = 2
},
new TransactionsModel
{
Id = 44441,
Date = DateTime.UtcNow.TrimUpToDays(),
CompanyId = 44441,
Type = TransactionTypes.Income,
IsOpen = false,
Comment = "To get to other side : )",
CompanyName = "Company #2",
OperationsCount = 1
},
};
// act
var actual = (await logic.GetAllDataModelAsync()).ToList();
// assert
foreach (var expectedItem in expected)
{
Assert.Contains(actual, actualItem =>
expectedItem.Id == actualItem.Id &&
expectedItem.Date == actualItem.Date &&
expectedItem.CompanyId == actualItem.CompanyId &&
expectedItem.Type == actualItem.Type &&
expectedItem.IsOpen == actualItem.IsOpen &&
expectedItem.Comment == actualItem.Comment &&
expectedItem.CompanyName == actualItem.CompanyName &&
expectedItem.OperationsCount == actualItem.OperationsCount);
}
}
public ActionResult ReportByBatchDescription(DateTime?sdt, DateTime?edt)
{
var m = new TransactionsModel()
{
startdt = sdt,
enddt = edt,
usebatchdates = true,
};
return(View(m));
}
//
// GET: /Reports/
public ActionResult Transactions(Guid?userId)
{
var model = new TransactionsModel
{
UserId = userId ?? SessionData.UserId,
Provinces = DbAccess.GetProvinces(),
Statuses = Enum.GetValues(typeof(ReservationStatus)).Cast <ReservationStatus>().ToList(),
Agencys = DbAccess.GetAgencys().Where(a => a.Enabled).ToList()
};
return(View(model));
}
public ActionResult SetParent(int id, int parid, TransactionsModel m)
{
var t = DbUtil.Db.Transactions.SingleOrDefault(tt => tt.Id == id);
if (t == null)
{
return(Content("notran"));
}
t.OriginalId = parid;
DbUtil.Db.SubmitChanges();
return(View("List", m));
}
public ActionResult Transactions()
{
var context = new AppDbContext();
AppUser currentUser = context.Users.Find(System.Web.HttpContext.Current.User.Identity.GetUserId());
TransactionsModel model = new TransactionsModel()
{
TransactionsAsBuyer = currentUser.BuyerTransactions,
TransactionsAsSeller = currentUser.SellerTransactions
};
return(View(model));
}
public ActionResult AssignGoer(int id, int?gid, TransactionsModel m)
{
if (gid == 0)
{
gid = null;
}
var gsa = DbUtil.Db.GoerSenderAmounts.Single(tt => tt.Id == id);
gsa.GoerId = gid;
DbUtil.Db.SubmitChanges();
return(View("GoerSupporters", m));
}
public IActionResult Index()
{
if (!string.IsNullOrEmpty(HttpContext.Session.GetString("token")))
{
HttpClient httpClient = new HttpClient();
httpClient.BaseAddress = new Uri("http://207.154.196.92:5002/");
httpClient.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", HttpContext.Session.GetString("token"));
HttpResponseMessage response = httpClient.GetAsync("api/transaction").Result;
string responseBody = response.Content.ReadAsStringAsync().Result;
if (string.IsNullOrEmpty(responseBody))
{
HttpContext.Session.SetString("token", "");
return(RedirectToAction("Index", "Home"));
}
JObject responseJson = JsonConvert.DeserializeObject(responseBody) as JObject;
TransactionsModel transactionsModel = JsonConvert.DeserializeObject <TransactionsModel>(responseBody);
UserModel userModel = new UserModel();
response = httpClient.GetAsync("api/BankAccount").Result;
responseBody = response.Content.ReadAsStringAsync().Result;
responseJson = JsonConvert.DeserializeObject(responseBody) as JObject;
BankAccountsModel bankAccounts = JsonConvert.DeserializeObject <BankAccountsModel>(responseBody);
HomePageModel homePageModel = new HomePageModel();
userModel.Token = HttpContext.Session.GetString("token");
userModel.TC = HttpContext.Session.GetString("tc");
userModel.FirstName = HttpContext.Session.GetString("firstName");
userModel.LastName = HttpContext.Session.GetString("lastName");
userModel.PhoneNumber = HttpContext.Session.GetString("phoneNumber");
userModel.CustomerNo = Convert.ToInt32(HttpContext.Session.GetString("no"));
transactionsModel.transactions = transactionsModel.transactions.OrderBy(x => x.date).ToList();
bankAccounts.BankAccounts = bankAccounts.BankAccounts.OrderBy(x => x.No).ToList();
homePageModel.TransactionsModel = transactionsModel;
homePageModel.UserModel = userModel;
homePageModel.BankAccountsModel = bankAccounts;
return(View("dashboard", homePageModel));
}
HttpContext.Session.Clear();
return(View());
}
public async Task SendTransaction(TransactionsModel Details)
{
using HttpResponseMessage response = await ApiClient.PostAsJsonAsync("api/Transaction", Details);
if (response.IsSuccessStatusCode)
{
MessageBox.Show("Transaction successful");
}
else
{
MessageBox.Show("Error Code" + response.StatusCode + " : Message - " + response.ReasonPhrase);
}
}
private void UpdateTransactionStatus(int _transactionId, decimal _paymentCashAmount, decimal _paymentCheckAmount)
{
var transaction = new TransactionsModel()
{
id = _transactionId,
DateModified = DateTime.Now.ToString(GlobalVariables.DATABASE_TIME_FORMAT),
IsPaid = true,
PaymentCashAmount = _paymentCashAmount,
PaymentCheckAmount = _paymentCheckAmount
};
mTransactionsDataAccess.UpdateTransactionStatusToPaid(transaction);
}
