public ActionResult Forgotpassword(forgotpasswordmodel un)
{
if (!string.IsNullOrEmpty(un.username1))
{
using (var db = new paresetEntities())
{
var user = db.Userinfoes.FirstOrDefault(u => u.username == un.username1);
if (user != null)
{
//var Aq = db.Chresqlists.FirstOrDefault(u => u.id == user.adminq);
//var Uq = db.Chresqlists.FirstOrDefault(u => u.id == user.userq);
FormsAuthentication.SetAuthCookie(un.username1, false);
return(RedirectToAction("authforpswdreset", "Home"));
}
else
{
ViewBag.Message = "Error";
}
}
}
else
{
ViewBag.Message = "Error1";
}
return(View());
}
public ActionResult ChangePassword(Changepwrd1 changepassword)
{
try
{
paresetEntities db = new paresetEntities();
var obj = db.Admininfoes.Where(c => c.aid == 1).First();
string ldapPath = "LDAP://" + obj.domainip.ToString();
DirectoryEntry directionEntry = new DirectoryEntry(ldapPath, "nexzipdomain" + "\\" + User.Identity.Name, "password");
if (directionEntry != null)
{
DirectorySearcher search = new DirectorySearcher(directionEntry);
search.Filter = "(SAMAccountName=" + User.Identity.Name + ")";
SearchResult result = search.FindOne();
if (result != null)
{
DirectoryEntry userEntry = result.GetDirectoryEntry();
if (userEntry != null)
{
userEntry.Invoke("ChangePassword", new object[] { changepassword.ChangePassword == changepassword.ConfirmPassword });
userEntry.CommitChanges();
}
}
}
}
catch (Exception ex)
{
ViewBag.Message = "Error";
}
return(View());
}
private bool IsValid(string usernam, string password)
{
var crypto = new SimpleCrypto.PBKDF2();
bool IsValid = false;
using (var db = new paresetEntities())
{
var user = db.Userinfoes.FirstOrDefault(u => u.username == usernam);
if (user != null)
{
if (user.password == crypto.Compute(password, user.passwordsalt))
{
return(true);
}
}
int count = int.Parse(user.failurecount.ToString());
user.failurecount = count + 1;
db.Entry(user).CurrentValues.SetValues(user);
db.SaveChanges();
}
return(IsValid);
}
public ActionResult configauthoptions(checkboxforauthoptions confauthoptionsobj)
{
try
{
paresetEntities db = new paresetEntities();
var obj = db.Userauthoptions.ToList();
obj[0].Isenabel = confauthoptionsobj.Email;
obj[1].Isenabel = confauthoptionsobj.smsotp;
obj[2].Isenabel = confauthoptionsobj.challengeqs;
//obj.Emailotp = confauthoptionsobj.emailotp;
//obj.Charesq = confauthoptionsobj.challengequestions;
//obj.Smsotp = confauthoptionsobj.smsotp;
foreach (var m in obj)
{
db.Entry(m).CurrentValues.SetValues(m);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = "Success";
return(View(confauthoptionsobj));
}
catch
{
ViewBag.Message = "Error";
return(View());
}
}
public bool DoesUserExist(string userName)
{
SearchResult sr = null;
paresetEntities dc = new paresetEntities();
var admind = dc.Admininfoes.FirstOrDefault(u => u.aid == 1);
string adminUser = admind.adminname;
string adminPassword = admind.adminpass;
using (DirectoryEntry de = new DirectoryEntry("LDAP://" + admind.domainip, adminUser, admind.adminpass))
{
using (DirectorySearcher sea = new DirectorySearcher(de))
{
//sea.Filter = “(&(objectCategory=user)(samAccountName=” + “\”” + user + “\”” + “))”;
//sea.Filter = "(&(objectCategory=person)(objectClass = user)(samAccountName =" + userName + "))";
//sr = sea.FindOne();
sea.Filter = "(SAMAccountName=" + userName + ")";
sea.PropertiesToLoad.Add("cn");
sr = sea.FindOne();
}
return(sr != null ? true : false);
}
}
public ActionResult pwdpolicy(Pwdpolicycon pwd)
{
try
{
paresetEntities db = new paresetEntities();
var obj = db.Pwdpolicies.ToList();
obj[0].Isenabel = pwd.pwdminlen;
obj[1].Isenabel = pwd.capfirst;
obj[2].Isenabel = pwd.spclchar;
obj[3].Isenabel = pwd.lastpwd;
//obj.Emailotp = confauthoptionsobj.emailotp;
//obj.Charesq = confauthoptionsobj.challengequestions;
//obj.Smsotp = confauthoptionsobj.smsotp;
foreach (var m in obj)
{
db.Entry(m).CurrentValues.SetValues(m);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = "Success";
return(View(pwd));
}
catch (Exception ex)
{
ViewBag.Message = "Error";
return(View());
}
}
private bool IsValidAdmin(string usernam, string password)
{
var crypto = new SimpleCrypto.PBKDF2();
bool IsValid = false;
using (var db = new paresetEntities())
{
//var user = from u in db.Userinfoes
// where u.username == usernam
// select u.password;
//List<string> lstResult = (from table in db.Userinfoes
// where table.username == usernam
// select table.password).ToList();
var user = db.Admininfoes.FirstOrDefault(u => u.adminname == usernam);
//if (lstResult.Count != 0)
//{
// string dtStatus = lstResult[0];
if (user != null)
{
if (user.adminpass == password)
{
IsValid = true;
}
}
// }
}
return(IsValid);
}
public ActionResult Myprofile(UserReg user)
{
paresetEntities db = new paresetEntities();
var obj = db.Userinfoes.Where(c => c.username == user.Username).First();
try
{
obj.username = user.Username;
obj.email = user.email;
//obj.adminq = user.Adinq;
obj.ansforaq = user.Ansforaq;
obj.userq = user.Userq;
obj.ansforuq = user.Ansforuq;
obj.phone = user.phone;
//user.password = obj.password;
// user.Userq = (int)obj.userq;
db.Entry(obj).CurrentValues.SetValues(obj);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Success";
}
catch (Exception cex)
{
ViewBag.Message = "Error";
}
return(View(GetusqlistA()));
}
public ActionResult Myprofile()
{
paresetEntities db = new paresetEntities();
List <Chresqlist> objcountrylist = (from data in db.Chresqlists
select data).ToList();
Chresqlist objcountry = new Chresqlist();
objcountry.Usersqlist = "Select";
objcountry.id = 0;
objcountrylist.Insert(0, objcountry);
SelectList objmodeldata = new SelectList(objcountrylist, "id", "Usersqlist", 0);
/*Assign value to model*/
List <Userinfo> lstResult = (from data1 in db.Userinfoes where data1.username == User.Identity.Name select data1).ToList();
UserReg objcountrymodel = new UserReg();
objcountrymodel.Username = lstResult[0].username;
objcountrymodel.Password = lstResult[0].password;
objcountrymodel.email = lstResult[0].email;
objcountrymodel.phone = lstResult[0].phone;
objcountrymodel.Adinq = int.Parse(lstResult[0].adminq.ToString());
var Adminqst = db.Chresqlists.FirstOrDefault(u => u.id == objcountrymodel.Adinq);
objcountrymodel.Adinqs = Adminqst.Adminsqlist.ToString();
objcountrymodel.Ansforaq = lstResult[0].ansforaq;
objcountrymodel.Userq = int.Parse(lstResult[0].userq.ToString());
objcountrymodel.Ansforuq = lstResult[0].ansforuq;
objcountrymodel.Usersqlist1 = objmodeldata;
return(View(objcountrymodel));
}
public JsonResult GetRegUsers1()
{
//Get parameters
//Get start (paging start index) and length (pagesize for paging)
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
//Get sort columns value
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pagesize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int totalRecords = 0;
using (paresetEntities dc = new paresetEntities())
{
var v = (from a in dc.Userinfoes select a);
//sorting
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
v = v.OrderBy(sortColumn + " " + sortColumnDir);
}
totalRecords = v.Count();
var data = v.Skip(skip).Take(pagesize).ToList();
return(Json(new { draw = draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data = data }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetRecentpasswordrests()
{
paresetEntities r = new paresetEntities();
var data = r.useraudits.ToList();
ViewBag.userdetails1 = data;
return(View());
}
public ActionResult GetADusers()
{
paresetEntities r = new paresetEntities();
var data = r.UsersinADs.ToList();
ViewBag.userdetails = data;
return(View());
}
public ActionResult GetRegUsers()
{
paresetEntities entities = new paresetEntities();
List <Userinfo> customers = entities.Userinfoes.ToList();
ViewBag.userinfo = customers;
return(View());
}
public ActionResult SelectAdmiqforuser()
{
Admindetails objcountrymodel1 = new Admindetails();
objcountrymodel1.Adminsqlist = GetAsqlist();
paresetEntities db = new paresetEntities();
var Aq = db.Admininfoes.FirstOrDefault(u => u.aid == 1);
var Aq1 = db.Chresqlists.FirstOrDefault(u => u.id == Aq.adminsq);
objcountrymodel1.AdminSqaslbl = Aq1.Adminsqlist.ToString();
return(View(objcountrymodel1));
}
public ActionResult Signup(UserReg user)
{
if (user.Username != null && user.Password != null && user.email != null && user.Ansforaq != null && user.Ansforuq != null && user.ConfirmPassword != null)
{
//if (DoesUserExist(user.Username))
//{
using (paresetEntities dc = new paresetEntities())
{
//you should check duplicate registration here
var adminq = dc.Admininfoes.FirstOrDefault(u => u.aid == 1);
List <string> lstResult = (from table in dc.Userinfoes
where table.username == user.Username
select table.password).ToList();
if (lstResult.Count == 0)
{
Userinfo u = new Userinfo();
var crypto = new SimpleCrypto.PBKDF2();
var encrypPass = crypto.Compute(user.Password);
u.username = user.Username;
u.password = encrypPass;
u.passwordsalt = crypto.Salt;
u.email = user.email;
u.phone = user.phone;
u.adminq = adminq.adminsq;
u.ansforaq = user.Ansforaq;
u.userq = user.Userq;
u.ansforuq = user.Ansforuq;
u.AdminApproved = true;
u.failurecount = 0;
dc.Userinfoes.Add(u);
dc.SaveChanges();
// ModelState.Clear();
user = null;
ViewBag.Message = "Success";
}
else
{
ViewBag.Message = "Error2";
}
}
//}
//else
//{
// ViewBag.Message = "Invalid user name.";
//}
}
else
{
ViewBag.Message = "Error1";
}
return(View(Getusqlist()));
}
public ActionResult smsotp()
{
int otpValue = new Random().Next(100000, 999999);
var status = "";
try
{
paresetEntities db = new paresetEntities();
var mobileno = db.Userinfoes.FirstOrDefault(u => u.username == User.Identity.Name);
string recipient = mobileno.phone.ToString();
string masked = "(XXX) XXX-" + recipient.Substring(recipient.Length - 4);
string APIKey = System.Configuration.ConfigurationManager.AppSettings["APIKey"].ToString();
string message = "Your OTP Number is " + otpValue + " ( Sent By : nexzip )";
String encodedMessage = System.Web.HttpUtility.UrlEncode(message);
using (var webClient = new System.Net.WebClient())
{
byte[] response = webClient.UploadValues("https://api.textlocal.in/send/", new System.Collections.Specialized.NameValueCollection()
{
{ "apikey", APIKey },
{ "numbers", recipient },
{ "message", encodedMessage },
{ "sender", "TXTLCL" }
});
string result = System.Text.Encoding.UTF8.GetString(response);
var jsonObject = Newtonsoft.Json.Linq.JObject.Parse(result);
status = jsonObject["status"].ToString();
Session["CurrentOTP"] = otpValue;
}
//return Json(status, JsonRequestBehavior.AllowGet);
OTPValidater obj = new OTPValidater();
obj.msakmobilelable = "successfully send otp to you reg mobile number" + masked + status;
obj.username = User.Identity.Name.ToString();
return(View(obj));
}
catch (Exception e)
{
OTPValidater obj = new OTPValidater();
obj.msakmobilelable = "Error";
obj.username = User.Identity.Name.ToString();
return(View(obj));
}
}
public ActionResult authforpswdreset1()
{
paresetEntities dc = new paresetEntities();
List <Userinfo> lstResult = (from table in dc.Userinfoes
where table.username == User.Identity.Name
select table).ToList();
userinffrpwdrst obj = new userinffrpwdrst();
obj.username = lstResult[0].username.ToString();
obj.email = lstResult[0].email.ToString();
obj.phone = lstResult[0].phone.ToString();
return(View(obj));
}
public ActionResult adminview(Admindetails Admind, String Command)
{
if (Command == "Update")
{
if (Admind.serveradminname != null && Admind.serveradminpass != null && Admind.DomainName != null && Admind.DomainIP != null)
{
IPAddress ip;
bool ValidateIP = IPAddress.TryParse(Admind.DomainIP, out ip);
if (ValidateIP)
{
paresetEntities db = new paresetEntities();
var obj = db.Admininfoes.Where(c => c.adminname == User.Identity.Name).First();
obj.serveradminname = Admind.serveradminname;
obj.serveradminpass = Admind.serveradminpass;
// obj.adminsq = Admind.AdminSq;
obj.dmainname = Admind.DomainName;
obj.domainip = Admind.DomainIP;
db.Entry(obj).CurrentValues.SetValues(obj);
db.SaveChanges();
//ModelState.Clear();
ViewBag.Message = "Success1";
}
}
}
else
{
try
{
DirectoryEntry entry = new DirectoryEntry("LDAP://" + Admind.DomainIP, Admind.serveradminname, Admind.serveradminpass);
object nativeObject = entry.NativeObject;
ViewBag.Message = "Success2";
}
catch (DirectoryServicesCOMException cex)
{
//not authenticated; reason why is in cex
ViewBag.Message = "Error";
}
catch (Exception ex)
{
//not authenticated due to some other exception [this is optional]
ViewBag.Message = "Error";
}
}
//Admindetails objcountrymodel1 = new Admindetails();
//objcountrymodel1.Adminsqlist = GetAsqlist();
//return View(objcountrymodel1);
return(View());
}
public ActionResult adminview()
{
paresetEntities db = new paresetEntities();
List <Admininfo> lstResult = (from data2 in db.Admininfoes where data2.adminname == User.Identity.Name select data2).ToList();
Admindetails objcountrymodel1 = new Admindetails();
objcountrymodel1.serveradminname = lstResult[0].serveradminname;
objcountrymodel1.serveradminpass = lstResult[0].serveradminpass;
objcountrymodel1.DomainName = lstResult[0].dmainname;
objcountrymodel1.DomainIP = lstResult[0].domainip;
// objcountrymodel1.Adminsqlist = GetAsqlist();
return(View(objcountrymodel1));
}
public static void WorkThreadFunction(object importcsv)
{
paresetEntities dc = new paresetEntities();
List <string> csvvalue1 = loadCsvFile(importcsv.ToString());
string[] _values = null;
failedrcrd = 0;
threadstop = false;
foreach (string obj in csvvalue1)
{
if (threadstop == true)
{
break;
}
_values = obj.Split(',');
// var user = dc.Userinfoes.FirstOrDefault(m => m.username == _values[0].ToString());
string name = _values[0].ToString();
List <string> lstResult = (from table in dc.Userinfoes
where table.username == name
select table.password).ToList();
if (lstResult.Count == 0)
{
Userinfo u = new Userinfo();
var crypto = new SimpleCrypto.PBKDF2();
var encrypPass = crypto.Compute(_values[1]);
u.username = _values[0];
u.password = encrypPass;
u.passwordsalt = crypto.Salt;
u.email = _values[2];
u.phone = _values[3];
u.adminq = int.Parse(_values[4].ToString());
u.ansforaq = _values[5];
u.userq = int.Parse(_values[6].ToString());
u.ansforuq = _values[7];
u.AdminApproved = true;
dc.Userinfoes.Add(u);
dc.SaveChanges();
successrcrd = successrcrd + 1;
}
else
{
failedrcrd = failedrcrd + 1;
}
cssrecords = cssrecords - 1;
}
}
public ActionResult emailotp()
{
int otpValue = new Random().Next(100000, 999999);
var status = "";
OTPmailValidater ob = new OTPmailValidater();
try
{
Session["msgotp"] = otpValue;
//string msg = "your otp from abc.com is " + otpValue;
paresetEntities db = new paresetEntities();
var uemail = db.Userinfoes.FirstOrDefault(u => u.username == User.Identity.Name);
string recipient = uemail.email.ToString();
string masked = "XXXXXXXX" + recipient.Substring(recipient.Length - 10);
string emailfrom = System.Configuration.ConfigurationManager.AppSettings["fromemail"].ToString();
string passwordmail = System.Configuration.ConfigurationManager.AppSettings["Password"].ToString();
MailMessage msg = new MailMessage();
msg.From = new MailAddress(emailfrom);
msg.To.Add(recipient);
msg.Subject = "Random Password for your Account";
msg.Body = "Your Random password is:" + otpValue;
msg.IsBodyHtml = true;
SmtpClient smt = new SmtpClient();
smt.Host = "smtp.zoho.com";
System.Net.NetworkCredential ntwd = new System.Net.NetworkCredential();
ntwd.UserName = emailfrom; //Your Email ID
ntwd.Password = passwordmail; // Your Password
smt.UseDefaultCredentials = true;
smt.Credentials = ntwd;
smt.Port = 587;
smt.EnableSsl = true;
smt.Send(msg);
ob.msakemaillable = masked;
ob.username = User.Identity.Name.ToString();
return(View(ob));
}
catch (Exception e)
{
ob.msakemaillable = "Error";
ob.username = User.Identity.Name.ToString();
return(View(ob));
}
}
public ActionResult EnableUser(Enableusr enable)
{
try
{
paresetEntities db = new paresetEntities();
var obj = db.Userinfoes.Where(c => c.username == enable.username).First();
obj.failurecount = 0;
obj.AdminApproved = true;
db.Entry(obj).CurrentValues.SetValues(obj);
db.SaveChanges();
ViewBag.Message = "Success1";
}
catch (Exception cex)
{
ViewBag.Message = "Error";
}
return(View());
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool authorize = false;
using (paresetEntities db = new paresetEntities())
{
UserReg UM = new UserReg();
foreach (var roles in userAssignedRoles)
{
authorize = UM.IsUserInRole(httpContext.User.Identity.Name, roles);
if (authorize)
{
return(authorize);
}
}
}
return(authorize);
}
public ActionResult Setpassword()
{
Account obj = new Account();
obj.username = User.Identity.Name.ToString();
paresetEntities db = new paresetEntities();
obj.plist = db.Pwdpolicies.ToList();
//List<Pwdpolicy> pwds = db.Pwdpolicies.ToList();
//foreach(var mb in pwds)
// {
// if (mb.Isenabel)
// {
// obj.policylbl = obj.policylbl + Environment.NewLine + mb.Label.ToString();
// }
//}
return(View(obj));
}
public SelectList GetAsqlist()
{
paresetEntities db = new paresetEntities();
List <Chresqlist> objcountrylist = (from data in db.Chresqlists
select data).ToList();
Chresqlist objcountry = new Chresqlist();
objcountry.Usersqlist = "Select";
objcountry.id = 0;
objcountrylist.Insert(0, objcountry);
SelectList objmodeldata = new SelectList(objcountrylist, "id", "Adminsqlist", 0);
/*Assign value to model*/
//Admindetails adminde = new Admindetails();
//adminde.Adminsqlist = objmodeldata;
return(objmodeldata);
}
public UserReg Getusqlist()
{
paresetEntities db = new paresetEntities();
List <Chresqlist> objcountrylist = (from data in db.Chresqlists
select data).ToList();
Chresqlist objcountry = new Chresqlist();
objcountry.Usersqlist = "Select";
objcountry.id = 0;
objcountrylist.Insert(0, objcountry);
SelectList objmodeldata = new SelectList(objcountrylist, "id", "Usersqlist", 0);
/*Assign value to model*/
UserReg objcountrymodel = new UserReg();
objcountrymodel.Usersqlist1 = objmodeldata;
return(objcountrymodel);
}
public ActionResult authforpswdreset()
{
paresetEntities db = new paresetEntities();
var mobileno = db.Userinfoes.FirstOrDefault(u => u.username == User.Identity.Name);
string recipient = mobileno.phone.ToString();
string masked = "(XXX) XXX-" + recipient.Substring(recipient.Length - 4);
Userauthtypes obj = new Userauthtypes();
obj.phone = masked;
var uemail = db.Userinfoes.FirstOrDefault(u => u.username == User.Identity.Name);
string recipient1 = uemail.email.ToString();
//string masked1 = "XXXXXXXX" + recipient1.Substring(recipient1.Length - 10);
obj.email = recipient1;
//obj.userauthlist = db.Userauthoptions.ToList();
//obj.selecttedans = "";
obj.username = User.Identity.Name.ToString();
return(View(obj));
}
public ActionResult configauthoptions()
{
try
{
paresetEntities db = new paresetEntities();
var obj = db.Userauthoptions.ToList();
checkboxforauthoptions options = new checkboxforauthoptions();
options.Email = bool.Parse(obj[0].Isenabel.ToString());
options.smsotp = bool.Parse(obj[1].Isenabel.ToString());
options.challengeqs = bool.Parse(obj[2].Isenabel.ToString());
return(View(options));
}
catch
{
ViewBag.Message = "please select to update";
return(View());
}
}
public ActionResult Listofqfora()
{
using (var db = new paresetEntities())
{
var user = db.Userinfoes.FirstOrDefault(u => u.username == User.Identity.Name);
if (user != null)
{
var Aq = db.Chresqlists.FirstOrDefault(u => u.id == user.adminq);
var Uq = db.Chresqlists.FirstOrDefault(u => u.id == user.userq);
Ansforuserq afq = new Ansforuserq();
afq.AdminQ = Aq.Adminsqlist;
afq.UserQ = Aq.Usersqlist;
afq.UsernA = user.username;
// FormsAuthentication.SignOut();
afq.username1 = User.Identity.Name.ToString();
return(View(afq));
}
}
return(View());
}
public ActionResult SelectAdmiqforuser(Admindetails admind)
{
paresetEntities db = new paresetEntities();
var obj = db.Admininfoes.Where(c => c.adminname == User.Identity.Name).First();
obj.adminsq = admind.AdminSq;
db.Entry(obj).CurrentValues.SetValues(obj);
db.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Success";
Admindetails objcountrymodel1 = new Admindetails();
objcountrymodel1.Adminsqlist = GetAsqlist();
var Aq1 = db.Chresqlists.FirstOrDefault(u => u.id == admind.AdminSq);
objcountrymodel1.AdminSqaslbl = Aq1.Adminsqlist.ToString();
return(View(objcountrymodel1));
}
