public long MakeTransaction(TransInput forTrans)
{
Transaction trans = new Transaction();
var AddMov2TransInfo = DatabaseUtils.Instance();
string trans2MovIdQuery = $"SELECT MAX(`TRANS2MOV_TRANS_ID`) FROM transactions2movies;";
int transID = SqlGetMappingId(trans2MovIdQuery);
string addMov2TransInfoQuery =
$"INSERT INTO {DatabaseUtils.Databasename}.transactions2movies (TRANS2MOV_TRANS_ID,TRANS2MOV_MOV_ID) " +
$"VALUES ";
foreach (var movId in forTrans.MovieList)
{
addMov2TransInfoQuery += $"({transID},{movId.Id})";
if (movId.Id != forTrans.MovieList[forTrans.MovieList.Count - 1].Id)
{
addMov2TransInfoQuery += ", ";
}
else
{
addMov2TransInfoQuery += ";";
}
}
if (AddMov2TransInfo.MakeDbQuery(addMov2TransInfoQuery))
{
trans.TransId = transID;
trans.Date = DateTime.Now.ToString("yyyy-MM-dd");
trans.EmpId = forTrans.EmployeeId;
trans.Fees = 0;
trans.FeesPaid = forTrans.LateFeePaid;
trans.PymtCard = forTrans.PaymentCard;
trans.PymtType = forTrans.PaymentType;
trans.RemBalance = 0;
int runningCost = 0;
foreach (var movieCost in forTrans.MovieList)
{
runningCost += movieCost.Cost;
}
trans.TotalPaid = runningCost + trans.FeesPaid;
trans.CustId = forTrans.CustomerId;
string newTransQuery =
$"INSERT INTO {DatabaseUtils.Databasename}.transactions(TRANS_ID, TRANS_Date, TRANS_Employee, TRANS_Fees, TRANS_Fees_Paid, TRANS_Total_Paid, TRANS_Rem_Balance, TRANS_Cust_ID, TRANS_Payment_Type) " +
$"VALUES('{trans.TransId}', '{trans.Date}', '{trans.EmpId}', '{trans.Fees}', '{trans.FeesPaid}', '{trans.TotalPaid}', '{trans.RemBalance}', '{trans.CustId}', '{trans.PymtType}');";
if (AddMov2TransInfo.MakeDbQuery(newTransQuery))
{
foreach (var movId in forTrans.MovieList)
{
string updateMovieStatusQuery = $"UPDATE {DatabaseUtils.Databasename}.movieinfo " +
$"SET MOV_STATUS = 1, MOV_STATUS_DATE = \"{movId.DueDate}\" " +
$"WHERE MOV_INFO_UNIQ_ID = {movId.Id};";
if (!AddMov2TransInfo.MakeDbQuery(updateMovieStatusQuery))
{
return(-1);
}
}
}
return(trans.TransId);
}
return(-1);
}