public UserModels GetUserByLogin(string login)
{
UserModels ret = new UserModels();
STUser data = new STUser();
string msg;
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
try
{
CUser clUser =
new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
int retvalue = clUser.GetRecordByUserLogin(login, out data, out msg);
ret = new UserModels();
ret.UserId = data.userid;
ret.UserName = data.username;
ret.Login = data.login;
ret.Comments = data.comments;
ret.Condition = clCondition.GetName(data.condition);
ret.Permission = clPermission.GetName(data.permission);
// ret.Password = data.password;
// ret.ConfirmPassword = ret.Password;
ret.Email = data.email;
ret.OwnerUserId = data.owneruserid;
ret.OwnerUserName = data.ownerusername;
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
public STUserVP GetParam(UserModelsViewParam prm)
{
STUserVP ret = new STUserVP();
string msg;
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
try
{
ret.strdata = null;
if (prm.UserName != null)
{
ret.maskusername = prm.UserName;
ret.strdata += string.Format("<UserName={0}>", ret.maskusername);
}
if (prm.Permission != null)
{
ret.permission = clPermission.GetId(prm.Permission);
ret.strdata += string.Format("<Permission={0}>", prm.Permission);
}
if (prm.Condition != null)
{
ret.condition = clCondition.GetId(prm.Condition);
ret.strdata += string.Format("<Condition={0}>", prm.Condition);
}
if (prm.Email != null)
{
ret.maskemail = prm.Email;
ret.strdata += string.Format("<Email={0}>", ret.maskemail);
}
if (prm.Login != null)
{
ret.masklogin = prm.Login;
ret.strdata += string.Format("<Login={0}>", ret.masklogin);
}
if (prm.IsAll)
{
ret.isall = true;
}
else
{
ret.isall = false;
}
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
public STUser GetLocalUser()
{
STUser ret = new STUser();
string msg;
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
try
{
CUser clUser = new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
int retvalue = clUser.GetRecordByUserId(LocalData.UserId(), out ret, out msg);
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
public int UpdateUser(UserModels model, out string msg)
{
int ret = 0;
msg = null;
STUser data = new STUser();
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
try
{
CUser clUser = new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
data.comments = model.Comments;
data.condition = clCondition.GetId(model.Condition);
data.email = model.Email;
data.login = model.Login;
data.modifieddate = DateTime.Now;
data.passwordsalt = CreateSalt();
// data.password = CreatePasswordHash(model.Password, data.passwordsalt);
data.permission = clPermission.GetId(model.Permission);
data.username = model.UserName;
string[] arr = new[] { "'", "\"", "--" };
if (CheckerField.CheckField(arr, data.comments, data.email, data.login, data.username))
{
msg = "One or more fields contain invalid characters.";
return(2);
}
ret = clUser.Update(model.UserId, data, out msg);
if (ret == 0)
{
CAction clAction = new CAction(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
clAction.AddAction(ActionType.EditUser, string.Format("Edit user {0}, {1}", data.username,
data.login), out msg);
}
}
catch (Exception ex) { msg = ex.Message; ret = -1; }
return(ret);
}
public List <UserModels> GetListUser(STUserVP param)
{
List <UserModels> ret = new List <UserModels>();
UserModels item;
List <STUser> data = new List <STUser>();
string msg;
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
CUser clUser;
try
{
clUser =
new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
int retvalue = clUser.GetData(param, out data, out msg);
foreach (STUser row in data)
{
item = new UserModels();
item.UserId = row.userid;
item.UserName = row.username;
item.Login = row.login;
item.Comments = row.comments;
item.Condition = clCondition.GetName(row.condition);
item.Permission = clPermission.GetName(row.permission);
// item.Password = row.password;
item.Email = row.email;
item.OwnerUserId = row.owneruserid;
item.OwnerUserName = row.ownerusername;
if (!row.isactivated)
{
item.AccountState = "Not activated";
}
else
{
item.AccountState = null;
}
ret.Add(item);
}
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
public UserModelsViewParam SetParam(STUserVP param)
{
UserModelsViewParam ret = new UserModelsViewParam();
string msg;
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
try
{
if (param.condition != null)
{
ret.Condition = clCondition.GetName((int)param.condition);
}
else
{
ret.Condition = null;
}
ret.Email = param.maskemail;
ret.Login = param.masklogin;
if (param.permission != null)
{
ret.Permission = clPermission.GetName((int)param.permission);
}
else
{
ret.Permission = null;
}
ret.UserName = param.maskusername;
if (!param.isall)
{
ret.IsAll = false;
}
else
{
ret.IsAll = true;
}
}
catch (Exception ex) { msg = ex.Message; }
return(ret);
}
public int AddUser(UserModels model, out string msg)
{
int ret = 0;
STUser data = new STUser();
msg = null;
CCondition clCondition = new CCondition();
CPermission clPermission = new CPermission();
try
{
CUser clUser =
new CUser(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
ret = clUser.GetRecordByUserLogin(model.Login, out data, out msg);
if (ret != 0)
{
return(ret);
}
else
{
if (data.login != null)
{
msg = "The login already exists in the database for the application.";
return(1);
}
}
data.comments = model.Comments;
data.activateddate = null;
data.condition = 0;
data.creationdate = DateTime.Now;
data.email = model.Email;
data.isactivated = false;
data.login = model.Login;
data.modifieddate = data.creationdate;
data.owneruserid = LocalData.UserId();
// data.passwordsalt = CreateSalt();
// data.password = CreatePasswordHash(model.Password, data.passwordsalt);
data.permission = clPermission.GetId(model.Permission);
data.username = model.UserName;
data.passvaliddate = DateTime.Now.AddDays(-1);
data.newemailkey = GenerateKey();
string[] arr = new[] { "'", "\"", "--" };
if (CheckerField.CheckField(arr, data.comments, data.email, data.login, data.username))
{
msg = "One or more fields contain invalid characters.";
return(2);
}
ret = clUser.Insert(data, out msg);
if (ret == 0)
{
CAction clAction = new CAction(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
clAction.AddAction(ActionType.AddUser, string.Format("Add user {0}, {1}", data.username,
data.login), out msg);
CMail clMail = new CMail(LocalData.UserId(), LocalData.CSDbUsers(), LocalData.LogPath());
STMail maildata = new STMail();
maildata.to = data.email;
maildata.tamplate = "MailToUserActivateAccount.txt";
maildata.linkkey = data.newemailkey;
maildata.fleetpwd = null;
maildata.pan = null;
maildata.dtcreate = DateTime.Now.ToString("yyyyMMddHHmmss");
maildata.dtmistsent = null;
maildata.login = data.login;
clMail.Insert(maildata, out msg);
SMTPNotice smtp = new SMTPNotice(LocalData.SmtpHost(), LocalData.SmtpPort(), LocalData.SmtpUseSSL(),
LocalData.SmtpUserName(), LocalData.SmtpPassword(), LocalData.SmtpFrom(), LocalData.CSDbUsers(),
LocalData.LogPath(), LocalData.GetTemplatePath(), LocalData.Images());
smtp.SendNotice(out msg);
}
}
catch (Exception ex) { msg = ex.Message; ret = -1; }
return(ret);
}