public ActionResult Index(loginValidation V)
{
if (ModelState.IsValid)
{
string user = Request.Form["Username"];
string pass = Request.Form["Password"];
Login_Table L = userBus.search(user, pass);
if (L != null)
{
Session["user"] = L.User_ID;
Session["type"] = L.UserType;
if (L.UserType == "Admin")
{
return(View("page1"));
}
else
{
return(View("page2"));
}
}
else
{
ViewBag.msg = "Invalid Credentails";
return(View("Index"));
}
}
return(View());
}
public ActionResult RegisterForm(Login_Table lt)
{
es.Login_Table.Add(lt);
es.SaveChanges();
return(View());
}
public async Task <List <ProcessMapModel> > ProcessMapByIdAsync(string id)
=> await(from trlUserCountry in this.db.TrelAgentCountry
join tblCountry in this.db.TblCountry on trlUserCountry.IdCountry equals tblCountry.IdCountry into UserCountry_Table
from leftUserCountry in UserCountry_Table.DefaultIfEmpty()
join tblLogin in this.db.Users on trlUserCountry.IdAgent equals tblLogin.Id into Login_Table
from leftLogin in Login_Table.DefaultIfEmpty()
join trlCountryProcess in this.db.TrelCountryProcess on leftUserCountry.IdCountry equals trlCountryProcess.IdCountry into CountryProcess_Table
from leftCountryProcess in CountryProcess_Table.DefaultIfEmpty()
join tblProcess in this.db.TblProcess on leftCountryProcess.IdProcess equals tblProcess.IdProcess into Process_Table
from leftProcess in Process_Table.DefaultIfEmpty()
join trlProcessActivity in this.db.TrelProcessActivity on leftProcess.IdProcess equals trlProcessActivity.IdProcess into ProcessActivity_Table
from leftProcessActivity in ProcessActivity_Table.DefaultIfEmpty()
join tblActivity in this.db.TblActivity on leftProcessActivity.IdActivity equals tblActivity.IdActivity into Activity_Table
from leftActivity in Activity_Table.DefaultIfEmpty()
join trlProcessLob in this.db.TrelProcessLob on leftProcess.IdProcess equals trlProcessLob.IdProcess into ProcessLob_Table
from lefProcesstLob in ProcessLob_Table.DefaultIfEmpty()
join tblLob in this.db.TblLob on lefProcesstLob.IdLob equals tblLob.IdLob into Lob_Table
from leftLob in Lob_Table.DefaultIfEmpty()
join trlProcessStatus in this.db.TrelProcessStatus on leftProcess.IdProcess equals trlProcessStatus.IdProcess into ProcessStatus_Table
from leftProcessStatus in ProcessStatus_Table.DefaultIfEmpty()
join tbl_Status in this.db.TblStatus on leftProcessStatus.IdStatus equals tbl_Status.IdStatus into Status_Table
from leftStatus in Status_Table.DefaultIfEmpty()
join trlProcessDivision in this.db.TrelProcessDivision on leftProcess.IdProcess equals trlProcessDivision.IdProcess into ProcessDivision_Table
from leftProcessDivision in ProcessDivision_Table.DefaultIfEmpty()
join tblDivision in this.db.TblDivision on leftProcessDivision.IdDivision equals tblDivision.IdDivision into Division_Table
from leftDivision in Division_Table.DefaultIfEmpty()
join trlProcessTower in this.db.TrelProcessTower on leftProcess.IdProcess equals trlProcessTower.IdProcess into ProcessTower_Table
from leftProcessTower in ProcessTower_Table.DefaultIfEmpty()
join tblTower in this.db.TblTower on leftProcessTower.IdTower equals tblTower.IdTower into Tower_Table
from leftTower in Tower_Table.DefaultIfEmpty()
join trlProcessTowerCategory in this.db.TrelProcessTowerCategory on leftProcess.IdProcess equals trlProcessTowerCategory.IdProcess into ProcessTowerCategory_Table
from leftProcessTowerCategory in ProcessTowerCategory_Table.DefaultIfEmpty()
join tblTowerCategory in this.db.TblTowerCategory on leftProcessTowerCategory.IdTowerCategory equals tblTowerCategory.IdTowerCategory into TowerCategory_Table
from leftTowerCategory in TowerCategory_Table.DefaultIfEmpty()
where leftLogin.Id == id
select new ProcessMapModel
{
IdCountry = leftUserCountry.IdCountry,
Country = leftUserCountry.Country,
IdProcess = leftProcess.IdProcess,
_ProcessMap = leftProcess.ProcessMap,
FunctionName = leftProcess.FunctionName,
IdLogin = leftLogin.Id,
DisplayName = leftLogin.FirstName,
IdActivity = leftActivity.IdActivity,
Activity = leftActivity.Activity,
IdLob = leftLob.IdLob,
Lob = leftLob.Lob,
IdStatus = leftStatus.IdStatus,
Status = leftStatus.Status,
IdDivision = leftProcess.IdProcess,
Division = leftProcess.ProcessMap,
IdTower = leftProcess.IdProcess,
Tower = leftProcess.ProcessMap,
IdTowerCategory = leftProcess.IdProcess,
TowerCategory = leftProcess.ProcessMap
})
.ToListAsync();
public ActionResult Index(LoginModel ModelObj)
{
Login_Table TableObj = new Login_Table();
//TableObj.Id = ModelObj.Id;
TableObj.First_Name = ModelObj.FirstName;
TableObj.Last_Name = ModelObj.LastName;
TableObj.Email = ModelObj.Email;
TableObj.PassWord = ModelObj.PassWord;
TableObj.Is_Agree = ModelObj.IsAgree;
TableObj.Is_Deleted = ModelObj.IsDeleted;
TableObj.Current_Time_Stamp = DateTime.Now;
TableObj.Updated_Time_Stamp = DateTime.Now;;
EntityObj.Login_Table.Add(TableObj);
EntityObj.SaveChanges();
ModelObj.Id = TableObj.Id;
return(Json(ModelObj, JsonRequestBehavior.AllowGet));
}
public ActionResult Login(Login_Table lt, Seating s)
{
List <Login_Table> a = es.Login_Table.ToList();
Login_Table found = a.Find(c => c.User_Name == lt.User_Name && c.Password == lt.Password && c.Role == lt.Role);
if (found != null && lt.Role == "Event-Handler")
{
Session["Adminname"] = lt.User_Name;
return(Redirect("Index"));
}
if (found != null && lt.Role == "Participator")
{
user = lt.User_Name;
Session["name"] = lt.User_Name;
return(Redirect("UserIndex"));
}
return(View());
}
public ActionResult Index(Login_Table lt, string val)
{
if (val == "Login")
{
Login_Table l = DBOperations.SendType(lt);
if (l.UserType == "Customer")
{
return(RedirectToAction("_CustomerLayoutPage"));
}
else
{
return(RedirectToAction("_AdminLayoutPage"));
}
}
else if (val == "New User")
{
return(View("RegistrnPage"));
}
return(View());
}
public ActionResult Login()
{
Login_Table lt = new Login_Table();
return(View(lt));
}
