public IEnumerable <USER_AUTHENTICATION> ListAllPaging(string BasicCriteria, string searchString, int page, int pageSize)
{
List <USER_AUTHENTICATION> Listmodel = new List <USER_AUTHENTICATION>();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["FarmHubDbContext"].ConnectionString);
con.Open();
SqlCommand command = null;
if (!string.IsNullOrEmpty(searchString))
{
command = new SqlCommand("SELECT Id_User,Name_User,Status_User From USER_AUTHENTICATION Where " + BasicCriteria + " Like '%" + searchString + "%' ");
}
command = new SqlCommand("SELECT * From USER_AUTHENTICATION ");
command.Connection = con;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
USER_AUTHENTICATION user = new USER_AUTHENTICATION();
user.Id_User = Convert.ToInt32(reader[0]);
user.Name_User = reader[2].ToString();
user.Status_User = Convert.ToByte(reader[5]);
//ua.Status_User = (Status)Convert.ToByte(reader[2]);
Listmodel.Add(user);
}
con.Close();
return(Listmodel.OrderByDescending(x => x.Created_Date).ToPagedList(page, pageSize));
}
// Create
public int Create(USER_AUTHENTICATION userAuthenModel)
{
userAuthenModel.Created_Date = DateTime.Now;
userAuthenModel.Status_User = 1;
db.USER_AUTHENTICATION.Add(userAuthenModel);
db.SaveChanges();
return(userAuthenModel.Id_User);
}
// Update
public bool Update(USER_AUTHENTICATION userAuthenModel)
{
var targetUpdate = db.USER_AUTHENTICATION.Find(userAuthenModel.Id_User);
try
{
targetUpdate.Id_UserKind = userAuthenModel.Id_UserKind;
targetUpdate.Name_User = userAuthenModel.Name_User;
targetUpdate.Password_User = userAuthenModel.Password_User;
targetUpdate.Created_Date = userAuthenModel.Created_Date;
targetUpdate.Status_User = userAuthenModel.Status_User;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
throw new Exception(e.Message);
}
}
public ActionResult Create(USER_AUTHENTICATION user)
{
if (ModelState.IsValid)
{
var dao = new UserDao();
var encryptorMD5Pass = Encryptor.MD5Hash(user.Password_User);
user.Password_User = encryptorMD5Pass;
int id = dao.Insert(user);
if (id > 0)
{
return(RedirectToAction("Index", "User"));
}
else
{
ModelState.AddModelError("", ErrorList.REGISTER_ERROR);
}
}
return(View("index"));
}
public int Insert(USER_AUTHENTICATION entity)
{
db.USER_AUTHENTICATION.Add(entity);
db.SaveChanges();
return(entity.Id_User);
}
