public ActionResult Edit(FileRegistration file) { int i=DAFileRegistration.UpdateFileById(file.FileId,file.Description); return RedirectToAction("Index"); }
public static FileRegistration GetFileRegistationById(int id) { FileRegistration file = new FileRegistration(); string sql = "SELECT * FROM FileRegistration WHERE FileId=@id"; DbParameter par1 = Database.AddParameter(CONNECTIONSTRING, "@id", id); DbDataReader data = Database.GetData(CONNECTIONSTRING, sql, par1); data.Read(); file.FileName = data["FileName"].ToString(); file.Description = data["Description"].ToString(); file.FileId = (int)data["FileId"]; file.UploadTime =(DateTime) data["UploadTime"]; file.UserName = data["UserName"].ToString(); return file; }
public ActionResult Delete(FileRegistration file) { int i = file.FileId; DAFileRegistration.DeleteFileById(i); return RedirectToAction("index"); }
public static FileRegistration LoadFileById(int id) { FileRegistration f = new FileRegistration(); string sql = "SELECT a.FileId,a.Description,a.FileName,a.UploadTime,a.UserName FROM FileRegistration as a INNER JOIN FileUser as b ON a.FileId=b.FileId WHERE a.FileId=@id"; DbParameter par1 = Database.AddParameter(CONNECTIONSTRING, "@id", id); DbDataReader data = Database.GetData(CONNECTIONSTRING, sql, par1); data.Read(); f = Create(data); return f; }