public IEnumerable <PaymentTransaction> RetrieveDataPayment(string username, int?tahun, int?tahun2)
{
string allNop = string.Empty;
DataTable dt = new DataTable();
dt = UserTransactionData.RetrieveAllNopByUsername(username);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
allNop += "'" + item["NOP"].ToString() + "'" + ",";
}
allNop = allNop.Remove(allNop.Length - 1);
}
return(UserTransactionData.RetrieveDataPayment(allNop, tahun, tahun2).AsEnumerable <PaymentTransaction>());
}
public ActionResult LogIn(string uname, string pwd)
{
pwd = pwd.Replace("\"", string.Empty);
bool logincheck = false;
string DecryptKey = Convert.ToString(ConfigurationManager.AppSettings["DecryptKey"]);
pwd = MvcHelper.CodeDecrypt(pwd.Trim(), DecryptKey.Trim());
string ErrorMsg = string.Empty; string Action = string.Empty; string cntrlr = string.Empty, groupname = string.Empty, pages = string.Empty;
tbl_UserDetail user = new tbl_UserDetail();
UserTransactionData utobj = new UserTransactionData();
ADManager AdObj = new ADManager();
logincheck = AdObj.ChcekLogin(uname, pwd, ref groupname);
//user = MvcHelper.GetUser(uname, pwd, ref pages);
//if (user != null)
//{
// logincheck = true;
// groupname = user.UserGroup;
//}
if (logincheck)
{
if (!string.IsNullOrEmpty(groupname))
{
user = new tbl_UserDetail()
{
AccountName = uname,
UserGroup = groupname,
};
user.GroupPages = MvcHelper.GetGroupPages(groupname);
//int check = utobj.CheckMachineAvailable(System.Net.Dns.GetHostEntry(Request.UserHostAddress).HostName);
//if (check == 1)
//{
//Session["Machine"] = System.Net.Dns.GetHostEntry(Request.UserHostAddress).HostName;
MvcHelper.SaveUser(user);
Action = "index"; cntrlr = "Dashboard";
// }
//else
//{
// ErrorMsg = "Sorry...!!! Multiple user login is not allowed.";
//}
}
else
{
ErrorMsg = "User type is not authorized for the dashboard...!";
}
}
else
{
ErrorMsg = "Wrong credential...!";
}
if (!string.IsNullOrEmpty(ErrorMsg))
{
TempData["invalidmsg"] = ErrorMsg;
return(RedirectToAction("LogIn"));
}
else
{
Session["User"] = user;
return(RedirectToAction(Action, cntrlr));
}
}
public IEnumerable <PaymentTransaction> GetChartDataBeforeAdjustment(string username, int year)
{
return(UserTransactionData.GetChartDataBeforeAdjustment(username, year).AsEnumerable <PaymentTransaction>());
}
public IEnumerable <VwGeneratePayment> RetrieveDataPayment(string username, string nop, int month, int year)
{
return(UserTransactionData.RetrieveDataPayment(username, nop, month, year).AsEnumerable <VwGeneratePayment>());
}
public IEnumerable <PaymentTransaction> RetrieveDataPayment(string username, int?tahun2)
{
return(UserTransactionData.RetrieveDataPayment(username, tahun2).AsEnumerable <PaymentTransaction>());
}
public bool UpdatePajakUserTransaction(string username, string nop, DateTime tanggal, double pajak)
{
return(UserTransactionData.UpdatePajakUserTransaction(username, nop, tanggal, pajak));
}
public IEnumerable <RekapTransaction> RetrieveRekapResultWp(string username)
{
return(UserTransactionData.RetrieveRekapResultWp(username).AsEnumerable <RekapTransaction>());
}
public IEnumerable <UserTransaction> RetrieveUserTransactionByMonth(string username, string nop, int monthTransaction, int yearTransaction)
{
return(UserTransactionData.RetrieveUserTransactionByMonth(username, nop, monthTransaction, yearTransaction).AsEnumerable <UserTransaction>());
}
public IEnumerable <UserTransaction> RetrieveUserTransactionByDateTransaction(string nop, DateTime tglTransaksi)
{
return(UserTransactionData.RetrieveUserTransactionByDateTransaction(nop, tglTransaksi).AsEnumerable <UserTransaction>());
}
public List <UserTransaction> RetrieveUserTransactionByNop(string nop, DateTime tglTransaction)
{
return(UserTransactionData.RetrieveUserTransactionByNop(nop, tglTransaction).AsEnumerable <UserTransaction>().ToList());
}
public List <UserTransactionWithJenisPajak> RetrieveUserTransactionBetweenDate(DateTime tglAwal, DateTime tglAkhir)
{
return(UserTransactionData.RetrieveUserTransactionBetweenDate(tglAwal, tglAkhir).AsEnumerable <UserTransactionWithJenisPajak>().ToList());
}
public List <UserTransaction> RetrieveUserTransaction(string username, DateTime tglTransaction)
{
return(UserTransactionData.RetrieveUserTransaction(username, tglTransaction).AsEnumerable <UserTransaction>().ToList());
}
public bool InsertUserTransactionWithFile(string username, DateTime transactionDate, double taxAmount, string ipAddress,
string note, bool isAdjustment, string nop, byte[] file)
{
return(UserTransactionData.InsertUserTransaction(username, transactionDate, taxAmount, note, isAdjustment, ipAddress, nop, file));
}
public static ViewTransactionModel GetTransactionData(string ID, string SolvedBy, string userid, string utype)
{
BNKModel db = new BNKModel();
//List<tbl_EJData> Ejobj = db.tbl_EJData.Where(x => x.RecordTS == TransactionTs.Date && x.AccountNumber == AccountNo && x.CardNumber == CardNo).ToList();
//List<tbl_DisputeData> DisputeObj = db.tbl_DisputeData.Where(x => x.Incident_Date == TransactionTs.Date && x.AccountNumber == AccountNo && x.CardNumber == CardNo).ToList();
UserTransactionData userTransactionData = new UserTransactionData();
ViewTransaction v = userTransactionData.GetViewTransactionDetail(ID, SolvedBy, userid, utype);
ViewModelClass.ViewTransactionModel Vobj = new ViewModelClass.ViewTransactionModel();
string decryptKey = Convert.ToString(ConfigurationManager.AppSettings["DecryptKey"]);
try
{
Vobj.FeedBackId = v.FeedBackId;
Vobj.CustomerName = v.CustomerName;
Vobj.RegMobileNumber = (!string.IsNullOrEmpty(v.RegMobileNumber) ? (CodeDecrypt(v.RegMobileNumber, decryptKey)) : string.Empty);
Vobj.EJID = long.Parse(string.IsNullOrEmpty(v.EJID) ? "0" : v.EJID);
Vobj.Recordts = v.Recordts;
Vobj.AccountNumber = (!string.IsNullOrEmpty(v.AccountNumber) ? (CodeDecrypt(v.AccountNumber, decryptKey)) : string.Empty);
Vobj.CardNumber = (!string.IsNullOrEmpty(v.CardNumber) ? (CodeDecrypt(v.CardNumber, decryptKey)) : string.Empty);
Vobj.RegEmailId = (!string.IsNullOrEmpty(v.RegEmailId) ? (CodeDecrypt(v.RegEmailId, decryptKey)) : string.Empty);
Vobj.Amount = v.Amount;
Vobj.Counterfeit_Amount = v.Counterfeit_Amount;
Vobj.Cash_Retracted_Amount = v.Cash_Retracted_Amount;
Vobj.TerminalID = v.TerminalID;
Vobj.DeviceId = v.DeviceId;
Vobj.BotStatus = v.BotStatus;
Vobj.User_Action = v.User_Action;
Vobj.User_Recommendation = v.User_Recommendation;
Vobj.Maker_Input = v.Maker_Input;
Vobj.Checker_Input = v.Checker_Input;
Vobj.MakerComment = v.MakerComment;
Vobj.MakerComment_Hold = v.MakerComment_Hold;
Vobj.TransactionType = v.TransactionType;
Vobj.IsLocked = v.IsLocked;
Vobj.SubmitEnable = v.SubmitEnable;
if (!string.IsNullOrEmpty(Vobj.FeedBackId) || !string.IsNullOrEmpty(Vobj.TerminalID))
{
var BalanceAmountList = GetBalanceList(string.Empty, string.Empty, Vobj.TerminalID, string.Empty);
if (BalanceAmountList.Count > 1)
{
ViewBalancingModel AtmBalaceModel = BalanceAmountList.Where(x => x.TerminalType.ToUpper().Contains("ATM")).FirstOrDefault();
ViewBalancingModel CdmBalaceModel = BalanceAmountList.Where(x => x.TerminalType.ToUpper().Contains("CDM")).FirstOrDefault();
Vobj.ATMBalancingAmount = ((Convert.ToInt64(AtmBalaceModel.AmontFromEJ)) - (Convert.ToInt64(AtmBalaceModel.AmountFromT24))).ToString();
Vobj.CDMBalancingAmount = ((Convert.ToInt64(CdmBalaceModel.AmontFromEJ)) - (Convert.ToInt64(CdmBalaceModel.AmountFromT24))).ToString();
}
else
{
foreach (var item in BalanceAmountList)
{
if (item.TerminalType.ToUpper().Contains("ATM"))
{
Vobj.ATMBalancingAmount = ((Convert.ToInt64(item.AmontFromEJ)) - (Convert.ToInt64(item.AmountFromT24))).ToString();
}
else
{
Vobj.CDMBalancingAmount = ((Convert.ToInt64(item.AmontFromEJ)) - (Convert.ToInt64(item.AmountFromT24))).ToString();
}
}
}
}
return(Vobj);
}
catch (Exception ex)
{
return(Vobj = new ViewTransactionModel());
}
}
public ActionResult NewViewTransaction(string Comment, string UserAction, string CommentHold, string ID, string SolvedBy, string EjID, string feedbackid, string SubmitEnable, string back, string Submit)
{
if (Session["User"] == null)
{
return(RedirectToAction("LogIn", "LogIn"));
}
if (((tbl_UserDetail)Session["User"]).GroupPages.Contains("Report"))
{
try
{
ViewModelClass.ViewTransactionModel transactionData = new ViewModelClass.ViewTransactionModel();
var searchobj = (ViewModelClass.ViewReportSeachDataModel)TempData["SearchDetail"];
if (!string.IsNullOrEmpty(SolvedBy))
{
TempData["Sovedby"] = SolvedBy.Trim();
}
List <string> T24ImageUrls = new List <string>();
List <string> WeCareImageUrls = new List <string>();
tbl_UserDetail user = (tbl_UserDetail)Session["User"];
if (!string.IsNullOrEmpty(back)) //Back Button Clicked...............................
{
if (user.UserGroup != Constants.UserGroups.Admin)
{
string solvedby = Convert.ToString(TempData["Sovedby"]);
if (SubmitEnable.ToLower() == "y")
{
solvedby = TempData["Sovedby"].ToString();
UserTransactionData userTransactionData1 = new UserTransactionData();
if (solvedby.Trim().ToLower() == "reactive")
{
userTransactionData1.MakerOrCheckerBack(feedbackid, solvedby, user.UserGroup);
}
else if (!string.IsNullOrEmpty(EjID) && EjID != "0")
{
userTransactionData1.MakerOrCheckerBack(EjID, solvedby, user.UserGroup);
}
}
}
return(RedirectToAction("NewReportUserWise", new
{
startDate = searchobj.startDate,
endDate = searchobj.endDate,
ddlUserList = searchobj.ddlUserList,
terminaldId = searchobj.terminaldId,
status = searchobj.status,
reportType = searchobj.reportType,
searchobj
}));
}
else if (!string.IsNullOrEmpty(Submit) && (!user.UserGroup.Equals(Constants.UserGroups.Admin))) //Save user input....................................
{
string solvedby = Convert.ToString(TempData["Sovedby"]);
if (!string.IsNullOrEmpty(solvedby))
{
if (solvedby.ToLower() == "reactive")
{
MvcHelper.SaveUserInput(long.Parse(feedbackid), solvedby, Comment, UserAction, CommentHold, user.UserGroup);
}
else
{
MvcHelper.SaveUserInput(long.Parse(EjID), solvedby, Comment, UserAction, CommentHold, user.UserGroup);
}
}
return(RedirectToAction("NewReportUserWise", new
{
startDate = searchobj.startDate,
endDate = searchobj.endDate,
ddlUserList = searchobj.ddlUserList,
terminaldId = searchobj.terminaldId,
status = searchobj.status,
reportType = searchobj.reportType,
searchobj
}));
}
else
{
UserTransactionData userTransactionData = new UserTransactionData();
transactionData = MvcHelper.GetTransactionData(ID, SolvedBy, user.AccountName, user.UserGroup);
transactionData.T24ImageUrls = userTransactionData.GetT24ImageUrls(transactionData.EJID.ToString());
transactionData.WeCareImageUrls = userTransactionData.GetWCImageUrls(transactionData.FeedBackId);
ViewBag.obj = transactionData;
return(View());
}
}
catch (Exception ex)
{
return(View());
}
}
else
{
Session.Abandon();
return(RedirectToAction("Error", "ErrorPage"));
}
}
public ActionResult NewReportUserWise(DateTime?startDate, DateTime?endDate, string ddlUserList, string terminaldId, string status, string reportType, string download)
{
if (Session["User"] == null)
{
return(RedirectToAction("LogIn", "LogIn"));
}
//if (!((tbl_UserDetail)Session["User"]).UserGroup.Equals(Constants.UserGroups.ParameterManager))
if (((tbl_UserDetail)Session["User"]).GroupPages.Contains("Report"))
{
try
{
tbl_UserDetail user = (tbl_UserDetail)Session["User"];
List <UserDetails> transactionlist = new List <UserDetails>();
UserTransactionData userTransactionData = new UserTransactionData();
if (!string.IsNullOrEmpty(reportType) && reportType.Trim() == "Maximum Dispute Raising Machine")
{
ViewBag.MaxDisputeMachine = userTransactionData.GetMaxDisputedMachine(startDate, endDate, reportType, user.AccountName, user.UserGroup);
}
else if (!string.IsNullOrEmpty(reportType) && reportType.Trim() == "Maximum Complaint Raising Customer")
{
var maxdispute = userTransactionData.GetMaxDisputedCustomer(startDate, endDate, reportType, user.AccountName, user.UserGroup);
MvcHelper.DecryptMaxDisputeObj(ref maxdispute);
ViewBag.MaxDisputeCustomer = maxdispute;
}
else if (!string.IsNullOrEmpty(reportType) && reportType.Trim() == "User Wise Transactions")
{
ddlUserList = (ddlUserList.Contains(',') ? ddlUserList.Split(',')[0] : ddlUserList);
transactionlist = ViewBag.ReportData = userTransactionData.GetTransactionDataList(startDate, endDate, terminaldId, status, reportType, ddlUserList, user.UserGroup);
}
else
{
transactionlist = ViewBag.ReportData = userTransactionData.GetTransactionDataList(startDate, endDate, terminaldId, status, reportType, user.AccountName, user.UserGroup);
}
if (!string.IsNullOrEmpty(download))
{
string sheetname = "Report" + DateTime.Now;
FormattoExcel(transactionlist, sheetname);
}
if (!string.IsNullOrEmpty(ddlUserList) && ddlUserList != "0")
{
tbl_UserDetail objuser = MvcHelper.UserDetail(ddlUserList.Trim());
ddlUserList = objuser.AccountName + "," + objuser.AccountName;
}
ViewBag.SearchDetail = new ViewModelClass.ViewReportSeachDataModel()
{
endDate = (endDate != null ? (Convert.ToDateTime(endDate).ToString("dd-MMM-yyyy")) : ""),
startDate = (startDate != null ? (Convert.ToDateTime(startDate).ToString("dd-MMM-yyyy")) : ""),
terminaldId = terminaldId,
reportType = reportType,
ddlUserList = ddlUserList,
status = status
};
ViewBag.UserList = MvcHelper.UserList();
}
catch (Exception ex)
{
}
return(View());
}
else
{
Session.Abandon();
return(RedirectToAction("Error", "ErrorPage"));
}
}
