private void btnSave_Click(object sender, EventArgs e)
{
if (oMTransactionList.Count > 0)
{
if (iGridControl.Visible)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_CLOSE_THE_ISBN_PANEL.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
if (dTotalAmount > iPaymentWindow.ReceiveAmount)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_ENTER_EXACT_PAYMENT_AMOUNT.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
if (oMTransactionList.Where(fw => fw.BFLAG == true).Count() == 0)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_SELECT_A_RECORD.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
foreach (var oItem in oMTransactionList)
{
oBook = new DataAccess.Book();
oMTransaction = new Model.Transaction();
oMTransaction.PERSON_ID = txtBorrowerID.Text;
oMTransaction.BOOK_ID = oItem.BOOK_ID;
oMTransaction.BOOK_NO = oItem.BOOK_NO;
oMTransaction.TOTAL_AMOUNT = dTotalAmount;
oMTransaction.MODIFIED_DATE = DateTime.Now.ToString("yyyy-MM-dd");
oMTransaction.MODIFIED_BY = eVariable.sUsername;
oMTransaction.REMARKS = rdDamage.Checked == true ? "DAMAGE" : "LOST";
if (oItem.BFLAG)
{
oMTransaction.STATUS = "INACTIVE";
oBook.ReturnBook(oMTransaction);
}
}
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.TRANSACTION_HAS_BEEN_SUCESSFULLY_SAVE.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
iPaymentWindow.clearText();
eVariable.ClearText(pnlMain);
dgBooks.Rows.Clear();
}
else
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_SELECT_A_RECORD.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
}
}
private void dgBooks_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgBooks.Rows.Count > 0)
{
if (e.ColumnIndex == 10 && e.RowIndex >= 0)
{
oMTransaction = new Model.Transaction();
oMTransaction.PERSON_ID = txtBorrowerID.Text;
oMTransaction.BOOK_ID = dgBooks.Rows[e.RowIndex].Cells[0].Value.ToString();
oMTransaction.TITLE = dgBooks.Rows[e.RowIndex].Cells[1].Value.ToString();
oMTransaction.SUBJECT = dgBooks.Rows[e.RowIndex].Cells[2].Value.ToString();
oMTransaction.ADDED_DATE = dgBooks.Rows[e.RowIndex].Cells[3].Value.ToString();
oMTransaction.BOOK_PRICE = dgBooks.Rows[e.RowIndex].Cells[4].Value.ToString();
oMTransaction.RENT_PRICE = dgBooks.Rows[e.RowIndex].Cells[5].Value.ToString();
oMTransaction.DUE_INTEREST = Convert.ToDouble(dgBooks.Rows[e.RowIndex].Cells[6].Value);
oMTransaction.LD_INTEREST = Convert.ToDouble(dgBooks.Rows[e.RowIndex].Cells[7].Value);
oMTransaction.TOTAL_QTY = dgBooks.Rows[e.RowIndex].Cells[8].Value.ToString();
oMTransaction.TOTAL_DAYS = dgBooks.Rows[e.RowIndex].Cells[9].Value.ToString();
iGridControl.BookCommonData = oMTransaction;
iGridControl.BookListData = oMTransactionList;
iGridControl.FindOption = iControlGrid.iGridControl.FIND_OPTION.SEARCH_LOCAL_BORROWED_BOOK_ISBN;
iGridControl.SetCheckBoxColumnVisible = true;
iGridControl.SetHeaderVisible = true;
iGridControl.PopulateRecord();
iGridControl.Visible = true;
}
}
}
private void AutoFillBook()
{
dgBooks.Rows.Clear();
oBook = new DataAccess.Book();
Model.Transaction oRetain = new Model.Transaction();
foreach (DataRow row in oBook.GetTransactionBookRecordPerBorrowerNotSort(eVariable.FIND_BOOK.BOOK_BORROWED, eVariable.sBorrowerID).Rows)
{
oMTransaction = new Model.Transaction();
oMTransaction.PERSON_ID = eVariable.sBorrowerID;
oMTransaction.FIRST_NAME = eVariable.FirstName;
oMTransaction.MIDDLE_NAME = eVariable.MiddleName;
oMTransaction.LAST_NAME = eVariable.LastName;
oMTransaction.BOOK_ID = row[0].ToString();
oMTransaction.TITLE = row[1].ToString();
oMTransaction.SUBJECT = row[2].ToString();
oMTransaction.CATEGORY = row[3].ToString();
oMTransaction.AUTHOR = row[4].ToString();
oMTransaction.PUBLISH_DATE = row[5].ToString();
oMTransaction.LOCATION = row[6].ToString();
oMTransaction.BOOK_PRICE = row[7].ToString();
oMTransaction.RENT_PRICE = row[8].ToString();
oMTransaction.DUE_INTEREST = Convert.ToDouble(row[9].ToString());
oMTransaction.LD_INTEREST = Convert.ToDouble(row[10].ToString());
oMTransaction.TOTAL_QTY = row[11].ToString();
oMTransaction.TOTAL_DAYS = row[12].ToString();
oMTransaction.ADDED_DATE = row[13].ToString();
oMTransaction.BOOK_NO = row[14].ToString();
oMTransaction.ISBN_NUMBER = row[15].ToString();
oMTransaction.BFLAG = true;
oMTransactionList.Add(oMTransaction);
}
LoadRecords();
}
void FillRecordList()
{
oMTransactionList = new List <Model.Transaction>();
oBook = new DataAccess.Book();
foreach (DataRow row in oBook.GetBookRecords(eVariable.FILTER_BOOK.BOOK_DEFAULT, "ACTIVE", eVariable.sBookID).Rows)
{
oMTransaction = new Model.Transaction();
oMTransaction.BOOK_ID = row[0].ToString();
oMTransaction.BOOK_NO = row[1].ToString();
oMTransaction.TITLE = row[2].ToString();
oMTransaction.SUBJECT = row[3].ToString();
oMTransaction.CATEGORY = row[4].ToString();
oMTransaction.AUTHOR = row[5].ToString();
oMTransaction.PUBLISH_DATE = row[6].ToString();
oMTransaction.ISBN_NUMBER = row[7].ToString();
oMTransaction.LOCATION = row[8].ToString();
oMTransaction.BOOK_PRICE = row[9].ToString();
oMTransaction.RENT_PRICE = row[10].ToString();
oMTransaction.ADDED_DATE = row[11].ToString();
oMTransaction.ADDED_BY = row[12].ToString();
oMTransaction.MODIFIED_DATE = row[13].ToString();
oMTransaction.MODIFIED_BY = row[14].ToString();
oMTransaction.REMARKS = row[15].ToString();
oMTransaction.STATUS = row[16].ToString();
oMTransactionList.Add(oMTransaction);
}
}
public TransactionCreateViewItem(Model.Transaction transaction)
: base(transaction)
{
SelectedSKUGuids = new List <Guid>(
(from x in transaction.TransactionItems select x.SkuId).ToList()
);
}
public IActionResult Deposit([FromBody] TransactionRequest request)
{
Model.Transaction transaction = new Model.Transaction()
{
AccountId = request.AccountId,
Amount = request.Amount,
CreationDate = DateTime.Now.ToShortDateString(),
Type = "Deposit"
};
transaction = _services.Deposit(transaction);
bool isProccess = _servicesAccount.Execute(transaction);
if (isProccess)
{
_bus.SendCommand(new DepositCreateCommand(
idTransaction: transaction.Id,
amount: transaction.Amount,
type: transaction.Type,
creationDate: transaction.CreationDate,
accountId: transaction.AccountId
));
_bus.SendCommand(new MailCreateCommand(
sendDate: transaction.CreationDate,
accountId: transaction.AccountId
));
}
return(Ok());
}
/// <summary>
/// Construct viewmodel
/// </summary>
/// <param name="transaction">Transaction that this viewmodel represents</param>
public TransactionViewModel(Model.Transaction transaction)
: this()
{
this.TransactionId = transaction.TransactionId;
this.Status = transaction.Status;
this.CreatedDateTime = transaction.CreatedDateTime;
}
private void dgBooks_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 10 && e.RowIndex >= 0)
{
oMTransaction = new Model.Transaction();
oMTransaction.BOOK_ID = dgBooks.Rows[e.RowIndex].Cells[0].Value.ToString();
oMTransaction.TITLE = dgBooks.Rows[e.RowIndex].Cells[1].Value.ToString();
oMTransaction.SUBJECT = dgBooks.Rows[e.RowIndex].Cells[2].Value.ToString();
oMTransaction.CATEGORY = dgBooks.Rows[e.RowIndex].Cells[3].Value.ToString();
oMTransaction.AUTHOR = dgBooks.Rows[e.RowIndex].Cells[4].Value.ToString();
oMTransaction.PUBLISH_DATE = dgBooks.Rows[e.RowIndex].Cells[5].Value.ToString();
oMTransaction.ADDED_DATE = dgBooks.Rows[e.RowIndex].Cells[6].Value.ToString();
oMTransaction.BOOK_PRICE = dgBooks.Rows[e.RowIndex].Cells[7].Value.ToString();
oMTransaction.RENT_PRICE = dgBooks.Rows[e.RowIndex].Cells[8].Value.ToString();
oMTransaction.PERSON_ID = txtBorrowerID.Text;
iGridControl.BookCommonData = oMTransaction;
iGridControl.BookListData = oMTransactionList;
iGridControl.FindOption = iControlGrid.iGridControl.FIND_OPTION.SEARCH_SELECTED_BORROWED_BOOK_ISBN;
iGridControl.SetHeaderVisible = true;
iGridControl.PopulateRecord();
iGridControl.Visible = true;
}
}
protected virtual void SaveForm()
{
this.ResetError();
if (this.Transaction != null)
{
try
{
this.Transaction.Commit(true);
this.Transaction = null;
this.OnSaved();
}
catch (Model.Exceptions.ServerException e)
{
// Raise Error Message
this.OnError(e.Message);
// Add Item to a new Transaction
this.Transaction = this.Session.Model.BeginTransaction();
this.Item.Update(this.Transaction);
}
this.SetCommandsCanExecute();
}
}
public IEnumerable <Model.Transaction> LoadTransactions(Stream stream)
{
var result = new List <Model.Transaction>();
using (var reader = new StreamReader(stream))
{
// Read and ignore first row
var line = reader.ReadLine();
if (line != null)
{
line = reader.ReadLine();
while (line != null)
{
var tokens = line.Split(',');
if (tokens.Length == 12)
{
var txn = new Model.Transaction(DateTime.Parse(tokens[2]), tokens[4], tokens[3] == "B" ? TransactionTypes.Buy : TransactionTypes.Sell, Convert.ToInt32(tokens[5]), Convert.ToDecimal(tokens[7]), Convert.ToDecimal(tokens[8]));
result.Add(txn);
}
line = reader.ReadLine();
}
}
}
return(result);
}
public void ReturnBook(Model.Transaction oMTransaction)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_RETURN_BOOK";
ddq.AddParamer("@BOOK_ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID);
ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE);
ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY);
ddq.AddParamer("@TOTAL_AMOUNT", SqlDbType.Decimal, oMTransaction.TOTAL_AMOUNT);
ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateBookDetails(Model.Transaction oMTransaction)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_UPDATE_BOOK_DETAILS";
ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE);
ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT);
ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY);
ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR);
ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE);
ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION);
ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE);
ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE);
ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER);
ddq.AddParamer("@MODIFIED_DATE", SqlDbType.VarChar, oMTransaction.MODIFIED_DATE);
ddq.AddParamer("@MODIFIED_BY", SqlDbType.VarChar, oMTransaction.MODIFIED_BY);
ddq.AddParamer("@REMARKS", SqlDbType.VarChar, oMTransaction.REMARKS);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public void RequestBook(Model.Transaction oMTransaction)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "SP_REQUEST_BOOK";
ddq.AddParamer("@ID", SqlDbType.VarChar, oMTransaction.BOOK_ID);
ddq.AddParamer("@BORROWER_ID", SqlDbType.VarChar, oMTransaction.PERSON_ID);
ddq.AddParamer("@BOOK_NO", SqlDbType.VarChar, oMTransaction.BOOK_NO);
ddq.AddParamer("@TITLE", SqlDbType.VarChar, oMTransaction.TITLE);
ddq.AddParamer("@SUBJECT", SqlDbType.VarChar, oMTransaction.SUBJECT);
ddq.AddParamer("@CATEGORY", SqlDbType.VarChar, oMTransaction.CATEGORY);
ddq.AddParamer("@AUTHOR", SqlDbType.VarChar, oMTransaction.AUTHOR);
ddq.AddParamer("@PUBLISH_DATE", SqlDbType.VarChar, oMTransaction.PUBLISH_DATE);
ddq.AddParamer("@ISBN_NUMBER", SqlDbType.VarChar, oMTransaction.ISBN_NUMBER);
ddq.AddParamer("@LOCATION", SqlDbType.VarChar, oMTransaction.LOCATION);
ddq.AddParamer("@BOOK_PRICE", SqlDbType.VarChar, oMTransaction.BOOK_PRICE);
ddq.AddParamer("@RENT_PRICE", SqlDbType.VarChar, oMTransaction.RENT_PRICE);
ddq.AddParamer("@DAYS_BORROWED", SqlDbType.VarChar, oMTransaction.TOTAL_DAYS);
ddq.AddParamer("@ADDED_DATE", SqlDbType.VarChar, oMTransaction.ADDED_DATE);
ddq.AddParamer("@ADDED_BY", SqlDbType.VarChar, oMTransaction.ADDED_BY);
ddq.AddParamer("@STATUS", SqlDbType.VarChar, oMTransaction.STATUS);
ddq.ExecuteNonQuery(CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public TransactionDetailsViewItem(Model.Transaction transaction,
IEnumerable <Model.TransactionItem> transactionItems,
IEnumerable <Model.TransactionIgnoredItem> transactionIgnoredItems,
IEnumerable <Model.License> domainlessLicenseQuery,
IEnumerable <Model.License> customerapplessLicenseQuery)
: base(transaction)
{
PurchaserEmail = transaction.PurchaserEmail;
PurchaserName = (transactionItems.Any(l => l.License != null)) ?
transactionItems.FirstOrDefault().License.PurchasingCustomer.Name : transaction.PurchaserName;
OwnerName = (transactionItems.Any(l => l.License != null)) ?
transactionItems.FirstOrDefault().License.OwningCustomer.Name : "None";
SKUSummary = (from x in transactionItems select x.Sku).ToSummary(x => x.SkuCode, 99, ", ");
IgnoredSummary = (from x in transactionIgnoredItems select x.Description).ToSummary(x => x, 99, ", ");
StatusName = transaction.Status.GetDescription <Model.TransactionStatus>();
DomainlessLicenses = (from x in domainlessLicenseQuery select x.ObjectId).ToList();
CustomerapplessLicenses = (from x in customerapplessLicenseQuery select x.ObjectId).ToList();
}
public void Insert(Model.Transaction transaction)
{
//_context.DbConnection.Insert(transaction);
transaction.TransactionId = _context.DbConnection.Query <long>(
@"INSERT INTO [Transaction]
( TransactionDate, Description,TransactionAmount,CreatedDate,ModifiedDate,CurrencyCode,Merchant) VALUES
( @TransactionDate, @Description,@TransactionAmount,@CreatedDate,@ModifiedDate,@CurrencyCode,@Merchant );
select last_insert_rowid()", transaction).First();
}
private static async Task <bool> IndexBlock(Model.BCExplorerContext context, string blockHash)
{
_logger.LogInformation($"Processing block at height {_currentBlockHeight}: {blockHash}");
BlockResult blockResult = await _client.GetBlockAsync(blockHash);
if (blockResult == null)
{
_logger.LogWarning($"Warning - could not retrieve block at height {_currentBlockHeight}: {blockHash}");
return(false);
}
var block = new Model.Block
{
Id = _currentBlockNumber,
Height = _currentBlockHeight,
BlockHash = blockHash,
BlockData = blockResult.OriginalJson
};
context.Blocks.Add(block);
if (_currentBlockHeight == 0)
{
// for the transaction in the genesis block, we can't pull transaction data, so this is all we know
var genesisBlockTransaction = new Model.Transaction {
Block = block, Id = blockResult.Transactions[0]
};
context.Transactions.Add(genesisBlockTransaction);
_currentBlockHeight++;
_currentBlockNumber++;
context.SaveChanges();
return(true);
}
List <BCExplorer.Network.Models.Transaction> blockTransactions = new List <BCExplorer.Network.Models.Transaction>();
foreach (var txid in blockResult.Transactions)
{
var transaction = await _transactionProvider.GetTransaction(txid);
transaction.Block = new BCExplorer.Network.Models.Block {
Height = _currentBlockHeight
};
blockTransactions.Add(transaction);
}
foreach (var blockTx in blockTransactions)
{
ProcessTransaction(blockTx, context);
}
context.SaveChanges();
_currentBlockHeight++;
_currentBlockNumber++;
return(true);
}
private void dgBooks_CellEnter(object sender, DataGridViewCellEventArgs e)
{
if (dgBooks.Rows.Count > 0)
{
oMTransaction = new Model.Transaction();
oMTransaction.PERSON_ID = txtBorrowerID.Text;
oMTransaction.BOOK_ID = dgBooks.Rows[e.RowIndex].Cells[0].Value.ToString();
}
}
/// <summary>
/// Convert back to Transaction instance
/// </summary>
/// <param name="original">Original Transaction. If Null a new instance is created.</param>
/// <returns>Transaction containing viewmodel data </returns>
public Model.Transaction ToEntity(Model.Transaction original)
{
Model.Transaction current = original ?? new Model.Transaction();
//Update from viewmodel, never update createdDateTime
current.TransactionId = this.TransactionId;
current.Status = this.Status;
return(current);
}
public Model.Transaction Create(Model.Transaction transaction, int?targetGoalId)
{
//Set the parameters and
string sql = LoadSqlResources().First().Value;
Dictionary <string, object> parameters = ConvertToParameters(transaction);
parameters.Add("TargetGoalId", targetGoalId);
return(typedDataAccess.ExecuteQuery <Model.Transaction>(sql, parameters).First());
}
public Decimal GetTransactionFee(Model.Transaction tx)
{
TransactionSearchReq request = new TransactionSearchReq();
request.TransactionSearchRequest = new TransactionSearchRequestType();
request.TransactionSearchRequest.TransactionID = tx.MerchantTransactionId;
request.TransactionSearchRequest.StartDate = tx.TimeCreated.Value.ToString("yyyy-MM-ddTHH:mm:ss");
request.TransactionSearchRequest.EndDate = tx.TimeCreated.Value.ToString("yyyy-MM-ddTHH:mm:ss");
Dictionary <string, string> config = new Dictionary <string, string>();
config.Add("mode", Mode);
config.Add("account1.apiUsername", Username);
config.Add("account1.apiPassword", Password);
config.Add("account1.apiSignature", Signature);
// Create the PayPalAPIInterfaceServiceService service object to make the API call
PayPalAPIInterfaceServiceService service = new PayPalAPIInterfaceServiceService(config);
TransactionSearchResponseType resp = service.TransactionSearch(request);
PaymentTransactionSearchResultType payment;
if (resp.Errors.Count > 0)
{
throw new Exception(resp.Errors.Select(e => e.ShortMessage).Aggregate((current, next) => current + ", " + next));
}
if (resp.PaymentTransactions.Count() <= 1)
{
payment = resp.PaymentTransactions.FirstOrDefault();
}
else
{
payment = resp.PaymentTransactions.Where(x => x.TransactionID == tx.MerchantTransactionId).FirstOrDefault();
if (payment == null)
{
//transaction not found. try to search any linked transactions for timestamp, amount and type
//check previous day as well because of Paypal using GMT
payment = resp.PaymentTransactions.Where(x => x.Type.ToUpper() == GetTransactionType(tx.Type).ToString().ToUpper() &&
x.GrossAmount.value.AsDouble() == tx.Amount &&
x.Timestamp.AsDateTime().Value.AddDays(-1) <= tx.TimeCreated &&
x.Timestamp.AsDateTime().Value >= tx.TimeCreated).FirstOrDefault();
}
}
if (payment != null)
{
return(decimal.Parse(payment.FeeAmount.value));
}
return(0);
}
public Form(Manager.Session Session, Model.Store Store)
: base(Session)
{
this.Store = Store;
this.Refresh = new RefreshCommand(this);
this.Create = new CreateCommand(this);
this.Edit = new EditCommand(this);
this.Save = new SaveCommand(this);
this.Promote = new PromoteCommand(this);
this.Undo = new UndoCommand(this);
this.Transaction = null;
}
public frmAdjustItem(frmBookList oFrmBook, Model.Transaction oTrans)
{
InitializeComponent();
oFrmBookLst = oFrmBook;
oMTransaction = oTrans;
eVariable.DisableTextEnterKey(pnlMain);
eVariable.DisableTextEnterKey(pnlOther);
GetDataRecordFunctionPointer += new GetDataRecordFunction(GetRecord);
iGridControl.GetDataRecord = GetDataRecordFunctionPointer;
}
public TransactionIndexViewItem(Model.Transaction transaction, IEnumerable <Model.TransactionItem> transactionItems)
: base(transaction)
{
PurchaserName = (transactionItems.FirstOrDefault().License != null) ?
transactionItems.FirstOrDefault().License.PurchasingCustomer.Name : transaction.PurchaserName;
SKUSummary = transactionItems.ToSummary(x => (x.Sku != null) ? x.Sku.SkuCode : "None", 3, ", ");
StatusName = transaction.Status.GetDescription <TransactionStatus>();
IsWaitingForClaim = transaction.IsWaitingForClaim;
}
private static void SellProduct(ref Guid id)
{
int quantity = 0;
decimal amount = 0;
Model.Transaction trc1 = new Model.Transaction();
List <Model.TransactionDetail> list_detial = new List <Model.TransactionDetail>();
trc1.Cashier = "Admin";
trc1.Type = 2;
trc1.Date = DateTime.Now;
trc1.ID = Guid.NewGuid();
bool add = true;
while (add)
{
Model.TransactionDetail detail1 = new Model.TransactionDetail();
SellProductDetail(ref detail1);
detail1.TransactionID = trc1.ID;
quantity += detail1.Quantity;
amount += detail1.Amount;
list_detial.Add(detail1);
Console.WriteLine("Press 1 to Add New Item, 2 to Payment");
try
{
int type = Convert.ToInt16(Console.ReadLine());
switch (type)
{
case 1:
add = true;
break;
case 2:
add = false;
id = trc1.ID;
break;
default:
break;
}
}
catch (Exception)
{
Console.WriteLine("Has Error");
}
}
trc1.Quantity = quantity;
trc1.Amount = amount;
listTransaction.Add(trc1);
listTransactionDetail.AddRange(list_detial);
}
public async Task <Model.Transaction> SaveTrans(string fromUserId, string toUserId, double amount)
{
var newTrans = new Model.Transaction()
{
FromUserId = fromUserId, ToUserId = toUserId, Amount = amount
};
await _context.Transactions.AddAsync(newTrans);
await _context.SaveChangesAsync();
return(newTrans);
}
private void CreateForm()
{
this.ResetError();
// Undo Changes
this.UndoForm();
this.Transaction = this.Session.Model.BeginTransaction();
this.Binding = this.Store.Create(this.Transaction);
this.SetCommandsCanExecute();
this.OnCreated();
}
public Boolean IsBookCheckout(Model.Transaction oData)
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = " SELECT ID FROM TBL_BOOKS WHERE BOOK_NO = '" + oData.BOOK_NO + "' AND [STATUS] = 'ACTIVE' " +
" AND (BOOK_NO IN (SELECT BOOK_NO FROM TBL_BORROWEDBOOKS WHERE [STATUS] = 'BORROWED') " +
" OR BOOK_NO IN (SELECT BOOK_NO FROM TBL_BORROWERREQUEST WHERE [STATUS] = 'REQUEST')) ";
ds = ddq.GetDataset(CommandType.Text);
return(ds.Tables[0].Rows.Count > 0 ? true : false);
}
private void dgBooks_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == 10 && e.RowIndex >= 0)
{
oMTransaction = new Model.Transaction();
oMTransaction.BOOK_ID = dgBooks.Rows[e.RowIndex].Cells[0].Value.ToString();
DatagridSelect(sender, e);
}
}
catch (Exception ex)
{ }
}
public void Delete(Model.Transaction transaction)
{
SqlCeTransaction tx = null;
try
{
using (var conn = new SqlCeConnection(Store.ConnectionString))
{
conn.Open();
string sql = "DELETE FROM " + tableName + " WHERE ID='" + transaction.ID + "'";
tx = conn.BeginTransaction();
var cmd = new SqlCeCommand(sql, conn);
cmd.Transaction = tx;
cmd.ExecuteNonQuery();
if (transaction.Type == TransactionType.Income.ToString() || transaction.Type == TransactionType.Expense.ToString())
{
decimal currentBalance = accountRepository.GetBalanceAfter(transaction.AccountId, transaction.Type, transaction.Amount,
transaction.Amount, ActionType.Delete).CurrentBalance2;
accountRepository.UpdataBalance(transaction.AccountId, currentBalance, conn, tx);
}
else if (transaction.Type == TransactionType.Transfer.ToString() || transaction.Type == TransactionType.Withdrawl.ToString() ||
transaction.Type == TransactionType.Payment.ToString())
{
decimal currentBalance1 = accountRepository.GetBalanceAfter(transaction.CategoryId, transaction.Type, transaction.Amount,
transaction.Amount, ActionType.Delete).CurrentBalance1;
accountRepository.UpdataBalance(transaction.CategoryId, currentBalance1, conn, tx);
decimal currentBalance2 = accountRepository.GetBalanceAfter(transaction.AccountId, transaction.Type, transaction.Amount,
transaction.Amount, ActionType.Delete).CurrentBalance2;
accountRepository.UpdataBalance(transaction.AccountId, currentBalance2, conn, tx);
}
tx.Commit();
}
}
catch (Exception ex)
{
tx.Rollback();
throw ex;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dgBooks.Rows.Count > 0)
{
if (iTotalAmount > iPaymentWindow.ReceiveAmount)
{
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.PLEASE_ENTER_EXACT_PAYMENT_AMOUNT.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
return;
}
foreach (Model.Transaction oData in oMRecordList)
{
oMTransaction = new Model.Transaction();
oBook = new DataAccess.Book();
oMTransaction.PERSON_ID = oData.PERSON_ID;
oMTransaction.BOOK_ID = oData.BOOK_ID;
oMTransaction.BOOK_NO = oData.BOOK_NO;
oMTransaction.TITLE = oData.TITLE;
oMTransaction.SUBJECT = oData.SUBJECT;
oMTransaction.CATEGORY = oData.CATEGORY;
oMTransaction.AUTHOR = oData.AUTHOR;
oMTransaction.PUBLISH_DATE = oData.PUBLISH_DATE;
oMTransaction.ISBN_NUMBER = oData.ISBN_NUMBER;
oMTransaction.LOCATION = oData.LOCATION;
oMTransaction.BOOK_PRICE = oData.BOOK_PRICE;
oMTransaction.RENT_PRICE = oData.RENT_PRICE;
oMTransaction.DUE_INTEREST = oData.DUE_INTEREST;
oMTransaction.LD_INTEREST = oData.LD_INTEREST;
oMTransaction.TOTAL_QTY = oData.TOTAL_QTY;
oMTransaction.TOTAL_DAYS = oData.TOTAL_DAYS;
oMTransaction.ADDED_DATE = DateTime.Now.ToString("yyyy-MM-dd");
oMTransaction.ADDED_BY = eVariable.sUsername;
oMTransaction.TRANSACTION_NO = eVariable.sTransactionNo;
oBook.CheckOutBook(oMTransaction);
}
oFrmMsgBox = new frmMessageBox(eVariable.TransactionMessage.TRANSACTION_HAS_BEEN_SUCESSFULLY_SAVE.ToString().Replace("_", " "));
oFrmMsgBox.m_MessageType = frmMessageBox.MESSAGE_TYPE.INFO;
oFrmMsgBox.ShowDialog();
iPaymentWindow.clearText();
eVariable.ClearText(pnlMain);
dgBooks.Rows.Clear();
}
}
