public JsonResult GetProductInfo(int ID)
{
SourceMastersModel SM1 = new SourceMastersModel();
var Product = SM1.GetProductById(ID);
return(Json(Product, JsonRequestBehavior.AllowGet));
}
public ActionResult Home()
{
//
List <int> RoleId = (List <int>)Session["RoleID"];
int roleid = RoleId[0];
if (roleid == 1)
{
var Query = (from t in db.Menus where t.IsAccountMenu.Value == false && t.RoleID == null orderby t.MenuOrder select t).ToList();
Session["Menu"] = Query;
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
return(View());
}
else
{
//List<Menu> Query2 = new List<Menu>();
var Query = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.MenuID where t1.RoleID == roleid && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query1 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == roleid && t.ParentID == 0 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query2 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == roleid && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
if (Query2 != null)
{
foreach (Menu q in Query1)
{
var query3 = Query.Where(cc => cc.MenuID == q.MenuID).FirstOrDefault();
if (query3 == null)
{
Query2.Add(q);
}
}
}
if (Query1 != null)
{
foreach (Menu q in Query1)
{
var query3 = Query.Where(cc => cc.MenuID == q.MenuID).FirstOrDefault();
if (query3 == null)
{
Query.Add(q);
}
}
}
Session["Menu"] = Query;
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
return(View());
}
}
public JsonResult GetCreditDays(int ID)
{
SourceMastersModel SM1 = new SourceMastersModel();
int?CreditDays = 0;
var Product = SM1.GetCustomerById(ID);
if (Product.MaxCreditDays != null)
{
CreditDays = Product.MaxCreditDays;
}
return(Json(CreditDays, JsonRequestBehavior.AllowGet));
}
public ActionResult Home()
{
//var Query = (from t in db.Menus where t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.MenuID where t1.RoleID == 14 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query1 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == 14 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
foreach (Menu q in Query)
{
Query1.Add(q);
}
Session["Menu"] = Query1;
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
return(View());
}
public ActionResult Home()
{
var Query = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.MenuID where t1.RoleID == 13 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query1 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == 13 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
foreach (Menu q in Query)
{
Query1.Add(q);
}
//List<MenuVM> Query = (
// from a in db.Menus
// from b in db.MenuAccessLevels
// .Where(bb => bb.MenuID == a.MenuID)
// from c in db.MenuAccessLevels
// .Where(cc => cc.ParentID == a.MenuID)
// where b.RoleID == 13 && c.RoleID == 13
// select new MenuVM { MenuID = a.MenuID, Title = a.Title, Link = a.Link, ParentID = a.ParentID, Ordering = a.Ordering, SubLevel = a.SubLevel, RoleID = a.RoleID , CreatedBy =a.CreatedBy, CreatedOn =a.CreatedOn, ModifiedBy =a.ModifiedBy, ModifiedOn=a.ModifiedOn,
// IsActive=a.IsActive,
// imgclass =a.imgclass,
// PermissionRequired=a.PermissionRequired,
// MenuOrder=a.MenuOrder,
// IsAccountMenu=a.IsAccountMenu
// }).ToList();
//select new
//{
// ss=t.
// First_Name = d.First_Name
//}
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
Session["Menu"] = Query1;
return(View());
}
public ActionResult Login(UserRegistration UR)
{
bool status = true;
if (string.IsNullOrEmpty(UR.UserName))
{
status = false;
}
else if (string.IsNullOrEmpty(UR.Password))
{
status = false;
}
//else if (UR.BranchID <= 0)
// status = false;
//else if (UR.AcFinancialYearID <= 0)
// status = false;
if (status)
{
List <SP_LoginUser_Result> Log = new List <SP_LoginUser_Result>();
Log = rgm.LoginUser(UR);
var userlogin = entity.UserRegistrations.Where(d => d.EmailId == UR.UserName && d.Password == UR.Password).ToList();
if (userlogin.Count > 0)
{
foreach (var item in userlogin)
{
FormsAuthentication.SetAuthCookie(item.UserName, true);
var User_Registration = (from t in entity.UserRegistrations
where t.UserID == item.UserID
select t
).FirstOrDefault();
if (User_Registration.BranchID == 0 || User_Registration.BranchID == null)
{
User_Registration.BranchID = entity.BranchMasters.FirstOrDefault().BranchID;
}
var acfinancialyearid = entity.AcFinancialYears.Where(d => d.BranchID == User_Registration.BranchID).FirstOrDefault().AcFinancialYearID;
int?BranchCurrencyId = (from e in entity.BranchMasters where e.BranchID == User_Registration.BranchID select e.CurrencyID).FirstOrDefault();
var basecurrency = (from t in entity.CurrencyMasters where t.CurrencyID == BranchCurrencyId select t).FirstOrDefault();
Session["BaseCurrencyId"] = BranchCurrencyId;
Session["BaseCurrency"] = basecurrency.CurrencyName;
Session["BaseCurrencySymbol"] = basecurrency.Symbol;
Session["UserID"] = item.UserID;
Session["UserName"] = item.UserName;
Session["branchid"] = User_Registration.BranchID;
var AccompanyId = (from c in entity.AcCompanies select c.AcCompanyID).FirstOrDefault();
Session["AcCompanyID"] = AccompanyId;
Session["fyearid"] = acfinancialyearid;
SourceMastersModel objSourceMastersModel = new SourceMastersModel();
Session["Company"] = objSourceMastersModel.GetAcCompaniesById(AccompanyId).AcCompany1;
Session["BranchName"] = entity.BranchMasters.Find(User_Registration.BranchID).BranchName;
var fyearFrom = (from t in entity.AcFinancialYears where t.AcFinancialYearID == acfinancialyearid select t.AcFYearFrom).FirstOrDefault();
Session["FyearFrom"] = fyearFrom;
var fyearTo = (from t in entity.AcFinancialYears where t.AcFinancialYearID == acfinancialyearid select t.AcFYearTo).FirstOrDefault();
Session["FyearTo"] = fyearTo;
var query = (from t in entity.UserRegistrations
where t.UserID == item.UserID && t.RoleID.HasValue
select t.RoleID.Value).ToList();
var UserRoleID = (from t in entity.UserRegistrations
where t.UserID == item.UserID
select t.RoleID).FirstOrDefault();
Session["UserRoleID"] = UserRoleID;
if (query != null)
{
Session["RoleID"] = query;
if (query[0] == 1)
{
var menuaccesslevels = new List <MenuAccessLevel>();
var menus = (from t in entity.Menus where t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
Session["Menu"] = menus;
}
else
{
Int32 roleid = query[0];
var menudata = (from t in entity.MenuAccessLevels
join s in entity.Menus on t.MenuID equals s.MenuID
where t.RoleID == roleid && t.IsView == true
orderby s.MenuOrder
select s).ToList();
Session["menu"] = menudata;
}
}
else
{
Session["RoleID"] = new List <int>();
}
}
return(RedirectToAction("Home", "Home"));
}
Session["ForgotStatus"] = "Forgot";
Session["StatusMessage"] = "Invalid EmailId!";
return(RedirectToAction("Index", "Login"));
}
else
{
ViewBag.ErrorMessage = "Please fill mandatory fields";
ViewBag.Branch = entity.BranchMasters.ToList();
ViewBag.fyears = entity.AcFinancialYearSelect(Convert.ToInt32(Session["branchid"])).ToList();
return(View());
}
}