public DataTableSuccessMessage LoanAccounts()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string name = HttpContext.Current.Request.Form["searchName"];
string lduration = HttpContext.Current.Request.Form["searchLDuration"];
string ptype = HttpContext.Current.Request.Form["searchPType"];
string searchAddress = HttpContext.Current.Request.Form["searchBranch"];
var loan =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <ILoanAccountDb>()
.PagedSearchByNameAndAcctNumber(name, lduration, ptype, searchAddress, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
loan.Select(
y =>
new
{
ID = y.Id,
ACctName = y.AccountName,
ACctNo = y.AccountNumber,
AcctType = Enum.GetName(typeof(AccountType), y.LinkedAccount.AccountType),
AMnt = y.LoanAmount,
Duration = y.LoanDuration,
Interest = y.LoanInterest,
BAlance = y.Balance,
StartDate = y.LoanStartDate,
DueDate = y.LoanDueDate,
PaymentType = Enum.GetName(typeof(PaymentSchedule), y.PaymentSchedule),
NoOFDays = y.NumberOfDays,
Status = Enum.GetName(typeof(LoanStatus), y.LoanStatus)
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage TellerPosting()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string searchAccountName = HttpContext.Current.Request.Form["searchCustomerAccountName"];
string searchTillAccountName = HttpContext.Current.Request.Form["searchTillAccountName"];
string searchAccountNumber = HttpContext.Current.Request.Form["searchAccountNumber"];
DateTime searchDate = Convert.ToDateTime(HttpContext.Current.Request.Form["searchDate"]);
var tellerPosting =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <ITellerPostingDb>()
.PagedSearchByAccountNameAndAccountNumber(searchAccountName, searchTillAccountName, searchAccountNumber, searchDate, start, length,
out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
tellerPosting.Select(
y =>
new
{
ID = y.Id,
TRansactionDate = y.TransactionDate,
CustomerAccountName = y.CustomerAccounts.AccountName,
CustomerAccountNumber = y.CustomerAccounts.AccountNumber,
TillAccountName = y.GlAccount.GlAccountName,
PostingType = Enum.GetName(typeof(PostingType), y.PostingType),
NArration = y.Narration,
AMount = y.Amount
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage GlPosting()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string searchGlName = HttpContext.Current.Request.Form["searchGLName"];
string searchCode = HttpContext.Current.Request.Form["searchGLCode"];
////string searchDate = HttpContext.Current.Request.Form["searchDate"];
var glPosting =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <IGlPostingDb>()
.PagedSearchByGLNameAndCode(searchGlName, searchCode, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
glPosting.Select(
y =>
new
{
ID = y.Id,
ActualDate = y.DateAdded,
TRansactionDate = y.TransactionDate,
DebitAccountName = y.GlAccountToDebit.GlAccountName,
DebitAccountCode = y.GlAccountToDebit.GlAccountCodes,
CreditAccountName = y.GlAccountToCredit.GlAccountName,
CreditAccountCode = y.GlAccountToCredit.GlAccountCodes,
DEbitNarration = y.DebitNarration,
CReditNarration = y.CreditNarration,
AMount = y.Amount
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage GlAccount()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string searchGlName = HttpContext.Current.Request.Form["searchGLName"];
string searchGlCode = HttpContext.Current.Request.Form["searchGLCode"];
string searchGlBranch = HttpContext.Current.Request.Form["searchGLBranch"];
string searchCategory = HttpContext.Current.Request.Form["searchCategory"];
var glAccount =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <IGlAccountDb>()
.PagedSearchByGLNameAndCategory(searchGlName, searchGlCode, searchGlBranch, searchCategory, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
glAccount.Select(
y =>
new
{
ID = y.Id,
AccountName = y.GlAccountName,
AccountCode = y.GlAccountCodes,
Category = y.GlCategory.GlCategoryName,
Branch = y.Branch.BranchName,
BAlance = y.Balance,
Edit =
@"<button type='button' onclick=""edit('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">Edit</button>"
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage CustomerAccounts()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string name = HttpContext.Current.Request.Form["searchName"];
string searchAddress = HttpContext.Current.Request.Form["searchAddress"];
var customers =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <ICustomerAccountsDb>()
.PagedSearchByFirstNameAndLastName(name, searchAddress, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
customers.Select(
y =>
new
{
ID = y.Id,
FIRSTName = y.FirstName,
LASTName = y.LastName,
OTHERNames = y.OtherNames,
EMail = y.Email,
GENder = y.Gender.ToString(),
AddAccounts =
@"<button type='button' onclick=""Redirect('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">Add Account</button>"
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage Users()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string searchfName = HttpContext.Current.Request.Form["searchFName"];
string searchlName = HttpContext.Current.Request.Form["searchLName"];
string searchbranch = HttpContext.Current.Request.Form["searchBranch"];
var users =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <IUserDb>()
.PagedSearchByNameAndBranch(searchfName, searchlName, searchbranch, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
users.Select(
y =>
new
{
ID = y.Id,
Fname = y.FirstName,
LName = y.LastName,
URole = y.UserRole.ToString(),
BRanch = y.Branch.BranchName,
ViewDetails =
@"<button type='button' onclick=""viewDetails('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">View Details</button>"
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage OnUsWithdrawal()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string searchName = HttpContext.Current.Request.Form["searchName"];
string searchId = HttpContext.Current.Request.Form["searchName"];
string searchLocation = HttpContext.Current.Request.Form["searchCode"];
var terminals =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <IOnUsWithdrawalDb>()
.PagedSearchByName_IDAndLocation(searchName, searchId, searchLocation, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
terminals.Select(
y =>
new
{
ID = y.Id,
TerminalName = y.Name,
TerminaLID = y.TerminalID,
ViewDetails =
@"<button type='button' onclick=""viewDetails('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">View Details</button>"
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
public DataTableSuccessMessage GlCategory()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string name = HttpContext.Current.Request.Form["searchName"];
string glcategory = HttpContext.Current.Request.Form["searchGlAcctCategory"];
var glCategory =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <IGlCategoryDb>()
.PagedSearchByNameAndGlAcctCategory(name, glcategory, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
result.data =
glCategory.Select(
y =>
new
{
ID = y.Id,
GLCATEGORYName = y.GlCategoryName,
MAINACCOUNTCategory = y.MainAccountCategory.ToString(),
ViewDetails =
@"<button type='button' onclick=""viewDetails('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">View Details</button>"
}).ToArray();
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}
//public DataTableSuccessMessage CustomerLoanAccount()
//{
// try
// {
// int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
// int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
// int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
// int total;
// //string search = HttpContext.Current.Request.Form["search[value]"];
// string searchAccountNumber = HttpContext.Current.Request.Form["searchAccountNumber"];
// string searchAccountName = HttpContext.Current.Request.Form["searchAccountName"];
// var customersAccounts =
// Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance<ICustomerAccountDb>()
// .PagedSearchByAccountNameAndAccountNumber(searchAccountName, searchAccountNumber, start, length,
// out total);
// //add button
// var result = new DataTableSuccessMessage();
// result.draw = draw;
// result.recordsFiltered = customersAccounts.Count;
// result.recordsTotal = total;
// result.data =
// customersAccounts.Select(
// y =>
// new
// {
// ID = y.Id,
// AccountNumber = y.AccountNumber,
// AcccountName = y.CustomerAccountName,
// AccountType = y.AccountType.ToString(),
// Branch = y.Branch.Name,
// Balance = y.Balance,
// LinkToLoanAccount =
// @"<button type='button' onclick=""linkAccount('" + y.Id +
// @"');"" class=""btn btn-info btn-xs"">Link Account to Loan</button>"
// }).ToArray();
// return result;
// }
// catch (Exception ex)
// {
// return new DataTableSuccessMessage()
// {
// error = ex.Message
// };
// }
//}
public DataTableSuccessMessage CustomerAccountForView()
{
try
{
int draw = Convert.ToInt32(HttpContext.Current.Request.Form["draw"]);
int start = Convert.ToInt32(HttpContext.Current.Request.Form["start"]);
int length = Convert.ToInt32(HttpContext.Current.Request.Form["length"]);
int total, querytotal;
//string search = HttpContext.Current.Request.Form["search[value]"];
string name = HttpContext.Current.Request.Form["searchName"];
string type = HttpContext.Current.Request.Form["searchType"];
string branch = HttpContext.Current.Request.Form["searchBranch"];
string searchAccountNumber = HttpContext.Current.Request.Form["searchAddress"];
var customerAccount =
Microsoft.Practices.ServiceLocation.ServiceLocator.Current.GetInstance <ICustomerAccountsDb>()
.PagedSearchByNameAndAccountNumber(name, type, branch, searchAccountNumber, start, length, out querytotal, out total);
//add button
var result = new DataTableSuccessMessage();
result.draw = draw;
result.recordsFiltered = querytotal;
result.recordsTotal = total;
for (int i = 0; i < customerAccount.Count; i++)
{
if (customerAccount[i].IsClosed)
{
result.data =
customerAccount.Select(
y =>
new
{
ID = y.Id,
ACCountNumber = y.AccountNumber,
ACCountName = y.AccountName,
ACCountType = y.AccountType.ToString(),
BAlance = y.Balance,
ViewDetails =
@"<button type='button' onclick=""viewDetails('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">View Details</button>",
CloseAccount = y.IsClosed ?
@"<button type='button' id ='close' disabled='disabled' class =""btn btn-danger btn-xs"">Closed</button>"
: @"<button type='button' onclick=""closeAccount('" + y.Id +
@"');"" class=""status-" +
y.Id + @" btn btn-danger btn-xs"">Close Account</button>",
OpenAccount = y.IsClosed == false ?
@"<button type='button' disabled='disabled' class =""btn btn-info btn-xs"">Open</button>"
: @"<button type='button' onclick=""openAccount('" + y.Id +
@"');"" class=""status-" +
y.Id + @" btn btn-info btn-xs"">Open Account</button>"
//@"<button type='button' onclick=""closeAccount('" + y.Id +
//@"');"" class=""status-" +
//y.Id + @" btn btn-danger btn-xs"">Closed</button>"
}).ToArray();
}
// $('.status-' + id).html('Closed').addClass('btn-danger').removeClass('btn-info');
else
{
result.data =
customerAccount.Select(
y =>
new
{
ID = y.Id,
ACCountNumber = y.AccountNumber,
ACCountName = y.AccountName,
ACCountType = y.AccountType.ToString(),
BAlance = y.Balance,
ViewDetails =
@"<button type='button' onclick=""viewDetails('" + y.Id +
@"');"" class=""btn btn-info btn-xs"">View Details</button>",
CloseAccount = y.IsClosed ?
@"<button type='button' disabled='disabled' class =""btn btn-danger btn-xs"">Closed</button>"
: @"<button type='button' onclick=""closeAccount('" + y.Id +
@"');"" class=""status-" +
y.Id + @" btn btn-danger btn-xs"">Close Account</button>",
OpenAccount = y.IsClosed == false ?
@"<button type='button' disabled='disabled' class =""btn btn-info btn-xs"">Open</button>"
: @"<button type='button' onclick=""openAccount('" + y.Id +
@"');"" class=""status-" +
y.Id + @" btn btn-info btn-xs"">Open Account</button>"
//CloseAccount =
// @"<button type='button' onclick=""closeAccount('" + y.Id +
// @"');"" class=""status-" +
// y.Id + @" btn btn-danger btn-xs"">Close Account</button>"
}).ToArray();
}
}
return(result);
}
catch (Exception ex)
{
return(new DataTableSuccessMessage()
{
error = ex.Message
});
}
}