public async Task <IActionResult> Edit(int id, [Bind("ActivityId,ActivityName,ActivityTiming,ActivityCost,ActivityType,CreateDate,UpdateDate,IsActive,IsDelete")] TblActivity tblActivity)
{
if (id != tblActivity.ActivityId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblActivity);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblActivityExists(tblActivity.ActivityId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ActivityType"] = new SelectList(_context.TblActivityType, "ActivityTypeId", "ActivityTypeId", tblActivity.ActivityType);
return(View(tblActivity));
}
public async Task <IActionResult> Create([Bind("ActivityId,ActivityName,ActivityTiming,ActivityCost,ActivityType,CreateDate,UpdateDate,IsActive,IsDelete")] TblActivity tblActivity)
{
if (ModelState.IsValid)
{
_context.Add(tblActivity);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ActivityType"] = new SelectList(_context.TblActivityType, "ActivityTypeId", "ActivityTypeName");
return(View(tblActivity));
}
public bool WaterModelScheduleInsert(List <ScheduleModel> lstmodel)
{
foreach (var model in lstmodel)
{
var data = (from p in dbcontext.TblSchedules.Where(x => x.ScheduleId == model.ScheduleId) select p).FirstOrDefault();
dbcontext.TblSchedules.Remove(data);
dbcontext.SaveChanges();
TblSchedule obj = new TblSchedule();
obj.FrequencyDays = model.FrequencyDays;
obj.FrequencyNumber = model.FrequencyNumber;
obj.SampleId = model.SampleId;
obj.SampleName = model.SampleName;
obj.SampleLocation = model.SampleLocation;
obj.SampleType = model.SampleType;
obj.ScheduleDate = model.ScheduleDate;
obj.CreatedBy = model.CreatedBy;
obj.createdDate = DateTime.Now.ToString();
obj.ModifiedBy = model.ModifiedBy;
obj.ModifiedDate = DateTime.Now.ToString();
dbcontext.TblSchedules.Add(obj);
TblActivity objAct = new TblActivity();
objAct.FrequencyDays = model.FrequencyDays;
objAct.FrequencyNumber = model.FrequencyNumber;
objAct.SampleId = model.SampleId;
objAct.SampleLocation = model.SampleLocation;
objAct.SampleType = model.SampleType;
//objAct.ScheduleDate = model.ScheduleDate.ToString() ;
objAct.AcceptedReject = 0;
objAct.DeactivatedReason = "";
objAct.EndDate = DateTime.Now;
objAct.StartDate = DateTime.Now;
objAct.ScheduleDate = model.ScheduleDate;
dbcontext.TblActivities.Add(objAct);
}
dbcontext.SaveChanges();
return(true);
}
