public async Task <IActionResult> Edit(short id, [Bind("ActivityDetailWorkID,ActivityID,TotalSchool,ContractorID,ExpiryDate,Attachment")] ActivityDetailWork activityDetailWork) { if (id != activityDetailWork.ActivityDetailWorkID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(activityDetailWork); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ActivityDetailWorkExists(activityDetailWork.ActivityDetailWorkID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["ActivityID"] = new SelectList(_context.Activity, "ActivityID", "Description", activityDetailWork.ActivityID); return(View(activityDetailWork)); }
public async Task <IActionResult> Create(short id, [Bind("ActivityID,ProcurementPlanID,StepReferenceNo,Name,LotTotal,SchoolTotal,ProcurementFor,Description,EstimatedCost,ActualCost,MethodID,ReviewType,Status,IsCenceled,Remarks,CreatedDate,CreatedBy,UpdatedBy,UpdatedDate,ProjectNo")] Activity activity) { if (ModelState.IsValid) { var val = _context.Activity.Count(a => a.StepReferenceNo == activity.StepReferenceNo && a.ProcurementPlanID == id); if (val == 0) { activity.ActualCost = 0; activity.CreatedDate = DateTime.Now; activity.Status = 1; activity.ProcurementPlanID = id; if (id == 2) { activity.LotTotal = 1; } _context.Add(activity); await _context.SaveChangesAsync(); if (activity.ProcurementPlanID == 2)// where 2 is Works { ActivityDetailWork Obj = new ActivityDetailWork(); Obj.ActivityID = _context.Activity.Max(a => a.ActivityID); Obj.TotalSchool = activity.SchoolTotal; _context.Add(Obj); await _context.SaveChangesAsync(); } string msg = "Procurement: Added New Activity(" + _context.ProcurementPlan.Find(activity.ProcurementPlanID).Name + ")\nSTEP Reference# " + activity.StepReferenceNo + "\nName: " + activity.Name + "\nmore detail: http://eu.bep.org.pk"; ZongSMS ObjSMS = new ZongSMS(); var contacts = _context.Contact.Where(a => a.IsActive == true).ToList(); foreach (var contact in contacts) { ObjSMS.SendSingleSMS(msg, contact.ContactNumber); } return(RedirectToAction(nameof(Index), new { PPID = id })); } else { ViewBag.Error = "Activity No." + activity.StepReferenceNo.ToString() + " already exist!"; } } ViewBag.ReviewType = new SelectList(new[] { new { Id = "Prior Review", Name = "Prior Review" }, new { Id = "Post Review", Name = "Post Review" }, }, "Id", "Name"); ViewBag.ProcurementFor = new SelectList(new[] { new { Id = "1", Name = "Schools" }, new { Id = "2", Name = "Office" }, }, "Id", "Name", activity.ProcurementFor); ViewBag.MethodID = new SelectList(_context.Method, "MethodID", "Name", activity.MethodID); ViewBag.ProjectNo = new SelectList(_context.Project, "ProjectNo", "ProjectName", 2); ViewBag.ProcurementPlanID = new SelectList(_context.ProcurementPlan.Where(a => a.ProcurementPlanID == id), "ProcurementPlanID", "Name", activity.ProcurementPlanID); return(View(activity)); }
public async Task <IActionResult> Create([Bind("ActivityDetailWorkID,ActivityID,TotalSchool,ContractorID,ExpiryDate,Attachment")] ActivityDetailWork activityDetailWork) { if (ModelState.IsValid) { _context.Add(activityDetailWork); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["ActivityID"] = new SelectList(_context.Activity, "ActivityID", "Description", activityDetailWork.ActivityID); return(View(activityDetailWork)); }
public async Task <IActionResult> Edit(string PPName, int ActualCost, [Bind("StepID,ActivityID,NotApplicable,PlannedDate,ActualDate,Attachment,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate")] ActivityDetail activityDetail, IFormFile Attachment, DateTime ExpiryDate, short CID) { if (ModelState.IsValid) { try { if (activityDetail.NotApplicable == true) { activityDetail.Attachment = null; activityDetail.ActualDate = null; activityDetail.PlannedDate = null; } else { if (Attachment != null) { var rootPath = Path.Combine( Directory.GetCurrentDirectory(), "wwwroot\\Documents\\Procurement\\"); string fileName = Path.GetFileName(Attachment.FileName); fileName = fileName.Replace("&", "n"); string AName = _context.Activity.Find(activityDetail.ActivityID).Name; AName = AName.Replace("&", "n"); //var PPName = _context.ProcurementPlan.Find(activityDetail.Step.ProcurementPlanID).Name; activityDetail.Attachment = Path.Combine("/Documents/Procurement/", PPName + "/" + "//" + AName + "//" + activityDetail.StepID + "//" + fileName);//Server Path //_context.ActivityDetail.Add(activityDetail); string sPath = Path.Combine(rootPath + PPName + "/" + AName + "/", activityDetail.StepID.ToString()); if (!System.IO.Directory.Exists(sPath)) { System.IO.Directory.CreateDirectory(sPath); } string FullPathWithFileName = Path.Combine(sPath, fileName); using (var stream = new FileStream(FullPathWithFileName, FileMode.Create)) { await Attachment.CopyToAsync(stream); } } } Activity activityObj = _context.Activity.Find(activityDetail.ActivityID); activityObj.ActualCost = ActualCost; //_context.Update(activityObj); _context.Update(activityDetail); await _context.SaveChangesAsync(); if (activityDetail.StepID == 21) { ActivityDetailWork Obj = _context.ActivityDetailWork.Where(a => a.ActivityID == activityDetail.ActivityID).FirstOrDefault(); Obj.ContractorID = CID; Obj.ExpiryDate = ExpiryDate; _context.Update(Obj); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Edit), new { activityDetail.ActivityID, activityDetail.StepID })); } } catch (DbUpdateConcurrencyException) { if (!ActivityDetailExists(activityDetail.ActivityID)) { return(NotFound()); } else { throw; } } if (activityDetail.StepID == 8) { return(RedirectToAction(nameof(Edit), new { activityDetail.ActivityID, activityDetail.StepID })); } else { return(RedirectToAction(nameof(Edit), "Activities", new { id = activityDetail.ActivityID })); } } ViewData["ActivityID"] = new SelectList(_context.Activity, "ActivityID", "Description", activityDetail.ActivityID); ViewData["StepID"] = new SelectList(_context.Step, "StepID", "StepID", activityDetail.StepID); return(View(activityDetail)); }