public async Task <(bool IsTrue, string Msg)> ApproveAdmission(Admission admission)
{
using (_context)
{
using (var transaction = _context.Database.BeginTransaction())
{
_context.Entry(admission).State = EntityState.Modified;
StudentLedger studentLedger = new StudentLedger()
{
Title = "Account Opened",
Debit = 0,
Credit = 0,
Balance = 0,
IP = admission.IP,
Agent = admission.Agent,
Latitude = admission.Location,
Longitude = admission.Location,
StudentId = admission.StudentID
};
_context.StudentLedgers.Add(studentLedger);
try
{
await _context.SaveChangesAsync();
var Ledger = await _context.StudentLedgers.Where(x => x.StudentId == admission.StudentID).SingleOrDefaultAsync();
if (Ledger == null)
{
transaction.Rollback();
return(false, "Unable To Find Ledger");
}
else
{
StudentLedgerTransaction studentLedgerTransaction = new StudentLedgerTransaction()
{
Title = "Account Opened",
Debit = 0,
Credit = 0,
Balance = 0,
IP = admission.IP,
Agent = admission.Agent,
Latitude = admission.Location,
Longitude = admission.Location,
StudentLedgerId = Ledger.Id
};
_context.StudentLedgerTransactions.Add(studentLedgerTransaction);
await _context.SaveChangesAsync();
transaction.Commit();
return(true, Result.Success);
}
}
catch (Exception exc)
{
return(false, Error.GetDetail(exc));
}
}
}
}
public async Task <(bool IsTrue, string ResponseMsg)> Add(StudentLedger studentLedger)
{
_context.StudentLedgers.Add(studentLedger);
try
{
return(await _context.SaveChangesAsync() > 0, Result.Success);
}
catch (Exception exc)
{
return(false, Error.GetDetail(exc));
}
}
public static bool SameValue(this StudentLedger sl1, StudentLedger sl2)
{
return
(sl1.RecordId == sl2.RecordId &&
sl1.Source == sl2.Source &&
sl1.StudentId == sl2.StudentId &&
sl1.EventId == sl2.EventId &&
sl1.Week == sl2.Week &&
sl1.MarkId == sl2.MarkId &&
sl1.MinsLate == sl2.MinsLate &&
sl1.Comments == sl2.Comments &&
sl1.DateChange == sl2.DateChange &&
sl1.UserId == sl2.UserId);
}
public void Edit(StudentLedger entity)
{
StudentLedgerDAL dalObject = new StudentLedgerDAL();
dalObject.Edit(entity);
}
public void Add(StudentLedger entity)
{
StudentLedgerDAL dalObject = new StudentLedgerDAL();
dalObject.Add(entity);
}
private void init()
{
#region Insert Test Data of Ledger
studentLedger = new Dictionary <int, StudentLedger>();
//StudentNo 1.
var Ledger = new List <LedgerInfo>();
// Enter Valid Data
var ledger1 = new LedgerInfo
{
StudentNo = 1,
Student = "Alex",
TransDate = new DateTime(10, 02, 05, 09, 15, 00, 000),
Transaction = "Payment Test 1",
Debit = 150.00,
Credit = 00.00
};
Ledger.Add(ledger1);
// Enter Valid Data
var ledger2 = new LedgerInfo
{
StudentNo = 1,
Student = "Alex",
TransDate = new DateTime(10, 03, 05, 09, 15, 00, 000),
Transaction = "Payment Test 2",
Debit = 350.00,
Credit = 00.00
};
Ledger.Add(ledger2);
// Enter Valid Data
var ledger3 = new LedgerInfo
{
StudentNo = 1,
Student = "Alex",
TransDate = new DateTime(10, 04, 05, 11, 15, 00, 000),
Transaction = "Payment Test 3",
Debit = 0.00,
Credit = 400.00
};
Ledger.Add(ledger3);
// Enter Valid Data
var ledger4 = new LedgerInfo
{
StudentNo = 1,
Student = "Alex",
TransDate = new DateTime(10, 06, 03, 09, 35, 00, 000),
Transaction = "Payment Test 4",
Debit = 510.00,
Credit = 00.00
};
Ledger.Add(ledger4);
// Enter Valid Data
var ledger5 = new LedgerInfo
{
StudentNo = 1,
Student = "Alex",
TransDate = new DateTime(10, 07, 05, 09, 15, 00, 000),
Transaction = "Payment Test 5",
Debit = 0.00,
Credit = 200.00
};
Ledger.Add(ledger5);
// Enter Valid Data
var ledger6 = new LedgerInfo
{
StudentNo = 1,
Student = "Alex",
TransDate = new DateTime(10, 02, 20, 09, 15, 00, 000),
Transaction = "Payment Test 6",
Debit = 0.00,
Credit = 325.00
};
Ledger.Add(ledger6);
var LedgerDetail = new StudentLedger(Ledger);
studentLedger.Add(1, LedgerDetail);
//StudentNo 2.
Ledger = new List <LedgerInfo>();
for (int i = 0; i < 4; i++)
{
// Enter Valid Data
ledger1 = new LedgerInfo
{
StudentNo = 2,
Student = "Ben",
TransDate = new DateTime(10, 02, 05, 09, 15, 00, 000),
Transaction = "Payment Test " + i,
Debit = 150.00,
Credit = 00.00
};
Ledger.Add(ledger1);
}
LedgerDetail = new StudentLedger(Ledger);
studentLedger.Add(2, LedgerDetail);
#endregion
}