public List <BusinessUserExceptionalRoleViewModel> getAllBusinessCashierWithExceptionalRoleByBN(int BN, string srvcTCD)
{
List <BusinessUserExceptionalRoleViewModel> items = new List <BusinessUserExceptionalRoleViewModel>();
var busUsrCashierList = db.TBUS_USR_EXCP_ROL.Where(x => x.BN == BN && x.TRANS_TRSF_CRDT_DBT_TCD == srvcTCD).ToList();
if (busUsrCashierList.Count() == 0)
{
return(items);
}
foreach (var itemCashier in busUsrCashierList)
{
var excpAuthModel = new BusinessUserExceptionalRoleViewModel();
excpAuthModel.busUsrExcpRole = itemCashier;
var busAgcy = new BusinessAgency();
var agcy = busAgcy.getOneBusinessAgencyByAgcyNbr(itemCashier.BN, itemCashier.BUS_AGCY_NBR);
if (agcy != null)
{
excpAuthModel.BUS_USR_AGCY_NM = agcy.BUS_AGCY_NM;
}
var busUsr = db.TBUS_USR.Find(itemCashier.BUS_USR_NBR);
if (busUsr != null)
{
var usr = db.TUSR.Find(busUsr.BUS_EMPE_USR_NBR);
if (usr != null)
{
excpAuthModel.BUS_USR_FUL_NM = usr.USR_FUL_NM;
}
}
items.Add(excpAuthModel);
}
return(items);
}
public BusinessAgency createBusinessAgency(int BN, int KTCT_ID, int ACCT_ID, string busAgcyNM, string headQrtr,
string hasInternetIND, decimal maxToWD, decimal maxAV, string hourDESC,
string BUS_AGCY_NO_SRVC_AV_IND)
{
var newObj = new BusinessAgency();
newObj.BN = BN;
newObj.BUS_AGCY_NBR = generateBusinessAgencyCode(BN);
newObj.BUS_AGCY_NM = busAgcyNM;
newObj.BUS_AGCY_KTCT_ID = KTCT_ID;
newObj.BUS_AGCY_HDQRTR_IND = headQrtr;
newObj.BUS_AGCY_ACCT_ID = ACCT_ID;
newObj.BUS_AGCY_INTRNT_CHK_IND = hasInternetIND;
newObj.BUS_AGCY_MXAMT_TO_WDRW_AMT = maxToWD;
newObj.BUS_AGCY_AV_AMT = maxAV;
newObj.BUS_AGCY_OPNNG_HR = hourDESC;
newObj.BUS_AGCY_NO_SRVC_AV_IND = BUS_AGCY_NO_SRVC_AV_IND;
return(newObj);
}
public List <SelectListItem> getAllBusinessUserByBN(int BN, int selectedValue)
{
List <SelectListItem> items = new List <SelectListItem>();
var busUsrList = db.TBUS_USR.Where(x => x.BN == BN && x.BUS_USR_SCD == "1").ToList();
foreach (var item in busUsrList)
{
var usr = usrObj.getUserByUsrNbr(item.BUS_EMPE_USR_NBR);
if (usr != null)
{
string text;
if (item.BUS_USR_TCD == "04")
{
text = usr.USR_FUL_NM + " - Manager";
}
else if (item.BUS_USR_TCD == "03")
{
var busAgcy = new BusinessAgency();
var obj = busAgcy.getOneBusinessAgencyByAgcyNbr(item.BN, item.BUS_AGCY_NBR);
if (obj == null)
{
text = usr.USR_FUL_NM + " - Director";
}
else
{
text = usr.USR_FUL_NM + " - Director - " + obj.BUS_AGCY_NM;
}
}
else if (item.BUS_USR_TCD == "02")
{
var busAgcy = new BusinessAgency();
var obj = busAgcy.getOneBusinessAgencyByAgcyNbr(item.BN, item.BUS_AGCY_NBR);
if (obj == null)
{
text = usr.USR_FUL_NM + " - Cashier";
}
else
{
text = usr.USR_FUL_NM + " - Cashier" + obj.BUS_AGCY_NM;
}
}
else
{
text = usr.USR_FUL_NM;
}
if (item.BUS_USR_NBR == selectedValue)
{
items.Add(new SelectListItem {
Text = text, Value = Convert.ToString(item.BUS_USR_NBR), Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = text, Value = Convert.ToString(item.BUS_USR_NBR), Selected = false
});
}
}
}
return(items);
}