public loginModels GetLoginFormModels(userData userData, string cuurip, string userAgent)
{
switch (string.IsNullOrWhiteSpace(userData.userid))
{
case true:
return(new loginModels()
{
status = "errorFormLogin"
});
}
database database = new database();
DataTable loginRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@newid", userData.userid.TrimEnd()));
dbparamlist.Add(new dbparam("@externip", cuurip));
dbparamlist.Add(new dbparam("@status", "1"));
loginRows = database.checkSelectSql("mssql", "epaperstring", "exec web.checkformlogin @newid,@externip,@status;", dbparamlist);
switch (loginRows.Rows.Count)
{
case 0:
return(new loginModels()
{
status = "nodata"
});
}
if (loginRows.Rows[0]["isused"].ToString().TrimEnd() == "1" && loginRows.Rows[0]["islogin"].ToString().TrimEnd() == "1")
{
datetime datetime = new datetime();
information information = new information();
string date = datetime.sqldate("mssql", "epaperstring"), time = datetime.sqltime("mssql", "epaperstring");
dbparamlist.Add(new dbparam("@cpu", ""));
dbparamlist.Add(new dbparam("@os", information.osystem(userAgent)));
dbparamlist.Add(new dbparam("@internip", ""));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
switch (database.checkActiveSql("mssql", "epaperstring", "update web.sitelog set cpu = @cpu,os = @os,internip = @internip,indate = @indate,intime = @intime where newid = @newid and externip = @externip and islogin = @status;", dbparamlist))
{
case "istrue":
return(new loginModels()
{
newid = loginRows.Rows[0]["newid"].ToString().TrimEnd(), name = loginRows.Rows[0]["username"].ToString().TrimEnd().Substring(0, 1), allname = loginRows.Rows[0]["username"].ToString().TrimEnd(), status = "istrue"
});
}
return(new loginModels()
{
status = "error"
});
}
return(new loginModels()
{
status = "islock"
});
}
public loginModels GetLoginModels(loginData loginData, string cuurip, string userAgent)
{
switch (string.IsNullOrWhiteSpace(loginData.userid))
{
case true:
return(new loginModels()
{
status = "errorUserid"
});
}
switch (string.IsNullOrWhiteSpace(loginData.password))
{
case true:
return(new loginModels()
{
status = "errorPassword"
});
}
database database = new database();
DataTable mainRows = new DataTable();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@userid", loginData.userid.TrimEnd()));
dbparamlist.Add(new dbparam("@password", new sha256().encry256(loginData.password.TrimEnd())));
dbparamlist.Add(new dbparam("@status", "1"));
mainRows = database.checkSelectSql("mssql", "sysstring", "exec web.loginsiteber @userid,@password,@status;", dbparamlist);
switch (mainRows.Rows.Count)
{
case 0:
return(new loginModels()
{
status = "nodata"
});
}
switch (mainRows.Rows[0]["isused"].ToString().TrimEnd())
{
case "1":
string longitude = string.IsNullOrWhiteSpace(loginData.longitude) ? "0.0" : loginData.longitude, latitude = string.IsNullOrWhiteSpace(loginData.latitude) ? "0.0" : loginData.latitude, cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0];
information information = new information();
dbparamlist.Clear();
DataTable subRows = new DataTable();
dbparamlist.Add(new dbparam("@newid", mainRows.Rows[0]["newid"].ToString().TrimEnd()));
dbparamlist.Add(new dbparam("@externip", cuurip));
dbparamlist.Add(new dbparam("@longitude", longitude));
dbparamlist.Add(new dbparam("@latitude", latitude));
dbparamlist.Add(new dbparam("@hostname", cuname));
dbparamlist.Add(new dbparam("@browser", information.browser(userAgent)));
dbparamlist.Add(new dbparam("@os", information.osystem(userAgent)));
subRows = database.checkSelectSql("mssql", "sysstring", "exec web.checksitelog @newid,@externip,@longitude,@latitude,@hostname,@browser,@os;", dbparamlist);
switch (subRows.Rows.Count)
{
case 0:
return(new loginModels()
{
newid = mainRows.Rows[0]["newid"].ToString().TrimEnd(), name = mainRows.Rows[0]["username"].ToString().TrimEnd().Substring(0, 1), allname = mainRows.Rows[0]["username"].ToString().TrimEnd(), status = "istrue"
});
}
break;
}
return(new loginModels()
{
status = "islock"
});
}
public loginModels GetLoginModels(loginData loginData, string cuurip, string userAgent)
{
switch (string.IsNullOrWhiteSpace(loginData.userid))
{
case true:
return(new loginModels()
{
status = "errorUserid"
});
}
switch (string.IsNullOrWhiteSpace(loginData.password))
{
case true:
return(new loginModels()
{
status = "errorPassword"
});
}
DataTable userRows = new DataTable();
database database = new database();
List <dbparam> dbparamlist = new List <dbparam>();
dbparamlist.Add(new dbparam("@userid", loginData.userid.TrimEnd()));
dbparamlist.Add(new dbparam("@password", new sha256().encry256(loginData.password.TrimEnd())));
dbparamlist.Add(new dbparam("@status", "1"));
userRows = database.checkSelectSql("mssql", "epaperstring", "exec web.loginsiteber @userid,@password,@status;", dbparamlist);
switch (userRows.Rows.Count)
{
case 0:
return(new loginModels()
{
status = "nodata"
});
}
datetime datetime = new datetime();
string newid = userRows.Rows[0]["newid"].ToString().TrimEnd(), name = userRows.Rows[0]["username"].ToString().TrimEnd(), longitude = string.IsNullOrWhiteSpace(loginData.longitude) ? "0.0" : loginData.longitude, latitude = string.IsNullOrWhiteSpace(loginData.latitude) ? "0.0" : loginData.latitude, cuname = Dns.GetHostEntry(cuurip).HostName.IndexOf('.') == -1 ? Dns.GetHostEntry(cuurip).HostName : Dns.GetHostEntry(cuurip).HostName.Split('.')[0], date = datetime.sqldate("mssql", "epaperstring"), time = datetime.sqltime("mssql", "epaperstring");
switch (userRows.Rows[0]["isused"].ToString().TrimEnd())
{
case "1":
information information = new information();
userRows.Clear();
dbparamlist.Add(new dbparam("@externip", cuurip));
userRows = database.checkSelectSql("mssql", "epaperstring", "exec web.checksitelog @userid,@password,@externip,@status;", dbparamlist);
switch (userRows.Rows.Count)
{
case 0:
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@newid", newid));
dbparamlist.Add(new dbparam("@externip", cuurip));
dbparamlist.Add(new dbparam("@longitude", longitude));
dbparamlist.Add(new dbparam("@latitude", latitude));
dbparamlist.Add(new dbparam("@hostname", cuname));
dbparamlist.Add(new dbparam("@browser", information.browser(userAgent)));
dbparamlist.Add(new dbparam("@os", information.osystem(userAgent)));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
dbparamlist.Add(new dbparam("@islogin", "1"));
if (database.checkActiveSql("mssql", "epaperstring", "insert into web.sitelog (newid,externip,longitude,latitude,hostname,browser,os,indate,intime,islogin) values (@newid,@externip,@longitude,@latitude,@hostname,@browser,@os,@indate,@intime,@islogin);", dbparamlist) != "istrue")
{
return(new loginModels()
{
status = "error"
});
}
return(new loginModels()
{
newid = newid, name = name.Substring(0, 1), allname = name, status = "istrue"
});
}
if (userRows.Rows[0]["isused"].ToString().TrimEnd() == "1" && userRows.Rows[0]["islogin"].ToString().TrimEnd() == "1")
{
dbparamlist.Clear();
dbparamlist.Add(new dbparam("@longitude", longitude));
dbparamlist.Add(new dbparam("@latitude", latitude));
dbparamlist.Add(new dbparam("@browser", information.browser(userAgent)));
dbparamlist.Add(new dbparam("@os", information.osystem(userAgent)));
dbparamlist.Add(new dbparam("@indate", date));
dbparamlist.Add(new dbparam("@intime", time));
dbparamlist.Add(new dbparam("@newid", newid));
dbparamlist.Add(new dbparam("@externip", cuurip));
dbparamlist.Add(new dbparam("@islogin", "1"));
if (database.checkActiveSql("mssql", "epaperstring", "update web.sitelog set longitude = @longitude,latitude = @latitude,browser = @browser,os = @os,indate = @indate,intime = @intime where newid = @newid and externip = @externip and islogin = @islogin;", dbparamlist) != "istrue")
{
return(new loginModels()
{
status = "error"
});
}
return(new loginModels()
{
newid = newid, name = name.Substring(0, 1), allname = name, status = "istrue"
});
}
break;
}
return(new loginModels()
{
status = "islock"
});
}
