public static List <string> RetrieveAllICareUser(string me)
{
var ret = UserViewModels.RetrieveICare(me);
ret.Sort();
return(ret);
}
private void StoreProjectMembers()
{
if (MemberList.Count > 0)
{
var sql = "delete from ProjectMembers where ProjectKey = '<ProjectKey>'";
sql = sql.Replace("<ProjectKey>", ProjectKey);
DBUtility.ExeLocalSqlNoRes(sql);
}
foreach (var item in MemberList)
{
var sql = "insert into ProjectMembers(ProjectKey,Name,Role) values('<ProjectKey>','<Name>','<Role>')";
sql = sql.Replace("<ProjectKey>", ProjectKey).Replace("<Name>", item.Name).Replace("<Role>", item.Role);
DBUtility.ExeLocalSqlNoRes(sql);
UserViewModels.UpdateUserProject(item.Name.ToUpper(), ProjectKey);
}
}
public static UserViewModels RetrieveUser(string username)
{
var sql = "select PassWD,Validated,Priority,UpdateDate from UserTable where UserName = N'<UserName>'";
sql = sql.Replace("<UserName>", username.ToUpper());
var dbret = DBUtility.ExeLocalSqlWithRes(sql, null);
if (dbret.Count > 0)
{
var ret = new UserViewModels();
ret.Email = username.ToUpper();
ret.Password = Convert.ToString(dbret[0][0]);
ret.Validated = Convert.ToInt32(dbret[0][1]);
ret.Priority = Convert.ToInt32(dbret[0][2]);
ret.UpdateDate = DateTime.Parse(Convert.ToString(dbret[0][3]));
return(ret);
}
return(null);
}
public static void RegisterUserAuto(string name)
{
var dbret = UserViewModels.RetrieveUser(name);
if (dbret == null)
{
var tempname = name.ToUpper();
if (!name.Contains("@"))
{
tempname = (name.Replace(" ", ".") + "@finisar.com").ToUpper();
}
var user = new UserViewModels();
user.Email = tempname;
user.Password = "******";
user.UpdateDate = DateTime.Now;
user.RegistUser();
UserViewModels.ActiveUser(user.Email);
}
}
