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); } }