public static dynamic SaveAccountAvatar(USUsers dto) { DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "user_users", new string[] { "@flag", "@Id", "@Avatar" }, new object[] { "SaveAccountAvatar", dto.Id, dto.Avatar }); return((from r in tabl.AsEnumerable() select new { N = (int)(r["N"]), }).FirstOrDefault()); }
public static dynamic DeleteItem(USUsers dto) { DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "user_users", new string[] { "@flag", "@Id", "@ModifiedBy" }, new object[] { "DeleteItem", dto.Id, dto.ModifiedBy }); return((from r in tabl.AsEnumerable() select new { N = (int)(r["N"]), }).FirstOrDefault()); }
public static dynamic SaveAccountInfo(USUsers dto) { DateTime Birthday = DateTime.Now; if (dto.BirthdayShow != null) { Birthday = DateTime.ParseExact(dto.BirthdayShow, "dd/MM/yyyy", CultureInfo.InvariantCulture); } dto.Birthday = Int32.Parse(Birthday.ToString("yyyyMMdd")); DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "user_users", new string[] { "@flag", "@Id", "@FullName", "@Status", "@Telephone", "@Email", "@Description", "@Gender", "@Password", "@Birthday", "@UserCode", "@Specialize", "@IdRegency" }, new object[] { "SaveAccountInfo", dto.Id, dto.FullName, dto.Status, dto.Telephone, dto.Email, dto.Description, dto.Gender, dto.Password, dto.Birthday, dto.UserCode, dto.Specialize, dto.IdRegency }); return((from r in tabl.AsEnumerable() select new { N = (int)(r["N"]), }).FirstOrDefault()); }
public static USUsers GetItem(int Id, string SecretId = null) { DataTable tabl = ConnectDb.ExecuteDataTableTask(Startup.ConnectionString, "user_users", new string[] { "@flag", "@Id" }, new object[] { "GetItem", Id }); USUsers item = (from r in tabl.AsEnumerable() select new USUsers { Id = (int)r["Id"], IdGroup = (int)r["IdGroup"], FullName = (string)((r["FullName"] == System.DBNull.Value) ? "" : r["FullName"]), UserName = (string)((r["UserName"] == System.DBNull.Value) ? "" : r["UserName"]), UserCode = (string)((r["UserCode"] == System.DBNull.Value) ? "" : r["UserCode"]), Specialize = (string)((r["Specialize"] == System.DBNull.Value) ? "" : r["Specialize"]), Avatar = (string)((r["Avatar"] == System.DBNull.Value) ? "" : r["Avatar"]), Birthday = (int)((r["Birthday"] == System.DBNull.Value) ? Int32.Parse(DateTime.Now.ToString("yyyyMMdd")) : r["Birthday"]), Status = (byte)r["Status"], Gender = (byte)r["Gender"], Email = (string)((r["Email"] == System.DBNull.Value) ? "" : r["Email"]), Description = (string)((r["Description"] == System.DBNull.Value) ? "" : r["Description"]), Telephone = (string)((r["Telephone"] == System.DBNull.Value) ? "" : r["Telephone"]), IdCoQuan = (int)((r["IdCoQuan"] == System.DBNull.Value) ? 0 : r["IdCoQuan"]), IdRegency = (int)((r["IdRegency"] == System.DBNull.Value) ? 0 : r["IdRegency"]), Ids = MyModels.Encode((int)r["Id"], SecretId) }).FirstOrDefault(); if (item.Birthday == 0) { item.BirthdayShow = DateTime.Now.ToString("dd/MM/yyyy"); } else { item.BirthdayShow = DateTime.ParseExact(item.Birthday.ToString(), "yyyyMMdd", CultureInfo.InvariantCulture).ToString("dd/MM/yyyy"); } return(item); }