public ActionResult GetJournalVoucher(DateTime date, string pageType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("Sales_VchrWaitingForPosting"))
{
string errMsg = "VWP";
return(RedirectToAction("Sales", "Sales", new { errMsg }));
}
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 + "' "
+ "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 !!!";
//ViewBag.msg = errMsg;
return(RedirectToAction("Sales", "Sales", new { errMsg }));
}
else
{
ViewBag.glDate = date;
return(View("~/Views/JournalVoucher/JournalVoucher.cshtml", glReport));
}
}
public ActionResult GetNewVoucherNo(string VType)
{
string finYear = Session["FinYear"].ToString();
string voucherNo = "";
//string VLen = "";
var VLen = _sysSetService.All().ToList().FirstOrDefault().VchrLen.ToString();
string sql = string.Format("exec [GetNewVoucherNo] '" + VType + "','" + Session["BranchCode"].ToString() + "','" + VLen + "','" + Session["UserName"].ToString() + "','" + finYear + "'");
voucherNo = Convert.ToString(_jarnalVoucherService.SqlQueary(sql).ToList().FirstOrDefault().VchrNo.ToString());
return(Json(voucherNo, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPaymentByPayNo(string payNo)
{
string sql = string.Format("Select pvt.VchrMainId as VNo from PVchrTrack as pvt inner join PVchrMain as pvm on pvt.VchrMainId=pvm.PVchrMainId where EntryNo='" + payNo + "' and EntrySource='BP'");
List <JarnalVoucher> IsExit = _jarnalVoucherService.SqlQueary(sql).ToList();
var payment = _paymentService.All().FirstOrDefault(x => x.PayCode == payNo.Trim());
if (payment != null && IsExit.Count != 0)
{
return(Json(payment, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetHORBYRemitNo(string remitNo)
{
string sql = string.Format("Select pvt.VchrMainId as VNo from PVchrTrack as pvt inner join PVchrMain as pvm on pvt.VchrMainId=pvm.PVchrMainId where EntryNo='" + remitNo + "' and EntrySource='RT'");
List <JarnalVoucher> IsExit = _jarnalVoucherService.SqlQueary(sql).ToList();
var hoRemit = _hoRemitService.All().FirstOrDefault(x => x.RemitNo == remitNo.Trim());
if (hoRemit != null && IsExit.Count != 0)
{
return(Json(hoRemit, JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public string Counter(string VType)
{
string branchCode = Session["BranchCode"].ToString();
string countNo = "";
string sql = string.Format("SELECT COUNT(*) as NO FROM PVchrMain where VType='" + VType + "' and BranchCode='" + branchCode + "'");
List <JarnalVoucher> Number = _jarnalVoucherService.SqlQueary(sql).ToList();
if (Number.Count == 0)
{
countNo = "0";
}
else
{
countNo = Number.FirstOrDefault().NO.ToString();
}
return(countNo);
}
public ActionResult GetJournalVoucher(string pageType)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (pageType == "BOR")
{
if (!rUser.HasPermission("BankReceive_VchrWaitingForPosting"))
{
string errMsg = "VWP";
return(RedirectToAction("BankOperation", "BankOperation", new { errMsg }));
}
}
else if (pageType == "BOP")
{
if (!rUser.HasPermission("BankPayment_VchrWaitingForPosting"))
{
string errMsg = "VWP";
return(RedirectToAction("BankOperation", "BankOperation", new { errMsg }));
}
}
string branchCode = Session["BranchCode"].ToString();
string sql = string.Format("select pvd.PVchrDetailId, 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 left outer join JTrGrp as jt on pvm.VType = jt.VType where jt.TranGroup = '" + pageType + "' and pvm.BranchCode ='" + Session["BranchCode"].ToString() + "'"
+ "and pvm.BranchCode= '" + branchCode + "'"
+ "group by pvd.PVchrDetailId, pvm.VchrNo, pvm.BranchCode, pvm.Posted, pvm.VDate,pvd.Narration,pvd.Accode, pvd.CrAmount, pvd.DrAmount, pvd.sub_Ac order by pvd.PVchrDetailId");
List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
if (glReport.Count == 0)
{
string errMsg = "Data not pound !!!";
return(RedirectToAction("BankOperation", "BankOperation", new { errMsg }));
}
else
{
return(View("~/Views/JournalVoucher/JournalVoucher.cshtml", glReport));
}
}
public ActionResult GetGLEntries(RptSearchVModel vmodel)
{
var ChkFYR = GetCompanyInfo.ValidateFinYearDateRange(Convert.ToString(vmodel.fDate), Convert.ToString(vmodel.toDate), Session["FinYear"].ToString());
if (ChkFYR != "")
{
return(RedirectToAction("Search", "ListOfTransaction", new { errMsg = ChkFYR }));
}
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("RptJournalVoucher_Preview"))
{
string errMsg = "No Preview Permission for this User !!";
return(RedirectToAction("Search", "ListOfTransaction", new { errMsg }));
}
string finyear = Session["FinYear"].ToString();
Session["Branch"] = vmodel.BranchCode;
Session["LedgerType"] = vmodel.LedgerTypeCode;
Session["fDate"] = vmodel.fDate;
Session["tDate"] = vmodel.toDate;
Session["Data"] = vmodel.JTrGrpId;
ViewBag.fDate = InWord.GetAbbrMonthNameDate(vmodel.fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(vmodel.toDate);
if (vmodel.JTrGrpId == null)
{
vmodel.JTrGrpId = "";
}
// Session["NullData"] = vmodel.JTrGrpId = "";
string sql = string.Format("EXEC rptListTran '" + finyear + "','01','" + vmodel.BranchCode + "','" + vmodel.JTrGrpId.Trim() + "','" + vmodel.fDate.ToString("MM-dd-yyyy") + "','" + vmodel.toDate.ToString("MM-dd-yyyy") + "'");
List <JarnalVoucher> glReport = _jarnalVoucherService.SqlQueary(sql).ToList();
// Session["Data"] = glReport;
//if (glReport.Count == 0)
//{
// string errMsg = "Data not found !!!";
// return RedirectToAction("Search", "ListOfTransaction", new { errMsg });
//}
//else
//{
double amt = 0;
List <JarnalVoucher> sList = new List <JarnalVoucher>(); //InWord.ConvertToWords(amt.ToString()).ToList();
foreach (var item in glReport)
{
//if (item.CrAmount != 0)
// {
if (item.DrAmount > 0)
{
amt = item.DrAmount;
}
else if (item.CrAmount > 0)
{
amt = item.CrAmount;
}
JarnalVoucher sAmt = new JarnalVoucher();
sAmt.ACCode = item.ACCode;
sAmt.VDate = item.VDate;
sAmt.AcName = item.AcName;
sAmt.InWords = InWord.ConvertToWords(amt.ToString());
sAmt.AcName = item.AcName;
sAmt.Narration = item.Narration;
sAmt.SubSidiary = item.SubSidiary;
sAmt.CrAmount = item.CrAmount;
sAmt.DrAmount = item.DrAmount;
sAmt.VchrNo = item.VchrNo;
sAmt.Posted = item.Posted;
sAmt.Sub_Ac = item.Sub_Ac;
sList.Add(sAmt);
// }
}
return(View("~/Views/ListOfTransaction/TransactionList.cshtml", sList));
//}
}
