private void savebutton_Click(object sender, EventArgs e)
{
Store aStore = new Store();
StoreDAO aStoreDao = new StoreDAO();
aStore = aStoreDao.GetStoreByItemId(ItemId);
Transaction1 aTransaction1 = new Transaction1();
aTransaction1.ItemName = aStore.ItemName;
aTransaction1.TransactionType = transactiontypelebel.Text;
aTransaction1.Amount = Convert.ToDouble(quantitytextBox.Text) * aStore.UnitPrice;
aTransaction1.Quantity = Convert.ToDouble(quantitytextBox.Text);
aTransaction1.ItemUnit = aStore.Unit;
aTransaction1.CauseOrPurpose = purposeTextBox.Text.Trim();
aStore.Quantity -= Convert.ToDouble(quantitytextBox.Text);
if (aStore.Quantity >= 0)
{
aStoreDao.InsertTransaction(aTransaction1, CategoryId);
string sr = aStoreDao.UpdateStore(aStore);
MessageBox.Show(sr);
if (sr == "Insert Sucessfully")
{
this.Close();
}
}
else
{
MessageBox.Show("Not Enough quantity");
}
}
private Transaction1 ReadToOrderTotalforProfit(IDataReader oReader)
{
Transaction1 aTransaction1 = new Transaction1();
try
{
if (oReader["Order Date-Time"] != DBNull.Value)
{
aTransaction1.Date = new DateTime(Int64.Parse(oReader["Order Date-Time"].ToString())).Date;
}
}
catch (Exception)
{
}
try
{
if (oReader["Total Paid(Inc. Vat)"] != DBNull.Value)
{
aTransaction1.Amount = Convert.ToDouble(oReader["Total Paid(Inc. Vat)"].ToString());
}
//Total Paid(Inc. Vat)
}
catch (Exception)
{
}
return(aTransaction1);
}
public IActionResult Create(IndexView model)
{
Transaction1 newTransaction = model.bank_transaction;
newTransaction.user_id = model.user_transaction.user_id;
model.user_transaction = _context.users
.Include(u => u.transactions)
.SingleOrDefault(user => user.user_id == newTransaction.user_id);
_context.transactions.Add(newTransaction); // here you are adding the new Transaction 'newTransaction' to the transactions table in mysql
newTransaction.current_balance = model.user_transaction.transactions.Sum(u => u.transaction_amount);
_context.SaveChanges();
return(RedirectToAction("Index", "Transaction1", new { id = newTransaction.user_id }));
}
private Transaction1 ReadToTransactionforProfit(IDataReader aReader)
{
Transaction1 aTransaction1 = new Transaction1();
try
{
aTransaction1.Date = Convert.ToDateTime(aReader["date"]);
}
catch (Exception)
{ }
try
{
aTransaction1.Amount = Convert.ToDouble(aReader["amount"]);
}
catch (Exception)
{ }
return(aTransaction1);
}
public void InsertOtherTransaction(Transaction1 aTransaction1, int categoryId)
{
try
{
DateTime aDateTime = DateTime.Now.Date;
this.OpenConnection();
string sqlComm = string.Format(SqlQueries.GetQuery(Query.InsertOtherTransaction), aTransaction1.ItemName,
aTransaction1.Quantity, aTransaction1.ItemUnit, aTransaction1.Amount,
aTransaction1.SupplierName, aTransaction1.TransactionType, aDateTime, categoryId, aTransaction1.CauseOrPurpose);
this.ExecuteNonQuery(sqlComm);
}
catch (Exception ex)
{
//throw new Exception(ex.ToString());
}
finally
{
this.CloseConnection();
}
}
//Payment
public IActionResult Payment(string paymethod)
{
TempData["paymethod"] = paymethod;
Bookings1 booking = new Bookings1();
booking.Uid = TempData["Uid"] != null ? (int)TempData["Uid"] : 7;
booking.Cid = (int)TempData["Cid"];
booking.Hid = (int)TempData["Hid"];
booking.StartDate = (DateTime)TempData["StartDate"];
booking.EndDate = (DateTime)TempData["EndDate"];
booking.GuestCount = (int)TempData["GuestCount"];
_db.Bookings1s.Add(booking);
_db.SaveChanges();
TempData["BookingId"] = _db.Bookings1s.Max(c => c.BookingId);
Transaction1 transaction = new Transaction1
{
BookingId = (int)TempData["BookingId"],
TransactionDate = DateTime.Today,
Amount = "150",
Paymethod = (string)TempData["Paymethod"]
};
_db.Transaction1s.Add(transaction);
_db.SaveChanges();
TempData["Amount"] = transaction.Amount;
int total_amount;
if ((string)TempData["Type"] == "king")
{
total_amount = 180 * (int)TempData["Room"];
}
else
{
total_amount = 220 * (int)TempData["Room"];
}
TempData["Total_Amount"] = total_amount;
return(View());
}
private void savebutton_Click(object sender, System.EventArgs e)
{
Store aStore = new Store();
StoreDAO aStoreDao = new StoreDAO();
aStore = aStoreDao.GetStoreByItemId(ItemId);
Transaction1 aTransaction1 = new Transaction1();
aTransaction1.ItemName = aStore.ItemName;
aTransaction1.TransactionType = "Purchase";
aTransaction1.SupplierName = supplierNamecomboBox.Text;
aTransaction1.Amount = Convert.ToDouble(amounttextBox.Text);
aTransaction1.Quantity = Convert.ToDouble(quantitytextBox.Text);
aTransaction1.ItemUnit = aStore.Unit;
aStoreDao.InsertTransaction(aTransaction1, CategoryId);
double newstore = aStore.Amount + Convert.ToDouble(amounttextBox.Text);
double newquantity = aStore.Quantity + Convert.ToDouble(quantitytextBox.Text);
double unitprice = 0;
if (newquantity != 0)
{
unitprice = (newstore / newquantity);
}
else
{
unitprice = 0;
}
aStore.UnitPrice = unitprice;
aStore.Quantity = newquantity;
string sr = aStoreDao.UpdateStore(aStore);
MessageBox.Show(sr);
if (sr == "Insert Sucessfully")
{
this.Close();
}
}
public List <Transaction1> showAllData(long startDate, long endDate)
{
List <Transaction1> aTransactions = new List <Transaction1>();
//CResult oResult = new CResult();
//CSearchOrderInfo oOrderInfo = new CSearchOrderInfo();
try
{
this.OpenConnection();
string sqlCommand = "";
sqlCommand = String.Format(SqlQueries.GetQuery(Query.GetOrderInfo), startDate.ToString(), endDate.ToString());
//this.ExecuteNonQuery(sqlCommand);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
Transaction1 aTransaction1 = new Transaction1();
aTransaction1 = ReadToOrderTotalforProfit(oReader);
aTransactions.Add(aTransaction1);
}
}
//oResult.Data = oOrderInfo;
//oResult.IsSuccess = true;
}
catch (Exception ex)
{
}
finally
{
this.CloseConnection();
}
return(aTransactions);
}
public List <Transaction1> EmployeeTransactionReportBydate(DateTime fromDate, DateTime toDate)
{
List <Transaction1> aTransactions = new List <Transaction1>();
try
{
this.OpenConnection();
string sqlComm = string.Format(SqlQueries.GetQuery(Query.EmployeeTransactionReportBydate), fromDate, toDate);
IDataReader aReader = this.ExecuteReader(sqlComm);
if (aReader != null)
{
while (aReader.Read())
{
Transaction1 aTransaction1 = new Transaction1();
aTransaction1 = ReadToTransactionforProfit(aReader);
aTransactions.Add(aTransaction1);
}
}
}
catch (Exception)
{
}
return(aTransactions);
}
private Transaction1 ReadToTransaction(IDataReader aReader)
{
Transaction1 aTransaction1 = new Transaction1();
try
{
aTransaction1.TransactionId = Convert.ToInt32(aReader["transaction_id"]);
}
catch (Exception)
{}
try
{
aTransaction1.ItemName = (aReader["item_name"]).ToString();
}
catch (Exception)
{ }
try
{
aTransaction1.SupplierName = (aReader["supplier"]).ToString();
}
catch (Exception)
{ }
try
{
aTransaction1.TransactionType = (aReader["transaction_type"]).ToString();
}
catch (Exception)
{ }
try
{
aTransaction1.Amount = Convert.ToDouble(aReader["amount"]);
}
catch (Exception)
{ }
try
{
aTransaction1.Quantity = Convert.ToDouble(aReader["quantity"]);
}
catch (Exception)
{ }
try
{
aTransaction1.ItemUnit = (aReader["unit"]).ToString();
}
catch (Exception)
{ }
try
{
aTransaction1.Date = Convert.ToDateTime(aReader["date"]);
}
catch (Exception)
{ }
try
{
aTransaction1.CauseOrPurpose = (aReader["Purpose"]).ToString();
}
catch (Exception)
{ }
return(aTransaction1);
}