public ActionResult GetBankAccntDTable()
{
BankAccountsModel model = new BankAccountsModel();
List <BankAccntList> getBankAccntList = new List <BankAccntList>();
var SQLQuery = "SELECT [BankAccntID] , Tbl_FMBank_Banks.BankTitle, [AccntNo],[AccntName],[Tbl_FMCOA_GeneralAccount].GATitle,CONCAT(Tbl_FMCOA_AccountGroup.AGCode , '-', Tbl_FMCOA_MajorAccountGroup.MAGCode, '-', Tbl_FMCOA_SubMajorAccountGroup.SMAGCode , '-', Tbl_FMCOA_GeneralAccount.GACode) as concatCode,Tbl_FMBank_AccountType.AccntType,Tbl_FMFund_Fund.FundTitle FROM [Tbl_FMBank_BankAccounts], Tbl_FMBank_AccountType, Tbl_FMBank_Banks, Tbl_FMCOA_GeneralAccount, Tbl_FMFund_Fund, Tbl_FMCOA_SubMajorAccountGroup, Tbl_FMCOA_MajorAccountGroup, Tbl_FMCOA_AccountGroup where Tbl_FMFund_Fund.FundID = [Tbl_FMBank_BankAccounts].FundID and Tbl_FMBank_AccountType.AccntTypeID = [Tbl_FMBank_BankAccounts].AccntTypeID and Tbl_FMCOA_GeneralAccount.GAID = [Tbl_FMBank_BankAccounts].GAID and Tbl_FMBank_Banks.BankID = [Tbl_FMBank_BankAccounts].BankID and Tbl_FMCOA_SubMajorAccountGroup.SMAGID = Tbl_FMCOA_GeneralAccount.SMAGID and Tbl_FMCOA_MajorAccountGroup.MAGID = Tbl_FMCOA_SubMajorAccountGroup.MAGID and Tbl_FMCOA_AccountGroup.AGID = Tbl_FMCOA_MajorAccountGroup.AGID";
using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
{
Connection.Open();
using (SqlCommand command = new SqlCommand("[dbo].[SP_Banks]", Connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
getBankAccntList.Add(new BankAccntList()
{
BankAccntID = GlobalFunction.ReturnEmptyInt(dr[0]),
BankTitle = GlobalFunction.ReturnEmptyString(dr[1]),
AccntNo = GlobalFunction.ReturnEmptyString(dr[2]),
AccntName = GlobalFunction.ReturnEmptyString(dr[3]),
GATitle = GlobalFunction.ReturnEmptyString(dr[4]),
concatCode = GlobalFunction.ReturnEmptyString(dr[5]),
AccntType = GlobalFunction.ReturnEmptyString(dr[6]),
FundTitle = GlobalFunction.ReturnEmptyString(dr[7])
});
}
}
Connection.Close();
}
model.getBankAccntList = getBankAccntList.ToList();
return(PartialView("BankAccountsTab/_TableBankAccount", getBankAccntList));
}
public ActionResult onchangeGACode(int GAID, BankAccountsModel model)
{
var genAccnt = (from a in BOSSDB.Tbl_FMCOA_GeneralAccount where a.GAID == GAID select a).FirstOrDefault();
var passCon = "";
if (genAccnt == null)
{
passCon = "";
}
else
{
var subMajAccntGrp = (from a in BOSSDB.Tbl_FMCOA_SubMajorAccountGroup where a.SMAGID == genAccnt.SMAGID select a).FirstOrDefault();
var majAccntGrp = (from a in BOSSDB.Tbl_FMCOA_MajorAccountGroup where a.MAGID == subMajAccntGrp.MAGID select a).FirstOrDefault();
var accntGrp = (from a in BOSSDB.Tbl_FMCOA_AccountGroup where a.AGID == majAccntGrp.AGID select a).FirstOrDefault();
if (accntGrp != null)
{
passCon = (accntGrp.AGCode + "-" + majAccntGrp.MAGCode + "-" + subMajAccntGrp.SMAGCode + "-" + genAccnt.GACode);
}
}
var result = new { passCon = passCon };
return(Json(result, JsonRequestBehavior.AllowGet));
}
public IActionResult Index()
{
if (!string.IsNullOrEmpty(HttpContext.Session.GetString("token")))
{
HttpClient httpClient = new HttpClient();
httpClient.BaseAddress = new Uri("http://207.154.196.92:5002/");
httpClient.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", HttpContext.Session.GetString("token"));
HttpResponseMessage response = httpClient.GetAsync("api/transaction").Result;
string responseBody = response.Content.ReadAsStringAsync().Result;
if (string.IsNullOrEmpty(responseBody))
{
HttpContext.Session.SetString("token", "");
return(RedirectToAction("Index", "Home"));
}
JObject responseJson = JsonConvert.DeserializeObject(responseBody) as JObject;
TransactionsModel transactionsModel = JsonConvert.DeserializeObject <TransactionsModel>(responseBody);
UserModel userModel = new UserModel();
response = httpClient.GetAsync("api/BankAccount").Result;
responseBody = response.Content.ReadAsStringAsync().Result;
responseJson = JsonConvert.DeserializeObject(responseBody) as JObject;
BankAccountsModel bankAccounts = JsonConvert.DeserializeObject <BankAccountsModel>(responseBody);
HomePageModel homePageModel = new HomePageModel();
userModel.Token = HttpContext.Session.GetString("token");
userModel.TC = HttpContext.Session.GetString("tc");
userModel.FirstName = HttpContext.Session.GetString("firstName");
userModel.LastName = HttpContext.Session.GetString("lastName");
userModel.PhoneNumber = HttpContext.Session.GetString("phoneNumber");
userModel.CustomerNo = Convert.ToInt32(HttpContext.Session.GetString("no"));
transactionsModel.transactions = transactionsModel.transactions.OrderBy(x => x.date).ToList();
bankAccounts.BankAccounts = bankAccounts.BankAccounts.OrderBy(x => x.No).ToList();
homePageModel.TransactionsModel = transactionsModel;
homePageModel.UserModel = userModel;
homePageModel.BankAccountsModel = bankAccounts;
return(View("dashboard", homePageModel));
}
HttpContext.Session.Clear();
return(View());
}
public ActionResult GetBankAccntForm(int ActionID, int PrimaryID)
{
BankAccountsModel model = new BankAccountsModel();
if (ActionID == 2)
{
var bank = (from a in BOSSDB.Tbl_FMBank_BankAccounts where a.BankAccntID == PrimaryID select a).FirstOrDefault();
model.BankAccntList.AccntNo = bank.AccntNo;
model.BankAccntList.AccntName = bank.AccntName;
model.BankAccntList.BankID = Convert.ToInt32(bank.BankID);
model.BankAccntList.FundID = Convert.ToInt32(bank.FundID);
model.BankAccntList.GAID = Convert.ToInt32(bank.GAID);
model.BankAccntList.AccntTypeID = Convert.ToInt32(bank.AccntTypeID);
model.BankAccntList.BankAccntID = bank.BankAccntID;
}
model.ActionID = ActionID;
return(PartialView("BankAccountsTab/_BankAccountForm", model));
}
public ActionResult SaveBankAccnt(BankAccountsModel model)
{
var isExist = "";
if (ModelState.IsValid)
{
var accntname = model.BankAccntList.AccntName;
var bankid = model.BankAccntList.BankID;
var accntnumber = model.BankAccntList.AccntNo;
Tbl_FMBank_BankAccounts checkbankaccnt = (from a in BOSSDB.Tbl_FMBank_BankAccounts where (a.AccntNo == accntnumber) select a).FirstOrDefault();
if (model.ActionID == 1)
{
if (checkbankaccnt == null)
{
Tbl_FMBank_BankAccounts BankAccnt = new Tbl_FMBank_BankAccounts();
BankAccnt.AccntName = accntname;
BankAccnt.AccntNo = accntnumber;
BankAccnt.BankID = bankid;
BankAccnt.FundID = model.BankAccntList.FundID;
BankAccnt.GAID = model.BankAccntList.GAID;
BankAccnt.AccntTypeID = model.BankAccntList.AccntTypeID;
BOSSDB.Tbl_FMBank_BankAccounts.Add(BankAccnt);
BOSSDB.SaveChanges();
isExist = "false";
}
else if (checkbankaccnt != null)
{
isExist = "true";
}
}
else if (model.ActionID == 2)
{
Tbl_FMBank_BankAccounts bankTypii = (from a in BOSSDB.Tbl_FMBank_BankAccounts where a.BankAccntID == model.BankAccntList.BankAccntID select a).FirstOrDefault();
if (checkbankaccnt != null)
{
if (bankTypii.AccntNo == accntnumber && bankTypii.BankAccntID == model.BankAccntList.BankAccntID)
{
isExist = "justUpdate";
}
else
{
isExist = "true";
}
}
else if (checkbankaccnt == null)
{
isExist = "justUpdate";
}
if (isExist == "justUpdate")
{
bankTypii.AccntName = accntname;
bankTypii.AccntNo = accntnumber;
bankTypii.BankID = bankid;
bankTypii.FundID = model.BankAccntList.FundID;
bankTypii.GAID = model.BankAccntList.GAID;
bankTypii.AccntTypeID = model.BankAccntList.AccntTypeID;
bankTypii.BankAccntID = model.BankAccntList.BankAccntID;
BOSSDB.Entry(bankTypii);
BOSSDB.SaveChanges();
}
}
}
return(new JsonResult()
{
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
Data = new { isExist = isExist }
});
}
