private void saveTrxPerformReview(int pId, int tId, int nilai, int pereview, int direview, string periode, string catatan, string name) { Trx_Perform_Review Trx_Perform_Review = new Trx_Perform_Review(); Trx_Perform_Review.PerformDetailId = pId; Trx_Perform_Review.TaskId = tId; Trx_Perform_Review.Score = nilai; Trx_Perform_Review.ReviewBy = pereview; Trx_Perform_Review.ReviewFor = direview; Trx_Perform_Review.Periode = periode; Trx_Perform_Review.Notes = catatan; Trx_Perform_Review.FileName = name; //Trx_Perform_Review.SubmitDate = date; db.Trx_Perform_Reviews.Add(Trx_Perform_Review); db.SaveChanges(); }
private void saveEditedTrx_Perform_Review(int TrxId, int PerformDetailId, int TaskId, int Score, int ReviewBy, int ReviewFor, string Periode, string Notes, string FileName) { Trx_Perform_Review Trx_Perform_Review = db.Trx_Perform_Reviews.Find(TrxId); Trx_Perform_Review.PerformDetailId = PerformDetailId; Trx_Perform_Review.TaskId = TaskId; Trx_Perform_Review.Score = Score; Trx_Perform_Review.ReviewBy = ReviewBy; Trx_Perform_Review.ReviewFor = ReviewFor; Trx_Perform_Review.Periode = Periode; Trx_Perform_Review.Notes = Notes; //Trx_Perform_Review.SubmitDate = date; if (Trx_Perform_Review.FileName == "") { Trx_Perform_Review.FileName = FileName; } db.Entry(Trx_Perform_Review).State = EntityState.Modified; db.SaveChanges(); }
//public ActionResult Delete(string FileName, int TaskId, int TrxId) //{ // string path = Server.MapPath("~/PerfReviewFiles/") + TaskId.ToString() + "/" + FileName; // if (System.IO.File.Exists(path)) // { // System.IO.File.Delete(path); // } // Trx_Perform_Review review = db.Trx_Perform_Reviews.Find(TrxId); // review.FileName = ""; // db.Entry(review).State = EntityState.Modified; // db.SaveChanges(); // return RedirectToAction("Edit", "Mst_Performance_Review", new { id = TaskId }); //} public ActionResult Delete(int TrxId) { Debug.WriteLine("Insert Success"); Trx_Perform_Review review = db.Trx_Perform_Reviews.Find(TrxId); int TaskId = review.TaskId; string FileName = review.FileName; string path = Server.MapPath("~/PerfReviewFiles/") + TaskId.ToString() + "/" + FileName; if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } //Trx_Perform_Review review = db.Trx_Perform_Reviews.Find(TrxId); review.FileName = ""; db.Entry(review).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Edit", "Mst_Performance_Review", new { id = TaskId })); }