public override void OnAuthorization(AuthorizationContext filterContext)
{
/*Create hasPermission string based on the requested controller
* name and action name in the format 'controllername-action'*/
string requiredPermission = String.Format("{0}-{1}",
filterContext.ActionDescriptor.ControllerDescriptor.ControllerName,
filterContext.ActionDescriptor.ActionName);
HttpContext content = HttpContext.Current;
do
{
if (content == null || content.Session["user"] == null)
{
break;
}
RBACUser requestingUser = (RBACUser)content.Session["user"];
if (!requestingUser.HasPermission(requiredPermission))
{
break;
}
base.OnAuthorization(filterContext);
return;
} while (false);
base.OnAuthorization(filterContext);
filterContext.Result = new RedirectToRouteResult(
new System.Web.Routing.RouteValueDictionary {
{ "action", "PermissionDenied" },
{ "controller", "Error" }
});
}
public ActionResult SaveIssRecSrcDest(IssRecSrcDest lSrcDestId)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("IssRecSrcDest_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
//var IfExit = _issRecSrcDestService.All().Where(x => x.ActionCtrl == lSrcDestId.ActionCtrl).ToList();
//if (IfExit.Count == 0)
//{
IssRecSrcDest issRecSrcDestAdd = new IssRecSrcDest();
issRecSrcDestAdd = lSrcDestId;
//select COUNT(srcdestId)from IssRecSrcDest
var srcDestId = _issRecSrcDestService.All().Select(x => x.SrcDestId).Count();
issRecSrcDestAdd.SrcDestId = (srcDestId + 1).ToString();
_issRecSrcDestService.Add(issRecSrcDestAdd);
_issRecSrcDestService.Save();
transaction.Complete();
//}
var ecode = 1;
return(Json(ecode, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult DeleteDynamicCaption(byte Id)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("DynamicCaption_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var IsDynaCap = _dynamiccapService.All().Where(x => x.Id == Id).FirstOrDefault();
if (IsDynaCap != null)
{
//For user branch table by Farhad
_dynamiccapService.Delete(IsDynaCap);
_dynamiccapService.Save();
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
return(Json("2", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult GetIssRecSrcDestByIdforEdit(string SrcDestId)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("IssRecSrcDest_Edit"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
try
{
IssRecSrcDest IssRecSrcDestName = new IssRecSrcDest();
var data = _issRecSrcDestService.All().ToList().FirstOrDefault(x => x.SrcDestId == SrcDestId);
if (data != null)
{
IssRecSrcDestName.SrcDestId = data.SrcDestId;
IssRecSrcDestName.SrcDestName = data.SrcDestName;
IssRecSrcDestName.Type = data.Type;
IssRecSrcDestName.ActionSub = data.ActionSub;
IssRecSrcDestName.ActionCtrl = data.ActionCtrl;
}
// return Json(new { GgName = GgName, GroupTypeId = GroupTypeId }, JsonRequestBehavior.AllowGet);
return(Json(IssRecSrcDestName, JsonRequestBehavior.AllowGet));
// return Json(JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteIssRecSrcDest(string SrcDestId)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("IssRecSrcDest_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var IsUserBr = _issRecSrcDestService.All().Where(x => x.SrcDestId == SrcDestId).FirstOrDefault();
if (IsUserBr != null)
{
//For user branch table by Farhad
_issRecSrcDestService.Delete(IsUserBr);
_issRecSrcDestService.Save();
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
return(Json("2", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateOpenBalance(OpenBal OpnBal)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("GL_OpenBal_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
var defAc = LoadDropDown.GetDefAc();
string eCode = "";
string isAsset = OpnBal.Accode.Substring(0, 1);
if (isAsset == defAc.AssAc)
{
OpnBal.OpenBalance = OpnBal.OpenBalance;
}
else if (isAsset == defAc.LiaAc)
{
OpnBal.OpenBalance = OpnBal.OpenBalance * (-1);
}
using (var transaction = new TransactionScope())
{
try
{
OpenBal UpOpnBal = new OpenBal();
UpOpnBal = _pR_OpenBalanceService.All().ToList().FirstOrDefault(x => x.Id == OpnBal.Id);
if (UpOpnBal != null)
{
OpnBal.FinYear = Session["FinYear"].ToString();
Misclns.CopyPropertiesTo(OpnBal, UpOpnBal);
_pR_OpenBalanceService.Update(UpOpnBal);
_pR_OpenBalanceService.Save();
var THolidayID = UpOpnBal.Id;
TransactionLogService.SaveTransactionLog(_transactionLogService, "OpenBal", "Update",
THolidayID.ToString(), Session["UserName"].ToString());
eCode = "1";
}
else
{
eCode = "2";
}
transaction.Complete();
return(Json(eCode, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult DeleteSecUserGroup(int GroupID)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("SecUserGroup_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var IsExist = _secUserGroupService.All().ToList().FirstOrDefault(x => x.GroupID == GroupID);
if (IsExist != null)
{
_secUserGroupService.Delete(IsExist);
_secUserGroupService.Save();
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult GetJournalVoucher(string pageType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptCash_VchrWaitingForPosting"))
{
string errMsg = "VWP";
return(RedirectToAction("CashMoneyReceipt", "CashMoneyReceipt", new { errMsg }));
}
string branchCode = Session["BranchCode"].ToString();
string sql = string.Format("select pvm.VchrNo,(select AcName from NewChart where Accode = pvd.Accode)as AcName,(select SubName "
+ "from SubsidiaryInfo where SubCode = pvd.sub_Ac) as SubSidiary, "
+ "pvd.Narration, pvd.Accode, pvd.CrAmount, pvd.DrAmount, pvm.Posted,pvm.VDate from PVchrMain as pvm "
+ "join PVchrDetail as pvd on pvm.VchrNo = pvd.VchrNo and pvm.FinYear = pvd.FinYear join JTrGrp as jt on pvm.VType = jt.VType where jt.TranGroup = '" + pageType + "'"
+ "and pvm.BranchCode= '" + branchCode + "'"
+ "group by pvm.VchrNo, pvm.BranchCode, pvm.Posted, pvm.VDate,pvd.Narration,pvd.Accode, pvd.CrAmount, pvd.DrAmount, pvd.sub_Ac");
List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
if (glReport.Count == 0)
{
string errMsg = "Data not found !!!";
return(RedirectToAction("CashMoneyReceipt", "CashMoneyReceipt", new { errMsg }));
}
else
{
ViewBag.branchCode = _branchService.All().ToList().FirstOrDefault(x => x.BranchCode == branchCode).BranchName;
return(View("~/Views/JournalVoucher/JournalVoucher.cshtml", glReport));
}
}
public ActionResult JobWiseRecPayPdf(string ProjCode, string BranchCode, string JobNo, string fDate, string tDate)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("RptJobWiseRecPay_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("JobWiseRecPay", "JobWiseRecPay", new { errMsg }));
}
if (BranchCode == null)
{
BranchCode = Session["BranchCode"].ToString();
}
ViewBag.fDate = InWord.GetAbbrMonthNameDate(Convert.ToDateTime(fDate));
ViewBag.tDate = InWord.GetAbbrMonthNameDate(Convert.ToDateTime(tDate));
string sql = string.Format("Exec rpt_JobRecPay '" + Session["FinYear"].ToString() + "','" + ProjCode + "','" + BranchCode + "','" + JobNo + "','" + Convert.ToDateTime(fDate).ToString("yyyy/MM/dd") + "','" + Convert.ToDateTime(tDate).ToString("yyyy/MM/dd") + "',''");
List <rptJobWiseVM> JobWiseRecPay = _JobWiseReportService.SqlQueary(sql).ToList();
Response.AppendHeader("Content-Disposition", "inline; filename= JobWiseIncExp" + DateTime.Now.ToShortDateString() + ".pdf");
return(new Rotativa.ViewAsPdf("JobWiseRecPayPdf", "", JobWiseRecPay)
{
PageOrientation = Rotativa.Options.Orientation.Portrait,
PageSize = Rotativa.Options.Size.A4,
//FileName = RptName + "-" + DateTime.Now.ToShortDateString() + ".pdf" , contStatementReportPdf
CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\""
});
}
public ActionResult GetGLEntries(DateTime date, string pageType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (pageType == "BOR")
{
if (!rUser.HasPermission("BankReceive_VchrList"))
{
string errMsg = "VL";
return(RedirectToAction("BankOperation", "BankOperation", new { errMsg }));
}
}
else if (pageType == "BOP")
{
if (!rUser.HasPermission("BankPayment_VchrList"))
{
string errMsg = "VL";
return(RedirectToAction("BankOperation", "BankOperation", new { errMsg }));
}
}
string branchCode = Session["BranchCode"].ToString();
string sql = string.Format("EXEC GLEntriesByDate '" + pageType + "', '" + date.ToString("MM-dd-yyyy") + "','" + branchCode + "'");
List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
if (glReport.Count == 0)
{
string errMsg = "Data not pound !!!";
return(RedirectToAction("BankOperation", "BankOperation", new { errMsg }));
}
else
{
ViewBag.glDate = date;
return(View("~/Views/CashOperation/GLEntres.cshtml", glReport));
}
}
public ActionResult PostCancel(string InvoiceNo, string CancelType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MRCancel"))
{
return(Json("C", JsonRequestBehavior.AllowGet));
}
string ReturnSTR = "";
using (AcclineERPContext dbContext = new AcclineERPContext())
{
var resultParameter = new SqlParameter("@ReturnMSG", SqlDbType.VarChar, 300)
{
Direction = ParameterDirection.Output
};
dbContext.Database.ExecuteSqlCommand("MRCancel @MRNo, @ReturnMSG out",
new SqlParameter("@MRNo", InvoiceNo),
resultParameter);
ReturnSTR = (string)resultParameter.Value;
TransactionLogService.SaveTransactionLog(_transactionLogService, "Cancel", "MRCancel",
InvoiceNo, Session["UserName"].ToString());
}
return(Json(ReturnSTR, JsonRequestBehavior.AllowGet));
}
public ActionResult GetGLEntries(DateTime date, string pageType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptCash_VchrList"))
{
string errMsg = "VL";
return(RedirectToAction("CashMoneyReceipt", "CashMoneyReceipt", new { errMsg }));
}
string branchCode = Session["BranchCode"].ToString();
string sql = string.Format("EXEC GLEntriesByDate '" + pageType + "', '" + date.ToString("MM-dd-yyyy") + "','" + branchCode + "'");
List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
if (glReport.Count == 0)
{
string errMsg = "Data not found !!!";
return(RedirectToAction("CashMoneyReceipt", "CashMoneyReceipt", new { errMsg }));
}
else
{
ViewBag.branchCode = _branchService.All().ToList().FirstOrDefault(x => x.BranchCode == branchCode).BranchName;
ViewBag.glDate = date;
return(View("~/Views/CashOperation/GLEntres.cshtml", glReport));
}
}
public ActionResult UpdateVM_TrDep(VM_TrDep VM_TrDep)
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("TreasuryChallan_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
string content = "An error occured during the update.";
var serializerSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string json = JsonConvert.SerializeObject(VM_TrDep, Formatting.Indented, serializerSettings);
HttpResponseMessage response = GlobalVariabls.VatApiClient.PutAsJsonAsync("VM_TrDep/PutVM_TrDep", VM_TrDep).Result;
content = response.StatusCode.ToString();
if (content == "OK")
{
TransactionLogService.SaveTransactionLog(_transactionLogService, "VM Treasury Challan", "Update", VM_TrDep.TrDepNo, Session["UserName"].ToString());
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteRateChart(int Id)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("GL_OpenBal_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var IsExist = _RateChartService.All().ToList().FirstOrDefault(x => x.RateChartId == Id);
if (IsExist != null)
{
_RateChartService.Delete(IsExist);
_RateChartService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "RateChart", "Delete",
Session["UserName"].ToString(), Session["FinYear"].ToString());
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveVM_Adjustment(VM_Adjustment VM_Adjustment)
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("VMAdjustment_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
string content = "An error occured during the save.";
var serSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string jsonCov = JsonConvert.SerializeObject(VM_Adjustment, Formatting.Indented, serSettings);
HttpResponseMessage response = GlobalVariabls.VatApiClient.PostAsJsonAsync("VM_Adjustment/PostVM_Adjustment", VM_Adjustment).Result;
content = response.StatusCode.ToString();
if (content == "OK")
{
TransactionLogService.SaveTransactionLog(_transactionLogService, "VDS Payment", "Save", VM_Adjustment.AdjNo, Session["UserName"].ToString());
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(ex.ToString(), JsonRequestBehavior.AllowGet));
}
}
public ActionResult SalesCollectionStatementRptPdf(DateTime fDate, DateTime tDate, string ProjCode, string BranchCode, string FinYear)
{
ViewBag.BranchName = "All";
if (BranchCode != "")
{
String BranchName = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault();
ViewBag.BranchName = BranchName;
}
var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(fDate), Convert.ToString(tDate), Session["FinYear"].ToString());
if (ChkFYR != "")
{
return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg = ChkFYR }));
}
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("SalesCollectionStatRpt_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("SecUserLogin", "SecUserLogin", new { errMsg }));
}
string customerGroup = "";
//rpt_SP_SalesCollectionStat_1 @fdate smalldatetime, @tdate smalldatetime, @ProjCode varchar(3), @BranchCode varchar(3),@FinYear varchar(7), @customerGroup varchar(7)
string sql = string.Format("EXEC rpt_SP_SalesCollectionStat_1 '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + ProjCode + "', '" + BranchCode + "', '" + FinYear + "','" + customerGroup + "' "); //,'" + Session["UserName"] + "'
//string sql = string.Format("EXEC rpt_SP_SalesCollectionStat_1 '" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + ProjCode + "', '" + BranchCode + "', '" + FinYear + "','"+ customerGroup +"'");
IEnumerable <SalesCollectionStat> VchrLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
VchrLst = dbContext.Database.SqlQuery <SalesCollectionStat>(sql).ToList();
}
ViewBag.BranchCode = _BranchService.All().Where(s => s.BranchCode == BranchCode).Select(x => x.BranchName).FirstOrDefault();
//ViewBag.fDate = fDate.ToString("dd-MMM-yyyy");
//ViewBag.tDate = tDate.ToString("dd-MMM-yyyy");
ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate);
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
//Response.AppendHeader("Content-Disposition", "inline; filename=" + RptName + "_" + DateTime.Now.ToShortDateString() + ".pdf");
return(new Rotativa.ViewAsPdf("rptSalesCollectionStatePdf", "", VchrLst)
{
PageOrientation = Rotativa.Options.Orientation.Portrait,
PageSize = Rotativa.Options.Size.A4,
CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\""
});
}
public ActionResult DeleteSelectedGroupData(int GroupID, int GroupTypeId)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Group_Delete"))
{
return(Json("D", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
if (GroupTypeId == 1)
{
var IsUserBr = _groupinfoService.All().Where(x => x.GroupID == GroupID).FirstOrDefault();
if (IsUserBr != null)
{
//For user branch table by Farhad
_groupinfoService.Delete(IsUserBr);
_groupinfoService.Save();
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
else if (GroupTypeId == 2)
{
var IsUserBr = _sgroupinfoService.All().Where(x => x.SGroupID == GroupID).FirstOrDefault();
if (IsUserBr != null)
{
//For user branch table by Farhad
_sgroupinfoService.Delete(IsUserBr);
_sgroupinfoService.Save();
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
else if (GroupTypeId == 3)
{
var IsUserBr = _ssgroupinfoService.All().Where(x => x.SSGroupID == GroupID).FirstOrDefault();
if (IsUserBr != null)
{
//For user branch table by Farhad
_ssgroupinfoService.Delete(IsUserBr);
_ssgroupinfoService.Save();
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
}
return(Json("2", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveSecUsrGroupInfo(SecUserGroup SecUsrGrp, string[] SecUsers)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("SecUserGroup_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
string eCode = "";
using (var transaction = new TransactionScope())
{
try
{
var UserGroup = _secUserGroupService.All().ToList().FirstOrDefault(x => x.GroupName == SecUsrGrp.GroupName);
if (UserGroup == null)
{
_secUserGroupService.Add(SecUsrGrp);
_secUserGroupService.Save();
if (SecUsers != null && SecUsers.Length > 0)
{
foreach (var user in SecUsers)
{
SecUserInGroup SuInGrp = new SecUserInGroup();
SuInGrp.GroupID = SecUsrGrp.GroupID;
SuInGrp.UserID = Convert.ToInt32(user);
_secUserInGroupService.Add(SuInGrp);
}
_secUserInGroupService.Save();
}
eCode = "1";
}
else
{
eCode = "2";
}
transaction.Complete();
return(Json(eCode, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveUserBranch(int UserID, List <Branch> Check)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("UserBranch_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
var IsExistBr = _userbranchService.All().Where(x => x.Userid == UserID.ToString()).ToList();
foreach (var data in IsExistBr)
{
_userbranchService.Delete(data);
_userbranchService.Save();
}
if (Check != null)
{
foreach (var data in Check)
{
if (Check.Count != 0)
{
List <UserBranch> userbranchList = new List <UserBranch>();
UserBranch userBranchAdd = new UserBranch();
userBranchAdd.BranchCode = data.BranchCode;
userBranchAdd.Userid = UserID.ToString();
userbranchList.Add(userBranchAdd);
_userbranchService.Add(userBranchAdd);
_userbranchService.Save();
}
//else
//{
//
//}
}
// transaction.Dispose();
// return Json("3", JsonRequestBehavior.AllowGet);
}
transaction.Complete();
//Check.Clear();
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateBankReceipt(BankReceipt bankReceipt)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("BankReceipt_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
List <BankOperationVModel> CashOPVM = new List <BankOperationVModel>();
var gset = _gsetService.All().LastOrDefault();
try
{
bankReceipt.BranchCode = Session["BranchCode"].ToString();
bankReceipt.FinYear = Session["FinYear"].ToString();
bankReceipt.bankAccode = Session["BankAccode"].ToString();
bankReceipt.NewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.purAccode.Trim());
bankReceipt.bankNewChart = _NewChartService.All().ToList().FirstOrDefault(x => x.Accode == bankReceipt.bankAccode.Trim());
using (var transaction = new TransactionScope())
{
try
{
_BankReceiptAppService.Update(bankReceipt);
_BankReceiptAppService.Save();
//delete to provision
//var entryNo = Convert.ToInt64(bankReceipt.VoucherNo.Substring(2, 8)).ToString().PadLeft(8, '0');
var entryNo = bankReceipt.BReceiptNo;
LoadDropDown.journalVoucherRemoval("BR", entryNo, bankReceipt.VoucherNo, bankReceipt.FinYear);
var sysSet = _sysSetService.All().FirstOrDefault();
if (sysSet.CashRule == "O")
{
LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString());
}
//insert to provision
LoadDropDown.journalVoucherSave("BR", "I", bankReceipt.BReceiptNo, bankReceipt.VoucherNo, bankReceipt.FinYear, "01", bankReceipt.BranchCode, bankReceipt.BReceiptDate, bankReceipt.bankAccode, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "Bank Receipt", "Update", bankReceipt.BReceiptNo, User.Identity.Name);
CashOPVM = GetAllRemittances(bankReceipt.BReceiptDate, bankReceipt.BranchCode, bankReceipt.bankAccode);
transaction.Complete();
}
catch (Exception)
{
transaction.Dispose();
}
}
return(Json(CashOPVM, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveItem(ItemInfo item)
{
//if (ModelState.IsValid)
//{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Item_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
var items = _ItemInfoService.All().ToList().FirstOrDefault(x => x.ItemCode == item.ItemCode && x.ItemName == item.ItemName);
if (items == null)
{
_ItemInfoService.Add(item);
ItemMap iM = new ItemMap();
iM.ItemTypeCode = (int)item.ItemType;
iM.GroupID = item.GroupID;
iM.SGroupID = item.SGroupID;
iM.SSGroupID = item.SSGroupID;
iM.ItemCode = item.ItemCode;
var serializerSettings = new JsonSerializerSettings {
PreserveReferencesHandling = PreserveReferencesHandling.Objects
};
string json = JsonConvert.SerializeObject(iM, Formatting.Indented, serializerSettings);
HttpResponseMessage response = GlobalVariabls.WebApiClient.PostAsJsonAsync("ItemMaps/PostItemMap", iM).Result;
_ItemInfoService.Save();
TransactionLogService.SaveTransactionLog(_transactionLogService, "Item", "Save", item.ItemCode, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Item already exists!!!", JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
//}
//else
//{
// return Json("0", JsonRequestBehavior.AllowGet);
//}
}
}
public static bool HasRole(this ControllerBase controller, string role)
{
bool bFound = false;
try {
//Check if the requesting user has the specified role...
bFound = new RBACUser(controller.ControllerContext.HttpContext.User.Identity.Name).HasRole(role);
}
catch { }
return(bFound);
}
public static bool IsSysAdmin(this ControllerBase controller)
{
bool bIsSysAdmin = false;
try {
//Check if the requesting user has the System Administrator privilege...
bIsSysAdmin = new RBACUser(controller.ControllerContext.HttpContext.User.Identity.Name).IsSysAdmin;
}
catch { }
return(bIsSysAdmin);
}
public static bool HasPermission(this ControllerBase controller, string permission)
{
bool bFound = false;
try {
//Check if the requesting user has the specified application permission...
bFound = new RBACUser(controller.ControllerContext.HttpContext.User.Identity.Name).HasPermission(permission);
}
catch { }
return(bFound);
}
public ActionResult GetCashBook(RptSearchVModel vmodel)
{
var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString());
if (ChkFYR != "")
{
return(RedirectToAction("Search", "CashBook", new { errMsg = ChkFYR }));
}
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("RptCashBook_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("Search", "CashBook", new { errMsg }));
}
Session["fDate"] = vmodel.fDate;
Session["tDate"] = vmodel.toDate;
string finyear = Session["FinYear"].ToString();
vmodel.BranchCode = (vmodel.BranchCode == "0") ? "" : vmodel.BranchCode;
Session["Branch"] = vmodel.BranchCode;
ViewBag.HasBranch = _sysSetService.All().FirstOrDefault().HasBranch;
if (vmodel.BranchCode != "" && vmodel.BranchCode != "0")
{
ViewBag.Branch = _BranchService.All().FirstOrDefault(x => x.BranchCode == vmodel.BranchCode.Trim()).BranchName.ToString();
}
else
{
ViewBag.Branch = "All";
}
string sql = string.Format("EXEC rptCashBook '" + finyear + "','" + Session["ProjCode"].ToString() + "','" + vmodel.BranchCode + "','" + vmodel.fDate.ToString("yyyy/MM/dd") + "','" + vmodel.toDate.ToString("yyyy/MM/dd") + "'");
List <CashBook> cashBook = _CashBookService.SqlQueary(sql).ToList();
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
if (cashBook.Count == 0)
{
string errMsg = "There is no data on this date. Please try another !!!";
return(RedirectToAction("Search", "CashBook", new { errMsg }));
}
else
{
ViewBag.Datef = InWord.GetAbbrMonthNameDate(vmodel.fDate);
ViewBag.Datet = InWord.GetAbbrMonthNameDate(vmodel.toDate);
return(View(cashBook));
}
}
public static List <REPORTS> GetReports(this ControllerBase controller)
{
List <REPORTS> _retVal = new List <REPORTS>();
try
{
//Check if the requesting user has the System Administrator privilege...
_retVal = new RBACUser(controller.ControllerContext.HttpContext.User.Identity.Name).GetReports();
}
catch { }
return(_retVal);
}
public JsonResult DeleteNode(string values, string IsTree)
{
try
{
string msg = "Deleted successfully";
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("ChartOfAccounts_Delete"))
{
msg = "No Delete Permission For This User !!";
return(Json(new { msg = msg }, JsonRequestBehavior.AllowGet));
}
var id = values.Split(',');
foreach (var item in id)
{
int ID = int.Parse(item);
var nChart = (from nc in _newChartService.All().ToList().Where(x => x.AcSyscode == ID)
select new
{
ParentCode = nc.ParentCode,
AcSyscode = nc.AcSyscode,
Accode = nc.Accode
}).FirstOrDefault();
var isVExist = _VchrDeatilService.All().ToList().Where(x => x.Accode == nChart.Accode).FirstOrDefault();
var isPvExist = _tVchrDeatailService.All().ToList().Where(x => x.Accode == nChart.Accode).FirstOrDefault();
var isTvExist = _pVchrDetailService.All().ToList().Where(x => x.Accode == nChart.Accode).FirstOrDefault();
var pCode = _newChartService.All().ToList().Where(x => x.ParentCode == ID).FirstOrDefault();
if (nChart.ParentCode != 0 && pCode == null && isVExist == null && isPvExist == null && isTvExist == null)
{
_newChartService.All().Where(x => x.AcSyscode == ID).ToList().ForEach(u => _newChartService.Delete(u));
_newChartService.Save();
}
else if (nChart.ParentCode != 0 && IsTree == "btnDeleteTree" && isVExist == null && isPvExist == null && isTvExist == null)
{
_newChartService.All().Where(x => x.AcSyscode == ID).ToList().ForEach(u => _newChartService.Delete(u));
_newChartService.Save();
}
else
{
msg = "The Selected Account Head isn't Deleteable!";
return(Json(new { msg }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { msg = msg }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, msg = ex }, JsonRequestBehavior.AllowGet));
}
}
public static bool HasRoles(this ControllerBase controller, string roles)
{
bool bFound = false;
try {
//Check if the requesting user has any of the specified roles...
//Make sure you separate the roles using ; (ie "Sales Manager;Sales Operator"
bFound = new RBACUser(controller.ControllerContext.HttpContext.User.Identity.Name).HasRoles(roles);
}
catch { }
return(bFound);
}
public static Guid UserId(this ControllerBase controller)
{
Guid _retVal = Guid.NewGuid();
try
{
//Check if the requesting user has the System Administrator privilege...
_retVal = new RBACUser(controller.ControllerContext.HttpContext.User.Identity.Name).User_Id;
}
catch { }
return(_retVal);
}
public ActionResult GetVoucherPreview(string VchrNo, string FinYear)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("RptVoucherPreview_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg }));
}
if (VchrNo != null)
{
var ledger = _LedgerCapService.All().ToList().FirstOrDefault(x => x.SP_Name == "rptVoucher");
ViewBag.RptCap = ledger.RptCap;
ViewBag.Col1Cap = ledger.Col1Cap;
ViewBag.Col2Cap = ledger.Col2Cap;
ViewBag.Col3Cap = ledger.Col3Cap;
ViewBag.Col4Cap = ledger.Col4Cap;
ViewBag.Col5Cap = ledger.Col5Cap;
ViewBag.Col6Cap = ledger.Col6Cap;
ViewBag.Col7Cap = ledger.Col7Cap;
string BranchCode = Session["BranchCode"].ToString();
ViewBag.Branch = _BranchService.All().Where(x => x.BranchCode == BranchCode.Trim()).Select(s => s.BranchName).ToString();
FinYear = Session["FinYear"].ToString();
string sql = string.Format("EXEC rptVoucher '" + FinYear + "','" + VchrNo + "'");
List <VchrPreviewVM> rptVchr = _VchrPreviewVMService.SqlQueary(sql).ToList();
//if (rptVchr.Count == 0)
//{
// string errMsg = "There is no data in this combination. Please try again !!!";
// return RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg });
//}
//else
//{
double amt = 0;
foreach (var item in rptVchr)
{
if (item.cramount != 0)
{
amt += item.cramount;
}
}
string InWordsamt = InWord.ConvertToWords(amt.ToString());
ViewBag.InWordsAmt = InWordsamt;
return(View(rptVchr));
//}
}
else
{
string errMsg = "Voucher no is required!";
return(RedirectToAction("SearchVoucher", "VchrPreview", new { errMsg }));
}
}
