public void SaveTaskType(TaskType taskType) { #region sql var sql = @" if not exists(select * from TaskType where TaskTypeID = @TaskTypeID) begin update TaskType set Label = @Label where TaskTypeID = @TaskTypeID end else begin insert into TaskType( Label )values( @Label ); select scope_identity() as 'TaskTypeID' end "; #endregion using (var cmd = new SqlCommand(sql)) { cmd.Parameters.Add("@TaskTypeID", SqlDbType.Int).Value = taskType.TaskTypeID; cmd.Parameters.Add("@Label", SqlDbType.VarChar, 50).Value = taskType.Label; var id = _simpleTasks.ExecuteScalar<int>(cmd); if (taskType.TaskTypeID == 0) { taskType.TaskTypeID = id; } } }
public ActionResult SaveTaskType(TaskType item) { _service.SaveTaskType(item); return RedirectToAction("ListTaskTypes"); }
public void SaveTaskType(TaskType taskType) { _adminRepo.SaveTaskType(taskType); }