public MdlUserLogin GetUserInfo(string Username, string passward)
{
var item = _dbFirms.USERs.Where(n => n.UserName == Username && n.Password == passward).SingleOrDefault();
MdlUserLogin list = new MdlUserLogin();
//var query = from o in _dbFirms.ORGANIZATIONs join c in _dbFirms.ORGDOCs on o.OrganizationID equals c.Org_ID
// join d in _dbFirms.ORGDOCNAMEs on c.OrgDocID equals d.OrgDoc_ID where o.OrganizationID == ID
// select new
// { o.OrganizationID, o.OrgRegNo, o.DurationofFirm, o.FormADate, d.OrgName };
if (item != null)
{
list.UserID = item.UserID;
list.UserName = item.UserName;
return(list);
}
else
{
return(list = null);
}
//foreach (var item in query)
//{
// list.UserID = item.UserID;
// list.UserName = item.UserName;
// //list.FormGNo = item1.FormGNo;
// //list.FirmStartDate = item1.FirmStartDate;
// //// list.FirmStartDateString = Convert.ToDateTime((item.FirmStartDate).ToString()).ToString("yyyy-mm-dd"); ;
// //list.FirmStartDateString = Convert.ToDateTime(item1.FirmStartDate).ToShortDateString();
// //list.DeedAgreementDateString = Convert.ToDateTime(item1.DeedAgreementDate).ToShortDateString();
//}
}
public ActionResult NewUserRegistration()
{
MdlUserLogin Umodel = new MdlUserLogin();
MngUserLogin Uapp = new MngUserLogin();
Umodel.UserRoleDrp = Uapp.GetRoledrp(0);
return(View(Umodel));
}
public MdlUserLogin VerifyUser(string Username, string password)
{
MdlUserLogin Umodel = new MdlUserLogin();
MngUserLogin Uapp = new MngUserLogin();
Umodel = Uapp.GetUserInfo(Username, password);
return(Umodel);
}
public void AddNewUser(MdlUserLogin obj)
{
_dbFirms.usp_InsertNewUserWithRole(
obj.UserName,
obj.Password,
obj.UserEmail,
obj.UserContactNo,
obj.Role_ID
);
}
public ActionResult Edit(int id)
{
MdlUserLogin Umodel = new MdlUserLogin();
MngUserLogin Uapp = new MngUserLogin();
Umodel = Uapp.GetUserInfoForEdit(id);
Umodel.UserRoleDrp = Uapp.GetRoledrp(Umodel.UserRoleID);
return(View(Umodel));
}
public void ModifyUser(MdlUserLogin model)
{
USER u = _dbFirms.USERs.First(i => i.UserID == model.UserID);
u.UserName = model.UserName;
u.UserEmail = model.UserEmail;
u.UserContactNo = model.UserContactNo;
u.EntryDate = DateTime.Now;
_dbFirms.SaveChanges();
USERROLE ur = _dbFirms.USERROLEs.First(e => e.User_ID == model.UserID);
ur.Role_ID = model.Role_ID;
ur.ModifyDate = DateTime.Now;
ur.EnterByUser_ID = model.EnterByUser_ID;
_dbFirms.SaveChanges();
}
public ActionResult NewUserRegistration(MdlUserLogin model)
{
MdlUserLogin Umodel = new MdlUserLogin();
MngUserLogin Uapp = new MngUserLogin();
try
{
string pass = _Encyption(model.Password);
model.Password = pass;
Uapp.AddNewUser(model);
return(RedirectToAction("UserList"));
}
catch
{
Umodel.UserRoleDrp = Uapp.GetRoledrp(0);
return(View(Umodel));
}
}
public ActionResult SignIn(string Username, string Password)
{
char[] charsToTrim = { ' ', '\t' };
string trimUserName = Username.Trim(charsToTrim);
string trimPassword = Password.Trim(charsToTrim);
string pass = _Encyption(trimPassword);
MdlUserLogin isverify = VerifyUser(trimUserName, pass);
if (isverify != null)
{
UtilityClass.AddUserSession(UtilityClass.UserSession.UserSessions, isverify);
return(RedirectToAction("Index", "Home"));
}
else
{
TempData["Status"] = "User Name or Password is incorrect";
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(MdlUserLogin model)
{
MdlUserLogin Umodel = new MdlUserLogin();
MngUserLogin Uapp = new MngUserLogin();
try
{
string pass = _Encyption(model.Password);
model.Password = pass;
model.EnterByUser_ID = 2;
Uapp.ModifyUser(model);
return(RedirectToAction("UserList"));
}
catch
{
Umodel.UserRoleDrp = Uapp.GetRoledrp(0);
return(View(Umodel));
}
}
public MdlUserLogin GetUserInfoForEdit(int id)
{
MdlUserLogin model = new MdlUserLogin();
var query = from o in _dbFirms.USERs
join c in _dbFirms.USERROLEs on o.UserID equals c.User_ID
join d in _dbFirms.ROLEs on c.Role_ID equals d.RoleID
where o.UserID == id
select new { o.UserID, o.UserName, o.UserEmail, o.UserContactNo, o.IsActive, o.Password, c.UserRoleID };
foreach (var item in query)
{
model.UserID = item.UserID;
model.UserName = item.UserName;
model.UserEmail = item.UserEmail == null ? "----" : item.UserEmail;
model.UserContactNo = item.UserContactNo == null ? "----" : item.UserContactNo;
model.IsActive = item.IsActive;
// model.IsActiveString = item.IsActive;
model.UserRoleID = item.UserRoleID;
model.Password = item.Password;
}
return(model);
}
